Symptom
- "internal error: Error opening the cursor for the remote database <XXX> Error for \"XXX\".\"XXX$F\" : Error while accessing The database registered an internal error. SQL code 4. The error text is: cannot allocate enough memory: [9] Memory allocation failed; exception 1000002
- Failed (Resource Limit Error)
- General error;403 internal error: Error opening the cursor for the remote database No more memory available to add rows to an internal table.
Environment
SAP Datasphere
Reproducing the Issue
Replicating remote table (ACDOCA) from Connection type SAP ABAP, ECC or BW.
Cause
Running out of memory due DP Agent (SDI ABAPAdapter) restrictions.
Memory shortage occurs because SAP Datasphere requests DP Agent to Insert data from ABAP system.
Resolution
1. Because the source table (ACDOCA) is very big, please use the connection you have maintained only for that replication or create one dedicated connection for ACDOCA replication.
2. Make sure that you do not trigger any other parallel jobs when replicating from the ACDOCA table.
3. As mentioned in SAP KBA 0003215139 kindly ask you to enable Streaming Read as mentioned in SAP Help Portal documentation: SAP ABAP, SAP ECC, SAP BW.
Be aware that Field delimited extraction will always be used when one or more fields being extracted is a non fixed-length field (that is, defined in the ABAP dictionary as of STRING datatype with 0 length.
Delimited extraction will always be performed in non-streaming mode, even when the remote source is configured for streaming.
As a result large extractions may fail, due to limitations of the non-streaming mode, in particular due to the time limitation of ECC dialog mode, as well as the memory limitation of Data Provisioning Agent.
4. Use Partitions for remote tables replication.
See Also
- SAP Help Portal SAP HANA Smart Data Integration and SAP HANA Smart Data Quality - Field Delimited Extraction
- KBA 2861324 - No more memory available to add rows to an internal table - SAP HANA Smart Data Integration
- SAP Note 3139720 - SAP Datasphere: View Persistency aborts with an Out of Memory exception or consumes to much memory
- SAP KBA 3215139 - Replication fails due memory shortage
Keywords
ACDOCA, replication, streaming read, memory, allocation, Prefetch timed out, datasphere , KBA , DS-DI-RT , Remote Tables , Problem