topic Qv SAP Query Connector : Custom read failed in QlikView

Qv SAP Query Connector : Custom read failed

Mon, 26 Jan 2026 21:26:37 GMT

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.

Qv SAP Query Connector : Custom read failed

suniljain — Thu, 14 Jul 2011 04:28:38 GMT

Increase the TimeOutFetch Paramete in SAP Connector connection String.

This error is notmally comes when SAP System is not responding in default TimeOutFetch limit.

Request to increase that parameter.

Qv SAP Query Connector : Custom read failed

Wed, 03 Aug 2011 07:31:13 GMT

hi sunil,

i ma getting similar error! " Customer Connection Failed"

could u let me know, which is the file name to change "TimeOutFetch Parameter"

thanking u in advance.

Qv SAP Query Connector : Custom read failed

suniljain — Sun, 07 Aug 2011 06:33:20 GMT

"TimeOutFetch Parameter" is one of the parameter in SAP Connector connection string.

you can set according to your requirement. if your system takes too much time to extract then increase the value of the parameter.

Re: Qv SAP Query Connector : Custom read failed

Wed, 01 Oct 2014 07:38:35 GMT

from where we change the time out feature

Re: Qv SAP Query Connector : Custom read failed

Tomas_Sommergyll — Wed, 01 Oct 2014 14:02:57 GMT

I have noticed this is an old thread. However, there are a few things about the TimeOutFetch parameter that needs clarifying (from the QlikView Connector Manual):

This is used only in the Qv SAP SQL Connector.
TimeOutFetch=n (default = 1200 seconds): The number of seconds spent trying to fetch from SAP without getting any records back.

Thanks

Re: Qv SAP Query Connector : Custom read failed

suniljain — Fri, 03 Oct 2014 05:33:05 GMT

Performance of SAP Query connector is very poor . I will suggest to avoid data extraction from Query .

Query processing time through connector is very high and sometime its not able to respond within defined time frame and giving error " Customer Connection Failed" .