1 Reply Latest reply: Jun 13, 2017 4:26 AM by Naresh Guntur RSS

    error with DIRECT QUERY in Sense 3.2.1

    Andrea Gigliotti

      Hello,

       

      I get randomly an "QVX_UNEXPECTED_END_OF_DATA)"  ERROR executing the below script.

       

      SET DirectCacheSeconds= 15;

      LET DirectStringQuoteChar=chr(39);

      SET DirectIdentifierQuoteChar=' ';

      SET DirectConnectionMax= 4;

      SET DirectTableBoxListThreshold= 100000;

      SET DirectDistinctSupport=true;

      SET DirectIdentifierQuoteStyle=’ANSI’;

       

      LET vL.dateFrom = Date(Today()-30, 'YYYY-MM-DD');

       

      LIB CONNECT TO 'IBM_DB2_ASUMBRA.UMBRA.LOCAL (umbra_qlikadmin)';

       

      A:

      DIRECT QUERY

      DIMENSION

      "ORDNUM" as "Numero ordine",

      "ORDAGO" as "Codice Agente",

      "ORDAG2" as "Codice Capo Area",

      "ORDKSC" as "Codice Cliente",

      ORDNNO,

      "ORDBCO" as "Blocco Contabile",

      "ORDBGC" as "Blocco Commerciale",

      ORDSAR,

      "ORDDAT" as "Data Ordine",

      "ORDART" as "Codice Articolo"


      MEASURE

      ORDIFT,

      ORDCRD,

      ORDCOE,

      ORDQTN

       

      FROM "PJXI1D3SOC"."OCORD00F" WHERE ORDDAT >= '$(vL.dateFrom)' and ( ORDBCO = 'S' or ORDBGC = 'S' );

       

      Database type is DB2 on As400.

      I'm using "Qlik ODBC Connector Package" to connect to IBM DB2 database.

       

      If you retry after some minutes it works fine.

       

      However after succesfully script execution I get the "Database connection failed" in table object rendering, even when I selected a value from direct query field.

       

      Attached the printscreen errors.

       

      Can anybody help me to fix it ?

       

      Many thanks in advance.

       

      BR

      Andrea

        • Re: error with DIRECT QUERY in Sense 3.2.1
          Naresh Guntur

          Hi Andrea

           

          The error which I get is "Internal Engine Error". And I am using other configurations same as yours.

           

          SET DirectConnectionMax= 4;

          SET DirectTableBoxListThreshold= 100000;

           

          Are you not facing issue with DirectConnectionMax?

          What is the limit you have for the no.of connections for the user? Is is not exceeding the limit? For me, even I assign it to 4, its going beyond 4.


          Cheers

          Naresh