Qv SAP Query Connector : Custom read failed

[#1]

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.

[suniljain]

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.

[#3]

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.

[suniljain]

"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.

[#5]

from where we change the time out  feature

[Tomas_Sommergyll]

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):

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

Thanks

[suniljain]

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" .