Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

cancel
Showing results for 
Search instead for 
Did you mean: 
juan_goncalves
Partner - Contributor
Partner - Contributor

Performance SAP Connector on QSE SaaS

Hi Gurus,

We have a lead who is very interested in QSE SaaS and SAP SQL Connector. We are currently in a PoC and try to extract tables with a small number of records but the process in Qlik does not finish correctly.

The process is frozen in Qlik and in SAP it cancels the job after approximately 200 seconds after, it shows this error in the log "Timeout reached while waiting for clearance of shared buffer.5678". We try to change some parameters in the connection string of the SAP Connector such as BufferPercentage = 50, JobClass = A but the error in the jobs changes to this other "Not enough buffer space available - decrease buffer percentage used to 10 or a lower value. Include a string like:; buffer percentage ", we suspect it is a memory management issue on the SAP server, but we don't know how to tune it.

The detail table of accounting movements of SAP BSEG with SAP Connector from QSE SaaS does not allow me to bring more than 50,000 records with approximately 17 fields. In other projects with other OnPremise clients, there has been no problem with extractions with a higher volume of data (incremental load).

SAPTableBSEG:
LOAD BUKRS & BELNR & GJAHR & BUZEI AS KEY.BSEG, *;
SQL SUBSELECT
BUKRS, BELNR, GJAHR, BUZEI, BUZID, KOART, SHKZG, DMBTR, PSWSL, VORGN, HKONT,
KOSTL, AUGBL, KUNNR, LIFNR, AUGDT, VBELN
FROM BSEG WHERE BUKRS BELNR GJAHR IN
( SELECT BUKRS BELNR GJAHR FROM BKPF WHERE GJAHR = '2017' and MONAT = '03');

What parameters can we verify in the SAP server?

Thanks in advance Juan,

Labels (2)
1 Reply
fzalexanderjohn
Creator
Creator

Hello,

did you ever find a solution?