6 Replies Latest reply: Oct 3, 2014 1:33 AM by s j RSS

    Qv SAP Query Connector : Custom read failed

      Hello

       

      I got an error from the SAP Query Connector.

      There are two SAP Query for the test.

      First Query has no problem. But Second query got an error message "Custom read failed".

       

      Please, help me.

       

      QlikView Script.

      CUSTOM CONNECT TO "Provider=QvSAPQueryConnector.dll;ASHOST=00.000.00.000;SYSNR=10;CLIENT=900;XUserId=*;XPassword=*;";
       //*****
      [Table0]:          // Packing List  -    -   select
      Load *;
      Select SAPQUERY (QUERY (PACKING_LIST), VARIANT (SELECT), USERGROUP (ZKRSD), WORKSPACE ( ), EXTERNAL_PRESENTATION (S));
      
      [Table1]:          // Vendor Invoice  -    -  QVTEST
      Load *;
      Select SAPQUERY (QUERY (ZKR_INVOICE), VARIANT (QVTEST), USERGROUP (ZKRMM), WORKSPACE ( ), EXTERNAL_PRESENTATION (S));
      
      

       

      QlikView Log.

      2011-07-13 PM 5:05:35: 0022  CUSTOM CONNECT*Provider*QvSAPQueryConnector.dll*XUserId*XPassword*
      2011-07-13 PM 5:05:35: 0026  [Table0]:
      2011-07-13 PM 5:05:35: 0027  Load *
      2011-07-13 PM 5:05:35: 0028  Select SAPQUERY (QUERY (PACKING_LIST), VARIANT (SELECT), USERGROUP (ZKRSD), WORKSPACE ( ), EXTERNAL_PRESENTATION (S))
      2011-07-13 PM 5:05:38:       8 fields found: Delivery (VEPO-VBELN), Handling unit (VEKP-EXIDV), Material (VEPO-MATNR), Packed quantity (VEPO-VEMNG), UoM (VEPO-VEMEH), Material description (MAKT-MAKTX), Total weight (VEKP-BRGEW), WUn (VEKP-GEWEI_MAX), 8 lines fetched
      2011-07-13 PM 5:05:38: 0032  [Table1]:
      2011-07-13 PM 5:05:38: 0033  Load *
      2011-07-13 PM 5:05:38: 0034  Select SAPQUERY (QUERY (ZKR_INVOICE), VARIANT (QVTEST), USERGROUP (ZKRMM), WORKSPACE ( ), EXTERNAL_PRESENTATION (S))
      2011-07-13 PM 5:05:39:       36 fields found: CoCd (RBKP-BUKRS), Plnt (RSEG-WERKS), Inv. pty. (RBKP-LIFNR), Name 1 (LFA1-NAME1), Tax code 2 (LFA1-STCD2), Pstg. date (RBKP-BUDAT), Doc. date (RBKP-BLDAT), Material (RSEG-MATNR), Short text (EKPO-TXZ01), SD (RSEG-TBTKZ), OUn (RSEG-BSTME), Tx (RSEG-MWSKZ), Doc. no. (RBKP-BELNR), Doc.no. (FI_DOC_NO), Purch.doc. (RSEG-EBELN), Item (RSEG-EBELP), MTyp (MARA-MTART), MRP (MARC-DISPO), ValC (RSEG-BKLAS), D (RSEG-SHKZG), Item (RSEG-BUZEI), 전표금액 (%Z_0016), Curr. (RBKP-WAERS), 원화금액 (%Z_0019), Cost Center (%Z_0020), 매입수량 (%Z_0024), OUn (RSEG-BSTME), Error: Custom read failed
      2011-07-13 PM 5:05:40:      Execution finished.
      
      

       

      These query have no problem on SAP.