locked
Error while updating data to Sharepoint RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    hi All,

    Good Day!

    There is a requirement to insert if there is a new record/update the existing record to Sharepoint. Am able to do Insert/Update to SharePoint if the data quantity is minimum, i.e, records in hundreds.

    link: http://thechriskent.com/2012/06/19/merging-data-into-a-sharepoint-list-using-ssis/

    if the records/data is more(in thousands), while updating to sharepoint, am getting below error. I tried to keep the minimal batch size, but still getting the same error.

    Is there any setting on Sharepoint that can be set to increase updation capability?

    Error details:

     System.ServiceModel.ProtocolException: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: '
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <html xmlns:o="urn:schemas-microsoft-com:office:office" lang="en-us" dir="ltr">
    <head><meta name="GENERATOR" content="Microsoft SharePoint" /><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><meta http-equiv="Expires" content="0" /><meta http-equiv="X-UA-Compatible" content="IE=8"/><meta name="ROBOTS" content="NOHTMLINDEX" /><title>

    Error

    </title><link rel="stylesheet" type="text/css" href="/_layouts/15/1033/styles/corev15.css?rev=ox%2BqLd6WTqhn6d%2FMqf2BMw%3D%3D"/>
    <link rel="stylesheet" type="text/css" href="/_layouts/15/1033/styles/error.css?rev=nc1850SZNy60qTAeQIRxsA%3D%3D"/>
    <script type="text/javascript" src="/_layouts/15/init.js?rev=%2FWTxr8UesytJ8GB%2F5hOwZA%3D%3D"></script>
    <script type="text/javascript" src="/ScriptResource.axd?d=Xk0NEdH2fPzV6iK_jX1QyxyIvX3d6qMyUR7g3X_pLj3803Il6KiE53vwcERQzD3Y0-q4UpveatXfBOG7tydAWu2111jN0cI3WJzgPH4-wITimoTuMbmI6xYdd85DKZebsn2'.

    Server stack trace: 
       at System.ServiceModel.Channels.HttpChannelUtilities.ValidateRequestReplyResponse(HttpWebRequest request, HttpWebResponse response, HttpChannelFactory factory, WebException responseException, ChannelBinding channelBinding)
       at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
       at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
       at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
       at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
       at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
       at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

    Exception rethrown at [0]: 
       at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoap.UpdateListItems(UpdateListItemsRequest request)
       at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoapClient.ListsService_ListsSoap_UpdateListItems(UpdateListItemsRequest request)
       at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoapClient.UpdateListItems(String listName, XElement updates)
       at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.Adapter.ListsAdapter.ExecuteSharePointUpdateBatch(String listName, String viewId, XElement batchXml, Int16 batchSize)
       at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListServiceUtility.UpdateListItems(Uri sharepointUri, NetworkCredential credentials, String listName, String viewName, IEnumerable`1 fieldValueList, Int16 batchSize)
       at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer)
       at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)

    what is the cause of this error?

    Please advise.

    Thanks,

    Raghavendra

    Wednesday, July 1, 2015 6:18 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Raghavendra,

    The error message “The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8).” is too general, we can use Fiddler to monitor the request to get the detail error message. Please refer to this document to use this tool:  Getting Started with Fiddler.

    Based on my experience, the issue always related to the followings:

    Besides, as to the issue about the settings on Sharepoint that can be set to increase updation capability, I suggest you can post it to SharePoint forum for better assistance:
    https://social.technet.microsoft.com/Forums/office/en-US/home?category=sharepoint

    Thanks,
    Katherine Xiong

    Katherine Xiong
    TechNet Community Support

    Friday, July 3, 2015 9:45 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    I did not have much exposure to SharePoint, but as far as I know it expects batch updates. So you need to feed data in chunks.

    Arthur

    MyBlog

    Twitter

    Thursday, July 2, 2015 3:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Raghavendra,

    The error message “The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8).” is too general, we can use Fiddler to monitor the request to get the detail error message. Please refer to this document to use this tool:  Getting Started with Fiddler.

    Based on my experience, the issue always related to the followings:

    Besides, as to the issue about the settings on Sharepoint that can be set to increase updation capability, I suggest you can post it to SharePoint forum for better assistance:
    https://social.technet.microsoft.com/Forums/office/en-US/home?category=sharepoint

    Thanks,
    Katherine Xiong

    Katherine Xiong
    TechNet Community Support

    Friday, July 3, 2015 9:45 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    were you able to get any solution for above?
    Tuesday, March 28, 2017 12:09 PM