Qdabra Database Accelerator

Re: Error receiving data from SQL Server using DBXL 2.5 QueryDB when form includes qRules 3.1

Patrick Halstead — Sat, 04 Jun 2011 22:44:18 GMT

That's very interesting. I'm going to log a qRules inquiry into our bug database to investigate why this is the case.

Thanks for the workaround!

I'm off tonight but I'll be online from 10am tomorrow for a few hours.

Re: Error receiving data from SQL Server using DBXL 2.5 QueryDB when form includes qRules 3.1

stuartward — Sat, 04 Jun 2011 20:13:20 GMT

Hi Patrick, Thanks so much for the quick reply (especially on a Saturday). I just finished some experimenting and it seems that if I first add a data connection using QueryDB to retrieve data, and then inject qRules, I can then add additional QueryDB data connections without receiving that error. I have some additional development work to do on this form, so if I get tripped up again with this problem, I'll touch base with you about setting up a LiveMeeting.
Thanks again, Stuart

Re: Error receiving data from SQL Server using DBXL 2.5 QueryDB when form includes qRules 3.1

Patrick Halstead — Sat, 04 Jun 2011 19:59:17 GMT

I believe this is a change in InfoPath behavior between 2007 and 2010. Not sure why qRules injecting brings it about, but you should be able to use the second query string when it asks for Sample Values. Send me email and I can take a quick look via Live Meeting today.

Error receiving data from SQL Server using DBXL 2.5 QueryDB when form includes qRules 3.1

stuartward — Sat, 04 Jun 2011 18:12:41 GMT

In following through the tutorial, "Implement Static and Dynamic Queries using QueryDB" the results are as expected if qRules is not injected into the form. If starting with a form that already has qRules injected into it, when adding the data connection to retrieve data, there is no option to copy/paste the second query from Query Builder (this is step 9 on page 6 of the tutorial). When previewing the form, the following error is displayed:

The SOAP response indicates that an error occurred on the server:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ArgumentException: Invalid parameter
Parameter name: queryXml ---> System.ArgumentException: Invalid parameter
Parameter name: queryXml
   at Qdabra.QueryDB.QueryDBService.Qdabra.QueryDB.Services.IQueryDBService.GetColumnsXMLStrQuery(String queryXml)
   --- End of inner exception stack trace ---
   at Qdabra.QueryDB.QueryDBService.Qdabra.QueryDB.Services.IQueryDBService.GetColumnsXMLStrQuery(String queryXml)
   --- End of inner exception stack trace ---

I would appreciate any help in troubleshooting this error.
Thanks, Stuart