Error receiving data from SQL Server using DBXL 2.5 QueryDB when form includes qRules 3.1 - InfoPath Dev
in

InfoPath Dev

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

Last post 06-04-2011 03:44 PM by Patrick Halstead. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 06-04-2011 11:12 AM

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

    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

  • 06-04-2011 12:59 PM In reply to

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

    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.

    Patrick Halstead
    Project Manager at Qdabra
  • 06-04-2011 01:13 PM In reply to

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

    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

  • 06-04-2011 03:44 PM In reply to

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

    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.

     

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.