Qdabra qRules

Re: Issue with submitting data to sharepoint list

ErnestoM — Thu, 23 Jun 2011 16:44:28 GMT

Hi Charles, I notice this thread has been inactive, but you purchased a product recently. Was there an outstanding issue we could help you with?

Re: Issue with submitting data to sharepoint list

Hilary Stoupa — Tue, 31 May 2011 14:59:46 GMT

Just wanted to update with additional information about what we discovered over the weekend -- calls to SharePoint web methods from an IP browser form fail in your environment. We tested with CheckOutFile -- verified the query worked correctly in client, admin approved the template and opened it and tried the query in the browser and had a failure. The log contained similar info to the previously posted log:

05/28/2011 11:52:51.88 w3wp.exe (0x2060) 0x23F8 SharePoint Foundation General 8e2s Medium Unknown SPRequest error occurred. More information: 0x80070005 7e3795ea-040e-40e2-84f4-83ec3c32cf1e
05/28/2011 11:52:51.89 w3wp.exe (0x2060) 0x23F8 SharePoint Foundation General avfx High SOAP exception: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at Microsoft.SharePoint.Utilities.SPUtilityInternal.SendResponse(HttpContext context, Int32 code, String strBody) at Microsoft.SharePoint.Utilities.SPUtility.HandleAccessDenied(HttpContext context) at Microsoft.SharePoint.Utilities.SPUtility.HandleAccessDenied(Exception ex) at Microsoft.SharePoint.Library.SPRequest.GetFileAndFolderProperties(String bstrUrl, String bstrStartUrl, ListDocsFlags ListDocsFlags, Boolean bThrowException, Int32& phrStatus, Object& pvarFiles, Object& pvarDirs, UInt32& pdwNumberOfFiles, UInt32& pdwNumberOfDirs) at Microsoft.ShareP... 7e3795ea-040e-40e2-84f4-83ec3c32cf1e

Re: Issue with submitting data to sharepoint list

chasquad — Sat, 28 May 2011 23:58:19 GMT

Jim

Thank you for responding to my recent post with our issues with submitting data via qrules data connections to SharePoint list. The only entry on that page is "local". We are still not able to get this working. The data connections submit successfully in InfoPath Filler but not in the browser. I've attached an image of the trusted certs page.

Any help is appreciated.

Re: Issue with submitting data to sharepoint list

Hilary Stoupa — Sat, 28 May 2011 00:12:14 GMT

Okee doke, it is on its way to you.

Re: Issue with submitting data to sharepoint list

chasquad — Fri, 27 May 2011 23:36:32 GMT

Thank you

I just realized that I had disabled some of the qrules data connections when I was trying to pin point the issue. I've attached an updated template with all connections enabled. Thank you for your help.

Re: Issue with submitting data to sharepoint list

Hilary Stoupa — Fri, 27 May 2011 23:30:21 GMT

I sure will -- I've got an email open to remind me to update the template and send it to you before I leave for the day. I've not forgotten you, I promise!

Re: Issue with submitting data to sharepoint list

chasquad — Fri, 27 May 2011 23:00:34 GMT

We're very excited that if we can get this to work it would be our first web-based form and will automate a few manual processes. We do appreciate any help you can provide. Please let me know if you have any questions about the template.

Re: Issue with submitting data to sharepoint list

chasquad — Fri, 27 May 2011 19:18:23 GMT

Thank you very much. I look forward to your response.

Re: Issue with submitting data to sharepoint list

Hilary Stoupa — Fri, 27 May 2011 19:07:58 GMT

Oh, got it - it just confused me. Makes sense. I don't see anything wrong. What I usually suspect for qRules issues in the browser but not the client are that 1) postback is not set (which you corrected) or 2) the ListCollection node in the mapping has a namespace (that is an issue that is ShP 2010 browser specific and I can see that your mapping has no namespace prefix on the ListCollection node).

I'll get your email from the membership list and send you an updated copy of your form later today that should give us more info to debug with (it may be pretty close to the end of the day before I have a chance to do this tho).

Re: Issue with submitting data to sharepoint list

chasquad — Fri, 27 May 2011 18:34:57 GMT

I changed the URL to "mysite" to try to hide our real URL from the public search engines that may be scanning your site. Also, I've made a few changes to the form in general since I first attached it. I've attached a new copy. I hope that these changes have not broken the form.

Re: Issue with submitting data to sharepoint list

Hilary Stoupa — Fri, 27 May 2011 18:25:51 GMT

What is odd to me is that the URL in the log and returned by qRules is pointed to "mysite" at all. Your form mapping and data connections are pointed to a different site all together. Or did you change the template?

Re: Issue with submitting data to sharepoint list

Jim Cantwell — Fri, 27 May 2011 18:23:26 GMT

When using SSL data connections, you must first configure SharePoint 2010 to trust the Root Certificate authority. In Central Admin, Security, Manage Trust, add the certificate for the root certificate authority. You will first need to export the certificate to import into SharePoint.

Re: Issue with submitting data to sharepoint list

chasquad — Fri, 27 May 2011 18:13:34 GMT

Yeah, I am able to browse to https://mysite/sites/hr/_vti_bin/lists.asmx and https://mysite:443/sites/hr/_vti_bin/lists.asmx

I wonder why it works in the InfoPath client but not in a browser-based form.

Thank you for your help.

Re: Issue with submitting data to sharepoint list

ErnestoM — Fri, 27 May 2011 18:06:30 GMT

Thanks for the additional info. In the error log I see reference to htps://mysite:443/sites/hr/_vti_bin/lists.asmx. In the error returned by qRules, we get https://mysite/sites/hr/_vti_bin/lists.asmx.

Are you able to open that URL in Internet Explorer? Can you try to see if there is a different with / without the :443 when opening the URL in IE? Thanks.

Re: Issue with submitting data to sharepoint list

chasquad — Fri, 27 May 2011 17:53:52 GMT

I enabled the postback settings and now when I click the button in the brower-based form I get the following errors

Result:
Success: false
Error: Failed to submit to SharePoint. URL = 'https://mysite/sites/hr/_vti_bin/lists.asmx'.

I've attached a text file with the relevant SharePoint log.