InfoPath Dev

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

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

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.

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

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.

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?

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.

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.

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.