When trying to extract data using the SAP BEX connector you receive intermittent results where sometimes it succeeds and other times it does not. Checking the connector logs show insufficient memory as follows:
06:50:35,515 [4] - Error in SapBexConnection.GetTables(): RfcAbapRuntimeException:The memory request for 1xxx bytes could not be complied with.
06:50:35,515 [4] - Error in BExSapService.RunBexQuery(): RfcAbapRuntimeException:The memory request for 1xxx bytes could not be complied with.
06:50:35,515 [4] - BexConnectorDataReader.Read() - Error occured during read!
System.Exception: RfcAbapRuntimeException:The memory request for 1xxx bytes could not be complied with. ---> SAP.Middleware.Connector.RfcAbapRuntimeException: The memory request for 1xxx bytes could not be complied with.
at SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg()
Environment:
Qlik SAP Connectors
SAP interface will present an error similar to the following:
The chart below can be viewed in SAP while attempting the connection to view memory consumption of the extraction:
Resolution:
To resolve the issue changes will need to be made in the SAP memory configuration and such will be solely up to the user's SAP administration team.
Cause:
Memory allocation limits have been reached for the heap or you have reached the operating system limits of available memory.