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()