General

Re: SendToSharePointList Failed

Hilary Stoupa — Mon, 25 Aug 2014 20:58:45 GMT

Awesome detective work and thanks for posting that!

Re: SendToSharePointList Failed

Jeff Middleton — Mon, 25 Aug 2014 20:49:29 GMT

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.

Re: SendToSharePointList Failed

Hilary Stoupa — Mon, 25 Aug 2014 20:05:57 GMT

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.

Re: SendToSharePointList Failed

Jeff Middleton — Mon, 25 Aug 2014 19:12:13 GMT

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.

Re: SendToSharePointList Failed

Hilary Stoupa — Mon, 25 Aug 2014 19:00:54 GMT

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.

SendToSharePointList Failed

Jeff Middleton — Mon, 25 Aug 2014 18:40:20 GMT

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.