Qdabra qRules

Re: InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

SDaluga — Mon, 15 Aug 2011 22:37:01 GMT

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.

Re: InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

Patrick Halstead — Fri, 12 Aug 2011 07:12:06 GMT

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?

Re: InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

DalugaS — Thu, 11 Aug 2011 21:26:35 GMT

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

Re: InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

Hilary Stoupa — Wed, 03 Aug 2011 21:42:18 GMT

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?

Re: InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

DalugaS — Wed, 03 Aug 2011 21:28:13 GMT

Here is the UDC file XML from the SharePoint connection library.

Any clues here?

<?xml version="1.0" ?>

<?MicrosoftWindowsSharePointServices ContentTypeID="0x010100B4CBD48E029A4ad8B62CB0E41868F2B0"?>

- <udc:DataSource MajorVersion="2" MinorVersion="0" xmlns:udc="http://schemas.microsoft.com/office/infopath/2006/udc">

<udc:Name>ShPListSubmit</udc:Name>

<udc:Description>Format: UDC V2; Connection Type: WebService; Purpose: WriteOnly; Generated by Microsoft InfoPath 2010 on 2011-08-02 at 12:27:07 by s.</udc:Description>

- <udc:Type MajorVersion="2" MinorVersion="0" Type="WebService">

<udc:SubType MajorVersion="0" MinorVersion="0" Type="" />

</udc:Type>

- <udc:ConnectionInfo Purpose="ReadWrite" AltDataSource="">

<udc:WsdlUrl>http://usmrdwbs188:8888/Reports/_vti_bin/lists.asmx?WSDL</udc:WsdlUrl>

- <udc:SelectCommand>

<udc:ListId />

<udc:WebUrl />

<udc:ConnectionString />

<udc:ServiceUrl UseFormsServiceProxy="false" />

<udc:SoapAction />

<udc:Query />

</udc:SelectCommand>

- <udc:UpdateCommand>

<udc:ServiceUrl UseFormsServiceProxy="false">http://usmrdwbs188:8888/Reports/_vti_bin/lists.asmx</udc:ServiceUrl>

<udc:SoapAction>http://schemas.microsoft.com/sharepoint/soap/UpdateListItems</udc:SoapAction>

<udc:Submit />

<udc:FileName>Specify a filename or formula</udc:FileName>

<udc:FolderName AllowOverwrite="" />

</udc:UpdateCommand>

- <!--

udc:Authentication><udc:SSO AppId='' CredentialType='' /></udc:Authentication

--> f(clean);

</udc:ConnectionInfo>

</udc:DataSource>

Re: InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

DalugaS — Wed, 03 Aug 2011 21:28:11 GMT

Here is the UDC file XML from the SharePoint connection library.

Any clues here?

<?xml version="1.0" ?>

<?MicrosoftWindowsSharePointServices ContentTypeID="0x010100B4CBD48E029A4ad8B62CB0E41868F2B0"?>

- <udc:DataSource MajorVersion="2" MinorVersion="0" xmlns:udc="http://schemas.microsoft.com/office/infopath/2006/udc">

<udc:Name>ShPListSubmit</udc:Name>

<udc:Description>Format: UDC V2; Connection Type: WebService; Purpose: WriteOnly; Generated by Microsoft InfoPath 2010 on 2011-08-02 at 12:27:07 by s.</udc:Description>

- <udc:Type MajorVersion="2" MinorVersion="0" Type="WebService">

<udc:SubType MajorVersion="0" MinorVersion="0" Type="" />

</udc:Type>

- <udc:ConnectionInfo Purpose="ReadWrite" AltDataSource="">

<udc:WsdlUrl>http://usmrdwbs188:8888/Reports/_vti_bin/lists.asmx?WSDL</udc:WsdlUrl>

- <udc:SelectCommand>

<udc:ListId />

<udc:WebUrl />

<udc:ConnectionString />

<udc:ServiceUrl UseFormsServiceProxy="false" />

<udc:SoapAction />

<udc:Query />

</udc:SelectCommand>

- <udc:UpdateCommand>

<udc:ServiceUrl UseFormsServiceProxy="false">http://usmrdwbs188:8888/Reports/_vti_bin/lists.asmx</udc:ServiceUrl>

<udc:SoapAction>http://schemas.microsoft.com/sharepoint/soap/UpdateListItems</udc:SoapAction>

<udc:Submit />

<udc:FileName>Specify a filename or formula</udc:FileName>

<udc:FolderName AllowOverwrite="" />

</udc:UpdateCommand>

- <!--

udc:Authentication><udc:SSO AppId='' CredentialType='' /></udc:Authentication

--> f(clean);

</udc:ConnectionInfo>

</udc:DataSource>

Re: InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

Patrick Halstead — Wed, 03 Aug 2011 06:45:56 GMT

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.

Re: InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

DalugaS — Tue, 02 Aug 2011 22:32:04 GMT

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?

Re: InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

DalugaS — Tue, 02 Aug 2011 17:48:59 GMT

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.™

Re: InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

Hilary Stoupa — Mon, 01 Aug 2011 20:06:44 GMT

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.

InfoPath 2010 Qdabra Browser Compatibilty - Submit to SharePoint List

DalugaS — Fri, 29 Jul 2011 22:41:34 GMT

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 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.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