Qdabra qRules

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

TCI2013 — Tue, 08 Oct 2013 21:09:06 GMT

I am having an identical problem, except I was just able to open in the browser ( I have to choose Documents > New Document, then pick my injected template), after much monkeying around with settings, and I got the error "You do not have permissions to access a SharePoint list that contains data required for this form to function correctly." Then the form opens anyway, and the command doesn't work. Can you help?

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

MaureenC — Thu, 21 Jul 2011 15:14:08 GMT

Hi, thank you for your excellent support service and for resolving this issue! Maureen

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

Hilary Stoupa — Wed, 20 Jul 2011 15:25:21 GMT

Hi - just wanted to post that we've gotten your forms, I've found & fixed the qRules injector issue that sometimes caused that data connection to have an incorrect path - that fix will be in qRules 3.3. To avoid that issue in previous versions of qRules, inject your browser form prior to publishing to SharePoint.

I'm able to repro the issue with the CPSF form sandbox publish, and am trying to track it down. In the meantime, I'll be emailing you another simple browser form with qRules injected to verify it will sandbox publish for you.

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

MaureenC — Tue, 19 Jul 2011 19:39:09 GMT

Okay, I sent the sample files with the following email below. I see the issue with the incorrect url for the QdabraRules xml file. But I'm unclear on how this relates to my error messages for the InfoPath forms that have the correct QdabraRules xml file location (i.e. not external).

Sorry Ernesto, Hilary, I selected the wrong file when I exported the QdabraRules xml file. As you can see from the one attached, it has version 3.1. I have been using multiple forms for troubleshooting and testing various scenarios (with or without qRules injected, with some data connections enabled or disabled, etc). So I’m looking at the QdabraRules xml file for various InfoPath forms I’m testing. I have found two with the incorrect QdabraRules xml file location (see screenshot below). These forms throw the 403 Forbidden error message. How does the injected file get this external address since I never edited / modified the QdabraRules data connection? This was the suggested test blank form just to see if it would open in a browser without, then with injected qRules.

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

MaureenC — Tue, 19 Jul 2011 19:12:14 GMT

Yes, that's why I pasted in the info from the file... I noticed the discrepancy in versions & thought I might add that info for the troubleshooting. I'll send the file asap. thanks, Maureen

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

ErnestoM — Tue, 19 Jul 2011 19:04:44 GMT

Hi Maureen,

Would you be able to send us the form? From the discussion above we learn that you injected with qRules 3.1 but the QdabraRules version above equals 2.4, which might be causing a conflict. I'm not sure how this may have happened, but taking a look at the form might help.

If you can, send it to support at qdabra dot com. Thank you.

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

MaureenC — Tue, 19 Jul 2011 18:33:16 GMT

Here is the info contained in the Qdabra xml file...

- <QdabraRules version="2.4" finishedLoading="false" isSwappingDom="false">

</QdabraRules>

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

MaureenC — Tue, 19 Jul 2011 18:25:30 GMT

Hi Hilary. I checked the qRules data connection. It shows the details exactly the same as your screenshot. xml file shows "QdabraRules.xml".

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

Hilary Stoupa — Tue, 19 Jul 2011 16:36:50 GMT

Hi - I'm wondering if your qRules data connection was somehow changed to point to an external XML rather than internal.

Can you open the data connection dialog, and click on the QdabraRules data connection, then look in the details, see where the XML file location is? I'm attaching a screenshot that may help explain better.

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

MaureenC — Tue, 19 Jul 2011 16:07:47 GMT

Hi Ernesto, Thanks for the rapid response. Sorry for my delay in getting back to you – I was out of the office.

1) Yes, the form opened in the browser until qRules was injected. Please explain what you mean by “If that's correct, then there could be an issue in the deployment.” Are you referring to the setup of the SharePoint farm or deploying (publishing) the form to SharePoint? Note: the IP form was central admin published due to having code. 2) A version of the form without qRules and with the failing web service connection opens in the browser. We are working on solving the permission error, but it may require a code-signing certificate. Note that the web service data connection has been confirmed as working in development environment for a non-central admin published form (opening in the InfoPath client and Preview mode). 3) Blank form without qRules opens in browser. When opening the form with qRules injected, it receives a warning / error message: 403 Forbidden (event log ID 5566). See Correlation ID info below. The Correlation ID seems to show an error in querying Qdabra qRules… some kind of “DataAdapterException”. Note: I click OK to the warning message and I’m able to save the file to the site itself. If I re-open the saved file, I get the same 403 Forbidden warning message.

Line 17552: 07/19/2011 09:44:19.86 w3wp.exe (0x1438) 0x1E78 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://icentral.trax.aero:443/CustCentral/MyHomePage/_layouts/FormServer.aspx?XsnLocation=https://icentral.trax.aero/CustCentral/MyHomePage/BrowserTest/Forms/template.xsn&SaveLocation=https%3A%2F%2Ficentral%2Etrax%2Eaero%2FCustCentral%2FMyHomePage%2FBrowserTest&Source=https%3A%2F%2Ficentral%2Etrax%2Eaero%2FCustCentral%2FMyHomePage%2FBrowserTest%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1) 6d0edb9b-74ed-4f6a-a7ba-39ff1c179988 Line 17553: 07/19/2011 09:44:19.87 w3wp.exe (0x1438) 0x1E78 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 6d0edb9b-74ed-4f6a-a7ba-39ff1c179988 Line 17560: 07/19/2011 09:44:20.12 SPUCWorkerProcess.exe (0x16C0) 0x36B0 InfoPath Forms Services Runtime c5rl Medium FormServer Partial Trust - Proxy operation invoked in the SHIM process. 6d0edb9b-74ed-4f6a-a7ba-39ff1c179988 Line 17569: 07/19/2011 09:44:20.15 SPUCWorkerProcess.exe (0x16C0) 0x36B0 InfoPath Forms Services Runtime - Data Connections 7tfk Medium Data adapter failed during OnLoad: The form cannot run the specified query. 6d0edb9b-74ed-4f6a-a7ba-39ff1c179988 Line 17570: 07/19/2011 09:44:20.15 SPUCWorkerProcess.exe (0x16C0) 0x36B0 InfoPath Forms Services Runtime - Data Connections eq8l Warning The following query failed: QdabraRules (User: , Form Name: BrowserTest, IP: , Connection Target: , Request: , Form ID: urn:schemas-microsoft-com:office:infopath:BrowserTest:-myXSD-2011-07-19T13-32-37 Type: DataAdapterException, Exception Message: The form cannot run the specified query. The remote server returned an error: (403) Forbidden.) 6d0edb9b-74ed-4f6a-a7ba-39ff1c179988 Line 17571: 07/19/2011 09:44:20.23 w3wp.exe (0x1438) 0x1E78 SharePoint Server State Service 8kfs Medium The StateManager is disposing and calling ReleaseLockedStates() (Count=0) 6d0edb9b-74ed-4f6a-a7ba-39ff1c179988 Line 17572: 07/19/2011 09:44:20.23 w3wp.exe (0x1438) 0x1E78 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://icentral.trax.aero:443/CustCentral/MyHomePage/_layouts/FormServer.aspx?XsnLocation=https://icentral.trax.aero/CustCentral/MyHomePage/BrowserTest/Forms/template.xsn&SaveLocation=https%3A%2F%2Ficentral%2Etrax%2Eaero%2FCustCentral%2FMyHomePage%2FBrowserTest&Source=https%3A%2F%2Ficentral%2Etrax%2Eaero%2FCustCentral%2FMyHomePage%2FBrowserTest%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1)). Execution Time=379.783464099488 6d0edb9b-74ed-4f6a-a7ba-39ff1c179988

Any ideas on what is causing the browser errors when qRules is injected?

Thanks, Maureen

Re: Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

ErnestoM — Wed, 13 Jul 2011 23:12:21 GMT

Hi Maureen,

You say the form no longer opens in the browser. I assume this means it opened in the browser before injecting qRules, and now (with qRules injected) it is not opening in the browser? If that's correct, then there could be an issue in the deployment.

But what caught our attention is the permission errors connecting to the web service. It would be great to get that solved and then try again. As an alternative: do you have a version of the form without qRules but WITH the failing web service connection? Check if that opens in the browser correctly.

Finally, test if a new, blank form, injected with qRules, will work fine in your browser. This would indicate that it is definitely an issue with a specific form.

Thanks.

Can’t open form in Browser! Qrules 3.1 injected in IP / SP 2010

MaureenC — Wed, 13 Jul 2011 19:36:32 GMT

Could anyone please assist with the problem of a Qrules-injected InfoPath form no longer opening up from a browser? I hope I have provided enough information below to understand the problem. Let me know if more detail is needed. Thanks in advance for any assistance! Scenario:I created an InfoPath 2010 form with repeating tables (used by customers to submit contact information). The form needs to open in a browser (customer may not have IP installed), save to the form library it opened from, and also submit the contact information to a SharePoint list. With Qrules injected, I am able to save the file to the library and submit data to the SP list. This was tested using the Preview mode. Also, it works when opening the form in the IP client. A new form was built from scratch, without Qrules injected and it opened successfully from within the browser (but can’t feed to SP list, of course). [Note: the form has been tested with 2 different machines, one with IP installed, one without] When opening the form without IP installed, I get this error message: The specified form template could not be found, or is not compatible with rendering in the browser. It might need to be republished as a browser-enabled form. Related Correlation ID information (can’t find any clues here): Line 16316: 07/13/2011 14:48:16.20 w3wp.exe (0x1CFC) 0x37B8 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (POST:https://icentral.trax.aero:443/CustCentral/MyHomePage/_layouts/FormServer.aspx?XsnLocation=https%3a%2f%2ficentral.trax.aero%2fCustCentral%2fCustomer+Profile+Survey+template.xsn&SaveLocation=https%3a%2f%2ficentral.trax.aero%2fCustCentral%2fMyHomePage%2fCustomer+Profile+Survey+Form&Source=https%3a%2f%2ficentral.trax.aero%2fCustCentral%2fMyHomePage%2fCustomer%2520Profile%2520Survey%2520Form%2fForms%2fAllItems.aspx&DefaultItemOpen=1) 5719f571-8717-49fe-94aa-aec1b04b7012 Line 16317: 07/13/2011 14:48:16.20 w3wp.exe (0x1CFC) 0x37B8 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 5719f571-8717-49fe-94aa-aec1b04b7012 Line 16318: 07/13/2011 14:48:16.23 w3wp.exe (0x1CFC) 0x37B8 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (POST:https://icentral.trax.aero:443/CustCentral/MyHomePage/_layouts/FormServer.aspx?XsnLocation=https%3a%2f%2ficentral.trax.aero%2fCustCentral%2fCustomer+Profile+Survey+template.xsn&SaveLocation=https%3a%2f%2ficentral.trax.aero%2fCustCentral%2fMyHomePage%2fCustomer+Profile+Survey+Form&Source=https%3a%2f%2ficentral.trax.aero%2fCustCentral%2fMyHomePage%2fCustomer%2520Profile%2520Survey%2520Form%2fForms%2fAllItems.aspx&DefaultItemOpen=1)). Execution Time=40.3375289317497 5719f571-8717-49fe-94aa-aec1b04b7012 Trouble shooting steps / information: Form is central admin published, the form library has the Content type enabled, the form is accessible (ie, is found).Form library settings are set to open in browser, but it opens the form in the client instead by default. Form is web browser-enabled. The IP form was injected with IP 2010 and Browser compatibility checked. Also had a data connection configured to access a web service on the same SP server, but this throws an error (event 5567 “you do not have permissions to access a web service”) despite that the web service is on the same server. We are investigating if InfoPath needs a code signing certificate. But I guess that’s a separate issue. So I disabled that data connection and submit rule for now.