1
Vote

SharePoint List Adapter Issues On Production

description

Hi All,

We are facing some strange issue on our production box after installing SharePoint List Adapter. Same configuration is working in DEV environment but not on PROD.

Here are the environment details
SQL Server 2012 Enterprise
SharePoint Server 2013 Enterprise
Windows Server 2012 R2 Standard

Used the msi mentioned in the recommended download from the download page. I am able to see the component (source and destination) in toolbox after after configuring the site and list throwing below error.

The component has detected potential metadata corruption during validation.
Error at Data Flow Task [SharePoint List Source [19]]: System.TypeLoadException: Could not load type 'System.Runtime.Diagnostics.ITraceSourceStringProvider' from assembly 'System.ServiceModel.Internals, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
at System.ServiceModel.Channels.TextMessageEncoderFactory..ctor(MessageVersion version, Encoding writeEncoding, Int32 maxReadPoolSize, Int32 maxWritePoolSize, XmlDictionaryReaderQuotas quotas)
at System.ServiceModel.Channels.HttpTransportDefaults.GetDefaultMessageEncoderFactory()
at System.ServiceModel.Channels.HttpChannelFactory1..ctor(HttpTransportBindingElement bindingElement, BindingContext context)
at System.ServiceModel.Channels.HttpsChannelFactory
1..ctor(HttpsTransportBindingElement httpsBindingElement, BindingContext context)
at System.ServiceModel.Channels.HttpsTransportBindingElement.BuildChannelFactory[TChannel](BindingContext context)
at System.ServiceModel.Channels.BindingContext.BuildInnerChannelFactoryTChannel
at System.ServiceModel.Channels.MessageEncodingBindingElement.InternalBuildChannelFactory[TChannel](BindingContext context)
at System.ServiceModel.Channels.TextMessageEncodingBindingElement.BuildChannelFactory[TChannel](BindingContext context)
at System.ServiceModel.Channels.BindingContext.BuildInnerChannelFactoryTChannel
at System.ServiceModel.Channels.Binding.BuildChannelFactory[TChannel](BindingParameterCollection parameters)
at System.ServiceModel.Channels.ServiceChannelFactory.BuildChannelFactory(ServiceEndpoint serviceEndpoint, Boolean useActiveAutoClose)
at System.ServiceModel.ChannelFactory.CreateFactory()
at System.ServiceModel.ChannelFactory.OnOpening()
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.ChannelFactory.EnsureOpened()
at System.ServiceModel.ChannelFactory1.CreateChannel(EndpointAddress address, Uri via)
at System.ServiceModel.ChannelFactory
1.CreateChannel()
at System.ServiceModel.ClientBase1.CreateChannel()
at System.ServiceModel.ClientBase
1.CreateChannelInternal()
at System.ServiceModel.ClientBase1.get_Channel()
at System.ServiceModel.ClientBase
1.get_InnerChannel()
at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.Adapter.ListsAdapter.ResetConnection()
at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.Adapter.ListsAdapter.InitializeObject(Uri sharepointUri, NetworkCredential credential)
at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListServiceUtility.GetFields(Uri sharepointUri, NetworkCredential credentials, String listName, String viewName)
at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.GetAccessibleSharePointColumns(String sharepointUrl, String listName, String viewName)
at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.ValidateSharePointColumns()
at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.Validate()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostValidate(IDTSManagedComponentWrapper100 wrapper)
Do you want to edit this component?

Appreciate your help.

Thanks
Swap

comments