Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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.

6 Replies
suniljain
Honored Contributor

Qv SAP Query Connector : Custom read failed

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.

Not applicable

Qv SAP Query Connector : Custom read failed

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
Honored Contributor

Qv SAP Query Connector : Custom read failed

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

Not applicable

Re: Qv SAP Query Connector : Custom read failed

from where we change the time out  feature

Employee
Employee

Re: Qv SAP Query Connector : Custom read failed

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
Honored Contributor

Re: Qv SAP Query Connector : Custom read failed

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

Community Browser