Qdabra qRules

Re: QRules Form Library Not working Post SP 2013 upgrade

Hilary Stoupa — Mon, 23 Feb 2015 22:33:35 GMT

Sorry, I was slow to push the post button - it sounds like you were able to see what was going wrong!

Re: QRules Form Library Not working Post SP 2013 upgrade

Hilary Stoupa — Mon, 23 Feb 2015 22:09:28 GMT

Okay - looks like you have a refresh command in your form as well. You can update your data connection named "refreshwpb" to use the correct GUID for your list if you have not done that already?

The refresh command failing shouldn't prevent the submit from working, however (I don't think) so you could still try the submit with Fiddler running.

Re: QRules Form Library Not working Post SP 2013 upgrade

RajInfoDev — Mon, 23 Feb 2015 21:44:42 GMT

The migration tool seems to be resetting the list IDs which is why the form doesn't retrieve existing information on load. Luckily it was a trial version of the migration tool.

We will be looking at the backup and upgrade of the 2010 content database to migrate the content and keep the IDs. Thanks for your help Hilary. Hope this helps someone else as well.

Re: QRules Form Library Not working Post SP 2013 upgrade

RajInfoDev — Mon, 23 Feb 2015 21:10:52 GMT

Do I need to modify the "additional data connection" mentioned in the "Form Changes" section of the following article to the new url? Not sure if this is causing the error?

http://www.infopathdev.com/blogs/hilary/archive/2012/07/05/qrules-refreshsharepointlistitems-walkthrough-for-v4-2.aspx

Update: This didn't resolve the problem.

Re: QRules Form Library Not working Post SP 2013 upgrade

RajInfoDev — Mon, 23 Feb 2015 20:57:37 GMT

Do I have to open the XML directly from the server or can I open a local copy from my hard drive?

When I opened a local copy of the InfoPath XML, I got this error message. I didn't see this when I opened the form through the browser.

Error querying for SharePoint List Items for list {D6055446-169C-4AD9-848B-BB7C7FE65962}: The query cannot be run for the following DataObject: refreshwpb InfoPath cannot run the specified query. InfoPath cannot open the following file: refreshwpb&FilterField1=ID&FilterValue1=5. The system cannot find the file specified. | Failed to refresh list items: No list items to refresh. Verify parameters are correct. | Failed to refresh list items: No list items to refresh. Verify parameters are correct. | Failed to refresh list items: No list items to refresh. Verify parameters are correct. | Failed to refresh list items: No list items to refresh. Verify parameters are correct. | Error querying for SharePoint List Items for list {A4BB3F55-14A2-4790-8E37-C9BAC0F7931E}: The query cannot be run for the following DataObject: refreshwpb InfoPath cannot run the specified query. InfoPath cannot open the following file: refreshwpb&FilterField1=ID&FilterValue1=89. The system cannot find the file specified. | Failed to refresh list items: No list items to refresh. Verify parameters are correct. | Failed to refresh list items: No list items to refresh. Verify parameters are correct. | Failed to refresh list items: No list items to refresh. Verify parameters are correct. | Error querying for SharePoint List Items for list {DBCA9053-590C-44BB-90C3-60CCE57A1EEF}: The query cannot be run for the following DataObject: refreshwpb InfoPath cannot run the specified query. InfoPath cannot open the following file: refreshwpb&FilterField1=ID&FilterValue1=3. The system cannot find the file specified. | Failed to refresh list items: No list items to refresh. Verify parameters are correct. | Error querying for SharePoint List Items for list {F15D510B-BA81-4B08-AA1C-856A2A029DDB}: The query cannot be run for the following DataObject: refreshwpb InfoPath cannot run the specified query. InfoPath cannot open the following file: refreshwpb&FilterField1=ID&FilterValue1=16. The system cannot find the file specified. | Failed to refresh list items: No list items to refresh. Verify parameters are correct. | Error querying for SharePoint List Items for list {85C8467C-83CC-44D4-AAEB-7532D2FFB9C0}: The query cannot be run for the following DataObject: refreshwpb InfoPath cannot run the specified query. InfoPath cannot open the following file: refreshwpb&FilterField1=ID&FilterValue1=3. The system cannot find the file specified. | Failed to refresh list items: No list items to refresh. Verify parameters are correct. | Failed to refresh list items: No list items to refresh. Verify parameters are correct.

Re: QRules Form Library Not working Post SP 2013 upgrade

Hilary Stoupa — Mon, 23 Feb 2015 19:53:19 GMT

Sure - download and install Fiddler then open it so it can capture web traffic. Then open your form that is not updating the list item in Filler and execute the submit command. In Fiddler, on the left pane, look for the lists web service URL - Lists.asmx. Select it and on the right hand pane, look for the Inspectors tab. Usually for both the request and response I select XML - you'll be able to see what the form sent to the web service and what it got back - that can often help track down these types of issues. :)

Re: QRules Form Library Not working Post SP 2013 upgrade

RajInfoDev — Mon, 23 Feb 2015 19:26:12 GMT

I am not familiar with the fiddler tool. Can you please summarize the steps needed to run the InfoPath XML using fiddler? Appreciate it.

Re: QRules Form Library Not working Post SP 2013 upgrade

Hilary Stoupa — Mon, 23 Feb 2015 19:01:49 GMT

The InfoPath form XML.

Re: QRules Form Library Not working Post SP 2013 upgrade

RajInfoDev — Mon, 23 Feb 2015 19:00:11 GMT

Which XML file are you referring to? Is it the InfoPath form XML or the mapping xml file?

Re: QRules Form Library Not working Post SP 2013 upgrade

Hilary Stoupa — Fri, 20 Feb 2015 22:54:50 GMT

Thanks - and are you opening existing XML in filler or in the browser?

Have you ever used Fiddler? You could open an existing XML in filler, run Fiddler and see what CAML is being sent on submit (and more info on what the list service is returning) - that can be really helpful debugging something like this.

Re: QRules Form Library Not working Post SP 2013 upgrade

RajInfoDev — Fri, 20 Feb 2015 22:43:45 GMT

Yes, I was referring to updating existing list items from the form. So for example if the form has a value "orange" and I changed it to "apple" and submitted it, the list item still has "orange" and the form has "apple". But, if I add a new value lets say through a repeating drop-down on the form(in edit mode), a new item is added to the list. No problems with that.

Re: QRules Form Library Not working Post SP 2013 upgrade

Hilary Stoupa — Fri, 20 Feb 2015 22:37:46 GMT

I think I may be confused by the word "updated" here - I keep thinking you are talking about updating existing list items from the form. Is that the case? I think you said that if you fill out a new form, new items are added to the list correctly?

Re: QRules Form Library Not working Post SP 2013 upgrade

RajInfoDev — Fri, 20 Feb 2015 22:27:49 GMT

I deleted the dummy/extra list item and that fixed the error message. Now I get no error at all when I submit the form and the list doesnt get updated either. Anything else I can look for?

Re: QRules Form Library Not working Post SP 2013 upgrade

Hilary Stoupa — Fri, 20 Feb 2015 22:09:42 GMT

The mapping file will need the site URL updated if that is now different, yes. If the column names have changed, the mapping would also need to be updated.

If an XML has values in the field mapped to the SharePoint list ID, qRules is going to try to update the existing item - so if your form has, for example, an item with an ID of "420" and there is no item with that ID in the list any longer, the code can't know what item it should update. Does your list have items in it? Maybe there would be a way via form logic to update the ID field in the form to the correct new ID?

Re: QRules Form Library Not working Post SP 2013 upgrade

RajInfoDev — Fri, 20 Feb 2015 20:54:17 GMT

There is no item with that ID in the list. Also after the upgrade, do I need to redo the mapping xml file using the filler, if the site URL has changed?