topic Re: Table SAP does not return Data | TimeOut in QlikView

Table SAP does not return Data | TimeOut

vinisefrin — Mon, 26 Jan 2026 21:26:37 GMT

Good afternoon people,

You have gone through a situation in which certain SAP table does not return the data?

LOG is a table that has many records, the table is the CDPOS

The Qlik is trying to read for a few minutes and the error:

Or via BAPI could run, after 7 hours of run error. We checked, and according to SAP consultant, the error is TABLESPACE.

LOCATION CPIC (TCP/IP) on local host with Unicode

ERROR no conversation found with id 58363381

TIME Mon Mar 14 16:49:05 2016

RELEASE 720

COMPONENT CPIC (TCP/IP) with Unicode

VERSION 3

RC 473

MODULE r3cpic.c

LINE 9101

COUNTER 3

How can I fix this?

This limitation is the Qlik or SAP?

Thanks

Re: Table SAP does not return Data | TimeOut

cwolf — Sat, 19 Mar 2016 01:23:33 GMT

The table CDPOS is too large to load them in this way.

You have to use at least the first index field OBJECTCLAS in the where clause.

Because you are looking for fields of deliveries, you can try:

SQL select ...

where OBJECTCLAS = 'LIEFERUNG';

Or if you really want to search for specific fields:

SQL select ...

where OBJECTCLAS = 'LIEFERUNG' and (FNAME = 'LIEFNR' or FNAME = 'INCO1' or FNAME = 'WADAT');

Regards

Re: Table SAP does not return Data | TimeOut

vinisefrin — Mon, 21 Mar 2016 17:26:40 GMT

Good afternoon Christian,

thanks for the tip, but now the error that is giving and is TimeOut.

CDPOS << CDPOS

Error: QVX_UNEXPECTED_END_OF_DATA: Timeout exceeded the 'TimeOutFetch' s limit of 1200

I'm looking for how to change the TimeOut time the Connector.

Thank you

Re: Table SAP does not return Data | TimeOut

cwolf — Tue, 22 Mar 2016 07:49:48 GMT

Hi Vinícius

You can set parameters to the connector. For example:

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

See the help for description.

http://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/6.1/QV-connection/SAP-SQL-connection.htm

Regards

Christian

Re: Table SAP does not return Data | TimeOut

vinisefrin — Tue, 22 Mar 2016 11:54:48 GMT

Good morning Christian,

that's exactly what I did, set the parameter to ignore the TimeOut time, and it worked.

TimeOutFetch=n (default = 1200 seconds): The number of seconds spent trying to fetch from SAP without getting any records back.

Thank you for your help.

Hugs