Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Timeout Fetch Limit in the Qlik SAP Connector

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Timeout Fetch Limit in the Qlik SAP Connector

Last Update:

Jul 23, 2021 6:59:26 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jul 23, 2021 6:59:26 AM

The SAP Connector aborts fetching of data because the timeout fetch limit is exceeded.

Error: Timeout fetch limit exceeded.

 

Environment

 

Resolution

 

Timeout fetch limit is the time until which Qlik will wait for SAP to send data. This limit is by default set to 1200s. When we are fetching a large amount of data we may exceed this limit before the entire data is fetched. The connection is aborted with the following error in logs:

To resolve: Overwrite the default 'TimeOutFetch' limit setting bypassing this parameter in the connect string, like the below.

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=xxxxxx;SYSNR=nn;CLIENT=nn;ConvRoutine=0;KeepCasing=1;Nulldate=1;RemoveAllBlanks=1;TargetServer=xxxxxx;JobClass=A;BufferPercentage=10;TimeOutBatch=600;TimeOutFetch=1200;TimeOutStartBatch=2400;PacketSize=20000;Log=0;Trace=0;XUserId=xxxxxx;XPassword=xxxxxx;";

 

 

Labels (1)
Contributors
Version history
Last update:
‎2021-07-23 06:59 AM
Updated by: