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');