Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
lessing
Contributor
Contributor

Using SAP-SQL Connector (direct access) : failure to acquire a load slot:

Hello,

I use a Do Relaod block in my automation and in 1 of 100 tasks I get this error:

Connector VTI Ladeprozesse - SSBI (Shared):XX_QL_GISUCM_SQL not found (Requested endpoint could not be provisioned due to failure to acquire a load slot: Command getReloadSlot error for reload 6579aeb316801791b05da3a4.

LIB Connect To 'VTI Ladeprozesse - SSBI (Shared):XX_QL_GISUCM_SQL')

The error occurred here: LIB Connect To 'VTI Ladeprozesse - SSBI (Shared):F5_QL_GISUCM_SQL'

 

I am using the connector "SAP SQL (via Direct Access gateway" (latest transports in SAP-System and latest version on gateway server)
The gateway server is a dedicated Windows server with no other software installed. I guess there are running max 10 reload tasks in parallel.

I the  gateway server log file:

SapNwRfcWrapper.SapConnectorException: /QTQVC/FETCH_STREAM threw an ABAP Exception: TIMEOUT_READ_MEMORY: ID:00 Type:E Number:001 Timeout when trying to read shared buffer
Message Details: TYPE=E ID=00 NO=001 DETAILS=
at SapNwRfcWrapper.SapFunction.Execute()
at SapRfcWrapper.SapNwRfcWrapper.InvokeFunction(String functionName, IDictionary`2 inputParameters, IEnumerable`1 activeParameters)
2023-12-13 14:17:55.026 [WRN] [8700:39] [SAP] <RequestGuid:bd06b0be-c475-4e11-9f26-e683c838e803,ReloadId:6579aeeec573afe90e124db4> OpenFetchStream.FetchStream() - /QTQVC/FETCH_STREAM threw an exception, RfcErrorKey:TIMEOUT_READ_MEMORY elapsed:00:00:14.5789025
2023-12-13 14:17:55.026 [WRN] [8700:39] [SAP] <RequestGuid:bd06b0be-c475-4e11-9f26-e683c838e803,ReloadId:6579aeeec573afe90e124db4> OpenFetchStream.FetchStream() - TIMEOUT_READ_MEMORY received, retrying

 

we are using this reload job from on-prem and don't have any problems. To compare these jobs we are running them every 2 hours starting at 6:15 in the cloud, 7:15 on-prem. The load chain takes 30 min for all jobs.

Does someone know about this error or do you know some restrictios using the gateway server?

Regards,

Lessing

 

Labels (3)
0 Replies