SendToSharePointList Failed - InfoPath Dev
in

InfoPath Dev

SendToSharePointList Failed

Last post 08-25-2014 01:58 PM by Hilary Stoupa. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 08-25-2014 11:40 AM

    SendToSharePointList Failed

    I am trying to edit data and save to a SharePoint List using Qrules.  If I preview my InfoPath form and try to submit data, everything works perfectly.  However, when I publish the form to my sharepoint site, I receive the following error:

    Error ocurred submitting data to list: Request failed. 

     

  • 08-25-2014 12:00 PM In reply to

    Re: SendToSharePointList Failed

    Hi, Jeff - I don't see your screenshot - you may want to attach under the Options tab in a reply. I'm guessing this is occurring when the form is opened in the browser, is that correct? In which case, what I usually try first is to find the QdabraRules finishedLoading node and add the following rule:

    Condition - finishedLoading = true

    Action - set a field's value - /QdabraRules/Form/@useWebServices from the QdabraRules data source - set the field to true (all lower case).

    This will force qRules to use the List Items web service for updates, so that the form behaves as it does in Preview.

    Hilary Stoupa

  • 08-25-2014 12:12 PM In reply to

    Hilary, Thank you for responding.  I made the change to my form that you suggested.  However, I receive a different error now.  I have attached a screenshot of the previous error as well.  The new error is a bit lengthy: 

     

    Failed to submit to SharePoint. URL = 'http://cb-sp-serv/matterintake/_vti_bin/lists.asmx'. Exception: Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterException: The remote server returned an error: (401) Unauthorized. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized.     at System.Net.HttpWebRequest.GetResponse()     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.GetResponseHelper(WebRequest request, DataAdapterCredentials credentials, Stopwatch timer, ExecWebRequestExceptionState state, String adapterName, Boolean isQuery)     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.ExecWebRequestSync(XPathNavigator inputSubDOM, Boolean[] inputUseDataset, XPathNavigator resultsSubDOM, Boolean resultUseDataset, XPathNavigator errorsSubDOM, Uri serviceUrl, Uri soapAction, Int64 timeOutMillisec, DataAdapter adapter, Document document, DataAdapterCredentials credentials, Boolean useDcl, Boolean useProxy, Boolean useSelf)     --- End of inner exception stack trace ---     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.HandleExecWebRequestException(Document document, Exception exception, ExecWebRequestExceptionState state, Byte[] exceptionResponse, Ids errorId)     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.ExecWebRequestSync(XPathNavigator inputSubDOM, Boolean[] inputUseDataset, XPathNavigator resultsSubDOM, Boolean resultUseDataset, XPathNavigator errorsSubDOM, Uri serviceUrl, Uri soapAction, Int64 timeOutMillisec, DataAdapter adapter, Document document, DataAdapterCredentials credentials, Boolean useDcl, Boolean useProxy, Boolean useSelf)     at Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterWebServiceSubmit.Execute(Document document, Uri soapAction, Uri serviceUrl, XPathNavigator querySubDOM, XPathNavigator resultsSubDOM, XPathNavigator errorsSubDOM, Int64 timeout, DataAdapterCredentials credentials, Boolean useDcl, Boolean useProxy, Boolean useSelf)     at Microsoft.Office.InfoPath.Server.DocumentLifetime.DataAdapterWebServiceSubmit.ExecuteInternal(XPathNavigator queryFields, XPathNavigator resultFields, XPathNavigator errors)     at Microsoft.Office.InfoPath.Server.DocumentLifetime.OMExceptionManager.ExecuteOMCallWithExceptions(OMCall d, ExceptionFilter exceptionFilter) LogId: 5567 Details: System.Net.WebException: The remote server returned an error: (401) Unauthorized.     at System.Net.HttpWebRequest.GetResponse()     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.GetResponseHelper(WebRequest request, DataAdapterCredentials credentials, Stopwatch timer, ExecWebRequestExceptionState state, String adapterName, Boolean isQuery)     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.ExecWebRequestSync(XPathNavigator inputSubDOM, Boolean[] inputUseDataset, XPathNavigator resultsSubDOM, Boolean resultUseDataset, XPathNavigator errorsSubDOM, Uri serviceUrl, Uri soapAction, Int64 timeOutMillisec, DataAdapter adapter, Document document, DataAdapterCredentials credentials, Boolean useDcl, Boolean useProxy, Boolean useSelf). Full error node text: No error node text available.


  • 08-25-2014 01:05 PM In reply to

    Re: SendToSharePointList Failed

    A couple other options - one may be to disable loopback check on the SharePoint server - I think that will resolve this error. Another would be to not set useWebServices to true (undo the rule I had you add) and publish the form as full trust - admin approving the template via Central Admin instead of publishing directly to the SharePoint Library.

    Hilary Stoupa

  • 08-25-2014 01:49 PM In reply to

    Re: SendToSharePointList Failed

    Hilary, I ran across this and changed the url for my submit data connections to access my server via ip rather than server name.  Not sure why but this seems to have fixed the issue. 

     

  • 08-25-2014 01:58 PM In reply to

    Re: SendToSharePointList Failed

    Awesome detective work and thanks for posting that!

    Hilary Stoupa

Page 1 of 1 (6 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.