Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
KHSDM
Creator III
Creator III

SAP Loading Stuck

Hi,

I'm having problem loading the SAP KONV table

I've enabled tracing, and this is the last message in the trace log (\QTQVC\TRACE):-

Timeout reached while waiting for clearance of shared buffer.

And this is the message in the status table (\QTQVC\STATUS):

READ_DATA job has aborted

 

What is the cause of the error and how to fix it?

Labels (1)
5 Replies
Hakan_Ronningberg

Hi,

This sounds like a bug which was fixed in the latest connector release 7.0.2. If you are not using 7.0.2, try to install it. This bug was on the SAP side of the connectors, so you have to install both the SAP transports and the Windows part.

Regards,
Håkan

KHSDM
Creator III
Creator III
Author

Weird.. because we actually can load the table previously using our current connector (6.2.0) But due to some data change, we need to do a full load again and this error happen.

Hakan_Ronningberg

Hi again,

Are you using a Message server or Application server when creating the connection?

Regards,
Håkan

KHSDM
Creator III
Creator III
Author

Hi,
We are using application server.
Hakan_Ronningberg

The bug which was fixed affected only Message server connection, so this must be something else.

You can check the parameters affecting the shared Export/Import buffer in the SAP system? The Export/Import buffer is used by the SQL connector. If the values are too low it can affect the connector. Otherwise I suggest to contact the Qlik Support!

Check the SAP note 702728 - Profile parameters for export/import buffer instances.

NOTE: when the parameters have been changed, restart the SAP system to activate the new values.

The following parameters are important:
rsdb/obj/buffersize
Syntax for correct size: PHYS_MEMSIZE * 1024 * 0,01.
For example, if the server has 35 Gb of memory, the correct value should be 358400.

rsdb/obj/max_objects
Syntax for correct size: rsdb/obj/buffersize / 4.
Correct value based on rsdb/obj/buffersize of 358400 = 89600.

rsdb/obj/large_object_size
Default: 8192. Because this default value has proven to be too small, it has been changed as follows in kernel patches:
- As of kernel Release 7.40 PL 68, 7.41 PL 35, and 7.42 PL 3, the default has been increased to 250000.

The parameter values can be checked in transaction RZ11 or in transaction ST02.