Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
KHSDM
Creator III
Creator III
‎2019-10-07 01:55 AM

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)
Labels
3,436 Views
0 Likes
5 Replies
Hakan_Ronningberg
Employee
Employee
‎2019-10-07 02:10 AM

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

3,429 Views
KHSDM
Creator III
Creator III
‎2019-10-07 03:50 AM
Author

In response to Hakan_Ronningberg

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.

3,412 Views
0 Likes
Hakan_Ronningberg
Employee
Employee
‎2019-10-07 05:13 AM

In response to KHSDM

Hi again,

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

Regards,
Håkan

3,410 Views
0 Likes
KHSDM
Creator III
Creator III
‎2019-10-08 04:52 AM
Author

In response to Hakan_Ronningberg
Hi,
We are using application server.
3,396 Views
0 Likes
Hakan_Ronningberg
Employee
Employee
‎2019-10-08 05:04 AM

In response to KHSDM

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.

3,392 Views