InfoPath Dev

Hello Qdabra,

I have created an InfoPath 2010 form that submits to a SharePoint list without issue from the client application as described http://www.infopathdev.com/files/folders/qrules/entry49216.aspx.  However when I deploy the form to SharePoint 2010 the form throws an error.  My account is a farm administrator and has full permissions to the list.  Is QRules 3.2 browser compatible?  I am using the two week trial that expires in two weeks.

If you fix this for me I will certainly recommend your product.  Here is to hoping.

Here is the error message from the Qdabra Error field in the form: 

Failed to submit to SharePoint. URL = 'http://usmrdwbs188:8888/reports/_vti_bin/lists.asmx'. 

• I can address this url on the server itself and my local machine.

 

Here is the error from the hive.

SoapAction: "http://schemas.microsoft.com/sharepoint/soap/UpdateListItems"             55c9dd20-478d-4f4d-b5b5-9e5554cb4ac1

07/28/2011 16:43:06.39 w3wp.exe (0x4064)                       0x3298  SharePoint Foundation                 General                                fbv6                Medium               <?xml version="1.0" encoding="utf-8"?><SOAP-ENV:Envelope xmlns:SOAPSDK1="http://www.w3.org/2001/XMLSchema" xmlns:SOAPSDK2="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAPSDK3="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><tns:UpdateListItems xmlns:tns="http://schemas.microsoft.com/sharepoint/soap/"><tns:listName>{E9DAF7AA-8F13-4333-84A2-01E9E111A810}</tns:listName><tns:updates><Batch OnError="Continue"><Method ID="1" Cmd="New"><Field Name="ReportName">Report1</Field><Field Name="ReportParameterSet">dsfsdf</Field><Field Name="LevelId">333</Field><Field Name="ReportPackageName">asdasdsa</Field><Field Name="StartDate">2011-07-28</Field><Field Name="EndDate">2011-07-29</Field><Field Name="FrequencyChoice">Daily</Fiel...               55c9dd20-478d-4f4d-b5b5-9e5554cb4ac1

07/28/2011 16:43:06.39*               w3wp.exe (0x4064)                       0x3298  SharePoint Foundation                 General                                       fbv6       Medium               ...d><Field Name="DailyDayComb"></Field><Field Name="WeekWeelyRepeat"></Field><Field Name="WeeklyDayComb"></Field><Field Name="MonCalDays"></Field><Field Name="MonthDayComb"></Field><Field Name="DistFormat">CSV</Field><Field Name="DistEmail">false</Field><Field Name="EmailSubject"></Field><Field Name="EmailBody"></Field><Field Name="ToDoSubj">false</Field><Field Name="ToDoSubj"></Field><Field Name="ToDoBody"></Field></Method></Batch></tns:updates></tns:UpdateListItems></SOAP-ENV:Body></SOAP-ENV:Envelope>                55c9dd20-478d-4f4d-b5b5-9e5554cb4ac1

07/28/2011 16:43:06.39 w3wp.exe (0x4064)                       0x3298  SharePoint Foundation                 Logging Correlation Data                      xmnv     Medium               Site=/reports     55c9dd20-478d-4f4d-b5b5-9e5554cb4ac1

07/28/2011 16:43:06.41 w3wp.exe (0x4064)                       0x3298  SharePoint Foundation                 General                                8e2s                Medium               Unknown SPRequest error occurred. More information: 0x80070005      55c9dd20-478d-4f4d-b5b5-9e5554cb4ac1

07/28/2011 16:43:06.41 w3wp.exe (0x4064)                       0x3298  SharePoint Foundation                 General                                8e2s                Medium               Unknown SPRequest error occurred. More information: 0x80070005      55c9dd20-478d-4f4d-b5b5-9e5554cb4ac1

07/28/2011 16:43:06.41 w3wp.exe (0x4064)                       0x3298  SharePoint Foundation                 General                                avfx                High       SOAP exception: System.Threading.ThreadAbortException: Thread was being aborted.     at Microsoft.SharePoint.SoapServer.ListDataImpl.ConstructCaml(String strListName, String strXmlData, Boolean useHarmonicaKnowledge, Boolean useVersionHistory)     at Microsoft.SharePoint.SoapServer.ListDataImpl.UpdateListItems(String strListName, String strXmlData)     at Microsoft.SharePoint.SoapServer.ListDataValidatorImpl.UpdateListItems(String strListName, String strXmlData)     at Microsoft.SharePoint.SoapServer.Lists.UpdateListItems(String listName, SoapXmlElement updates)      55c9dd20-478d-4f4d-b5b5-9e5554cb4ac1

07/28/2011 16:43:06.41 w3wp.exe (0x4064)                       0x3298  SharePoint Foundation                 Monitoring                         b4ly                Medium               Leaving Monitored Scope (Request (POST:http://usmrdwbs188:8888/reports/_vti_bin/lists.asmx)). Execution Time=29.3475148377797          55c9dd20-478d-4f4d-b5b5-9e5554cb4ac1

07/28/2011 16:43:06.55 w3wp.exe (0x4064)                       0x3608  SharePoint Foundation                 Monitoring                                    nasq      Medium               Entering monitored scope (Request (POST:http://usmrdwbs188:8888/reports/_vti_bin/lists.asmx))

07/28/2011 16:43:06.55 w3wp.exe (0x4064)                       0x3608  SharePoint Foundation                 Logging Correlation Data                      xmnv     Medium               Name=Request (POST:http://usmrdwbs188:8888/reports/_vti_bin/lists.asmx) e4e4d230-d55d-483a-8672-634fcbc5228b

07/28/2011 16:43:06.55 w3wp.exe (0x4064)                       0x3608  SharePoint Foundation                 General                                fbv5                Medium               SoapAction: "http://schemas.microsoft.com/sharepoint/soap/UpdateListItems"             e4e4d230-d55d-483a-8672-634fcbc5228b

07/28/2011 16:43:06.55 w3wp.exe (0x4064)                       0x3608  SharePoint Foundation                 General                                fbv6                Medium               <?xml version="1.0" encoding="utf-8"?><SOAP-ENV:Envelope xmlns:SOAPSDK1="http://www.w3.org/2001/XMLSchema" xmlns:SOAPSDK2="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAPSDK3="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><tns:UpdateListItems xmlns:tns="http://schemas.microsoft.com/sharepoint/soap/"><tns:listName>{E9DAF7AA-8F13-4333-84A2-01E9E111A810}</tns:listName><tns:updates><Batch OnError="Continue"><Method ID="1" Cmd="New"><Field Name="ReportName">Report1</Field><Field Name="ReportParameterSet">dsfsdf</Field><Field Name="LevelId">333</Field><Field Name="ReportPackageName">asdasdsa</Field><Field Name="StartDate">2011-07-28</Field><Field Name="EndDate">2011-07-29</Field><Field Name="FrequencyChoice">Daily</Fiel...               e4e4d230-d55d-483a-8672-634fcbc5228b

07/28/2011 16:43:06.55*               w3wp.exe (0x4064)                       0x3608  SharePoint Foundation                 General                                       fbv6       Medium               ...d><Field Name="DailyDayComb"></Field><Field Name="WeekWeelyRepeat"></Field><Field Name="WeeklyDayComb"></Field><Field Name="MonCalDays"></Field><Field Name="MonthDayComb"></Field><Field Name="DistFormat">CSV</Field><Field Name="DistEmail">false</Field><Field Name="EmailSubject"></Field><Field Name="EmailBody"></Field><Field Name="ToDoSubj">false</Field><Field Name="ToDoSubj"></Field><Field Name="ToDoBody"></Field></Method></Batch></tns:updates></tns:UpdateListItems></SOAP-ENV:Body></SOAP-ENV:Envelope>                e4e4d230-d55d-483a-8672-634fcbc5228b

07/28/2011 16:43:06.55 w3wp.exe (0x4064)                       0x3608  SharePoint Foundation                 Logging Correlation Data                      xmnv     Medium               Site=/reports     e4e4d230-d55d-483a-8672-634fcbc5228b

07/28/2011 16:43:06.56 w3wp.exe (0x4064)                       0x3608  SharePoint Foundation                 General                                8e2s                Medium               Unknown SPRequest error occurred. More information: 0x80070005      e4e4d230-d55d-483a-8672-634fcbc5228b

07/28/2011 16:43:06.56 w3wp.exe (0x4064)                       0x3608  SharePoint Foundation                 General                                8e2s                Medium               Unknown SPRequest error occurred. More information: 0x80070005      e4e4d230-d55d-483a-8672-634fcbc5228b

07/28/2011 16:43:06.58 w3wp.exe (0x4064)                       0x3608  SharePoint Foundation                 General                                avfx                High       SOAP exception: System.Threading.ThreadAbortException: Thread was being aborted.     at Microsoft.SharePoint.SoapServer.ListDataImpl.ConstructCaml(String strListName, String strXmlData, Boolean useHarmonicaKnowledge, Boolean useVersionHistory)     at Microsoft.SharePoint.SoapServer.ListDataImpl.UpdateListItems(String strListName, String strXmlData)     at Microsoft.SharePoint.SoapServer.ListDataValidatorImpl.UpdateListItems(String strListName, String strXmlData)     at Microsoft.SharePoint.SoapServer.Lists.UpdateListItems(String listName, SoapXmlElement updates)      e4e4d230-d55d-483a-8672-634fcbc5228b

07/28/2011 16:43:06.58 w3wp.exe (0x4064)                       0x3608  SharePoint Foundation                 Monitoring                         b4ly                Medium               Leaving Monitored Scope (Request (POST:http://usmrdwbs188:8888/reports/_vti_bin/lists.asmx)). Execution Time=38.3201635962113          e4e4d230-d55d-483a-8672-634fcbc5228b

07/28/2011 16:43:06.58 w3wp.exe (0x4064)                       0x3BBC InfoPath Forms Services               Runtime - Data Connections                    eq8m    Warning               Form submission failed. (User: 0#.w|aonus1\bsyed, Form Name: ReportPacakgesV2.3SRD, IP: , Request: http://usmrdwbs188:8888/reports/_layouts/FormServer.aspx?XsnLocation=http://usmrdwbs188:8888/reports/FormServerTemplates/ReportPacakgesV2.3SRD.xsn&SaveLocation=http://usmrdwbs188:8888/reports/ReportPackages&Source=http://usmrdwbs188:8888/reports/ReportPackages/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:ReportPacakgesV2-3SRD:-myXSD-2011-05-12T17-48-28, Type: DataAdapterException, Exception Message: The remote server returned an error: (403) Forbidden. The remote server returned an error: (403) Forbidden.)       62a97be7-cb30-4f8b-95c2-c2391cdce205

07/28/2011 16:43:06.61 w3wp.exe (0x4064)                        0x3BBC SharePoint Server                           State Service                      8kfs                Medium               The StateManager is disposing and calling ReleaseLockedStates() (Count=0)       62a97be7-cb30-4f8b-95c2-c2391cdce205

07/28/2011 16:43:06.61 w3wp.exe (0x4064)                        0x3BBC SharePoint Foundation                 Monitoring                         b4ly                Medium               Leaving Monitored Scope (Request (POST:http://usmrdwbs188:8888/reports/_layouts/Postback.FormServer.aspx)). Execution Time=316.439030658925                62a97be7-cb30-4f8b-95c2-c2391cdce205

07/28/2011 16:43:06.69 w3wp.exe (0x4064)                       0x3298  SharePoint Foundation                 Monitoring                                    nasq      Medium               Entering monitored scope (WorkflowTelemetryScope) 

07/28/2011 16:43:06.78 w3wp.exe (0x4064)                       0x3298  SharePoint Foundation                 Monitoring                         b4ly                High       Leaving Monitored Scope (EnsureListItemsData). Executio

qRules has many commands that are browser compatible. SubmitToSharePoint list is one of them.

Here's the bit in the log that matters:

07/28/2011 16:43:06.58 w3wp.exe (0x4064)                       0x3BBC InfoPath Forms Services               Runtime - Data Connections                    eq8m    Warning               Form submission failed. (User: 0#.w|aonus1\bsyed, Form Name: ReportPacakgesV2.3SRD, IP: , Request: http://usmrdwbs188:8888/reports/_layouts/FormServer.aspx?XsnLocation=http://usmrdwbs188:8888/reports/FormServerTemplates/ReportPacakgesV2.3SRD.xsn&SaveLocation=http://usmrdwbs188:8888/reports/ReportPackages&Source=http://usmrdwbs188:8888/reports/ReportPackages/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:ReportPacakgesV2-3SRD:-myXSD-2011-05-12T17-48-28, Type: DataAdapterException, Exception Message: The remote server returned an error: (403) Forbidden. The remote server returned an error: (403) Forbidden.)       62a97be7-cb30-4f8b-95c2-c2391cdce205

The form is using a data connection to submit to a web service.  The first thing I usually recommend is to verify that you can connect to SharePoint Web Services in your browser environment. Create a new browser form and add a connection to the CheckOutFile method of the lists web service. Make sure it works in client. Then publish to browser and see if your data connection works....

Parameters for the CheckOutFile method:

Parameters

pageUrl

A string that contains the full path to the document to be checked out.

checkoutToLocal

A string containing "true" or "false" that designates whether the file is to be flagged as checked out for offline editing.

lastmodified

A string in RFC 1123 date format representing the date and time of the last modification to the file; for example, "20 Jun 1982 12:00:00 GMT".

I leave lastmodified blank, and set checkoutToLocal = false.

Looping in Patrick's comments... 

 

Yes, qRules will work in the browser provided you enable the sandbox via central admin or publish as an admin deployed form template.

 

It looks like the issue from your form is related to the submit data connection to a Web Service. You may need to “Convert”the data connection to be a UDC file in a data collection library. If you’ve done that it may be due to server hop issues and you may need to set the credentials in the UDC file or use some kind of proxy. Anyway, those issues aren’t related to qRules.

 

Good luck!

 

Patrick Halstead / 425.296.7780

Qdabra® Software / InfoPathDev.com / 877.544.2389

The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

What is the credentials does the form use to cll the web service?  Does it take the credentials of the form submitter or the application pool account?

If you are using the InfoPath Filler it will be Windows Authentication credentials. If you are using the browser it is a SharePoint account or whatever S hardcoded in the UDC. You could also call GetUserProfile and set username and promote that on submit.

Not to be a bore, but did you ever try verifiying that you can connect to any SharePoint web service from a browser form in your environment as I suggested earlier in the thread?

Which service does a form in a browser use?  Is the account the application pool in IIS?

Hi DalugaS,

Your issue shouldn't have anything to do with IIS app pools. qRules is just a plugin.

Data connections for browser forms should be converted to UDC files. Did you do that? Can you connect to a SharePoint Web Service, like GetUserProfileInfo?

 

I GOT IT!!!  Thanks Hillary & Patrick. 

I needed to up the permissions for the service that SharePoint was using for InfoPath form.  The accounts was named SharePoint web services default under general security in CA.  It did not have contributer rights to the SharePoint list I was trying to write to, only reader rights.