Performance SAP Connector on QSE SaaS

juan_goncalves — Fri, 10 Dec 2021 21:25:19 GMT

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,

Re: Performance SAP Connector on QSE SaaS

fzalexanderjohn — Fri, 27 May 2022 13:08:01 GMT

Hello,

did you ever find a solution?

topic Performance SAP Connector on QSE SaaS in Connectivity & Data Prep

Performance SAP Connector on QSE SaaS

Re: Performance SAP Connector on QSE SaaS