Qdabra qRules

Re: Failed to submit to SharePoint. URL

Hilary Stoupa — Thu, 17 Nov 2011 22:23:53 GMT

Thanks for sending your template.

Everything really looks fine – I don’t see any conditions some place that would have been causing your rule not to fire, or any preceding rules with the “don’t run following rules if this is met” check box selected.

So, here’s what I’d suggest as to next steps for trying to troubleshoot what’s up.

Create a new blank browser form. No qRules in it.

Add a data connection to the CheckOutFile method of the lists web service (documentation here: http://msdn.microsoft.com/en-us/library/lists.lists.checkoutfile(v=office.12).aspx ):
https://server.com/site/_vti_bin/Lists.asmx

This method takes three parameters. The first, pageUrl, should be the full path to a file. So, say you have a file called “Test.txt” on Shared Documents on a site named "site", the param should be:
https://server.com/site/Shared Documents/Test.txt

The second param should be set to false, and leave the third blank.

Set the data connection to not run on load. On your form, drag over the pageURL field from the new data connection. Add a button. Set the button to query the new data connection. Go ahead and set postback = always on the button, just ‘cause I don’t trust IPFS.

Publish your new form and open it in the browser. Enter the value of a file that you know exists in the pageURL field, and click the button. Your file should be checked out if you go look at in the library. Check it in and try again.

The purpose of this is to see if this data connection also occasionally fails. Don’t wear your mouse out clicking, but do give it a thorough test. In general, when I’ve seen problems with web service data connections in IPFS, we’ll see it with all of them.

If this isn’t it, I’ll see about injecting your form with an updated version of qRules. I can add to the code to see if we can get better error message info back. But first I would like to see if we can get a sense of whether it is the web service.

Re: Failed to submit to SharePoint. URL

Hilary Stoupa — Thu, 17 Nov 2011 20:55:49 GMT

I wonder if you would have the same intermittent failures with other SharePoint web services (at least, I'm anticipating that's where the failure is). Do you mind emailing me a copy of your form? I'll email you via the forum you have my email address.

Re: Failed to submit to SharePoint. URL

mgdukes — Thu, 17 Nov 2011 18:51:03 GMT

Yes, I checked the SharePoint log files. I didnt see anything in there.I havent noticed any pattern with the time frame of when I submit. I could submit several in a row and have one fail or I could do one a day and have the same issue. Previously I had been receiving “You do not have permissions to access a Web service that provides data required for this form to function correctly.” Adding the root CA to each of my web servers seemed to fix that issue.

Re: Failed to submit to SharePoint. URL

Hilary Stoupa — Thu, 17 Nov 2011 18:39:44 GMT

That's interesting - so it is an inconsistent failure, with no errors in the SharePoint log files (just to be sure - you checked the actual folder of log files, not event viewer, correct?). What kind of time range between submits?

Re: Failed to submit to SharePoint. URL

mgdukes — Thu, 17 Nov 2011 17:42:39 GMT

Its usually a new xml i will have several forms successfully submit and then one will fail. If you resubmit the same form several times it will also eventually fail.

Re: Failed to submit to SharePoint. URL

Hilary Stoupa — Thu, 17 Nov 2011 16:58:40 GMT

Fourth or fifth time from the same XML? or new forms each time?

Re: Failed to submit to SharePoint. URL

mgdukes — Thu, 17 Nov 2011 16:36:06 GMT

Currently I am running version 3.1

I can reproduce it. It will usually fail around the fourth or fifth time I submit.

And no nothing in the logs.

Re: Failed to submit to SharePoint. URL

Hilary Stoupa — Thu, 17 Nov 2011 16:30:17 GMT

Is this reproducible? Or completely random? Any errors in the SharePoint logs when it fails? What version of qRules are you using?

Failed to submit to SharePoint. URL

mgdukes — Thu, 17 Nov 2011 16:18:42 GMT

I have a 2010 web form that has a repeating section that is setup to submit to a list. Most of the time the submit will work fine but every now and again I will receive an error on submit. “Failed to submit to SharePoint. URL = 'https://site.mycompany.com/site/_vti_bin/lists.asmx'.” The site I am submitting to is an SSL site and I have trusted the root certificate for my CA. My data connection is in a UDC file and I have tried it with and without a Secure Store account. I have even tried extending my web application and submitting it over http. ANy help would be appreciated