InfoPath Dev

Hi all, I need your help with an IP 2013 browser form that submits data to a SP 2013 form library. The form also sends data to 2 different custom lists using qRules SubmitToSharePointList 5.1. The form submits data just fine when I use the preview in IP but when I publish it to SP and use it from the browser it does not send data to the lists. I have tried adding a rule to the finishedLoading command(TRUE) to set useWebServices to TRUE and also to set useBrowserAPI to TRUE without any luck. I set the extendedErrorMessages to TRUE but I have NO errors whatsoever. Everything should be working fine but isn't. I also tried re-injecting the form, re-creating the mapping.xml but so far, no luck. Can any of you gurus please help me out and shine some light? Thanks in advance, Gus

Hi Gus,

I understand the Error node isn't returning any results. Is Success or Result showing anything? Those nodes (from QdabraRules) can be displayed on the view to help troubleshoot.

Also check whether the postback settings are set to Always. It may be that the command isn't executing at all due to this setting.

Let us know what you find. Thanks!

Hi Ernesto, Thanks for your help! Checked the Submit button which runs the qRules command and the postback settings are set to always. I added the Success and Result fields and I get nothing. Does that mean the command is not executing at all? Please let me know what else to look for. Best, Gus

I'd check whether there are conditions preventing the rules from executing.

If you want to attach the form, we can take a look. Thanks.

I can see an error now!! I ran it in the IP preview and it displays the following error: "Action: SubmitToSharePointList. Arguments: submit: ShpList dsname: IncludeAttachments . Details: Could not load file or assembly 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.. Stack: at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList_Browser(XPathNavigator mappingNode, String idXpath, String attachmentXpath, String name, String namexpath, String nameFormat, Boolean clear) at Qdabra.Tools.RulesLibrary.Commands.PerformSubmitToSharePointList() at Qdabra.Tools.RulesLibrary.Commands.RunCommand(String commandName) at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()" I have no idea what it means. Attached is my form.

I think that is because you have @useBrowserApi set to true - I'd expect this error in preview in that case. Can you change that rule to set @useWebServices instead, verify in preview, and if there are no errors, publish to SharePoint?

Oh, and do make sure to disable your Close the form rule prior to publishing so you can test in the browser and see if there are any errors in the Error node.

Hi Hilary! Thanks for your help. As you predicted, when I set it back to useWebServices the error disappeared from the preview. I published and now I got a huge error that I don't know how to resolve, it looks to me like a permissions error but I don't know who to grant the permissions and where: "Failed to submit to SharePoint. URL = 'http://intranet.inrangesystems.com/departments/hr/_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. | Failed to submit to SharePoint. URL = 'http://intranet.inrangesystems.com/departments/hr/_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."

Have you been able to use the Lists web service from a browser form in your environment before?

As a matter of fact, I have not. I'm in the process of migrating from MOSS2007 to SP 2013 and this is the first form I try to migrate. I migrated the content fine and I can open existing forms but this is the first form that I try.

I wonder if you need to disable loopback check on the new server.

I tried that but still no luck :(

Are you publishing directly to a form library?

It is an admin approved form (expense report) and I publish it to a form library and that works fine. At the same time, it uses qRules SubmitToSHarePointList to populate 2 different custom lists, one with expense detail from a repeating table and the other list with totals. The form has been working fine in MOSS 2007 for a while. The form is based on one of your tutorials way back and I have done all you have taught me :) to make it work but so far no success.

I'm guessing the issue is with the new SharePoint Server. What is the error if you DON'T set use web services to true?