SAP Knowledge Base Article - Public

3434827 - ACDOCA Realtime Replication fails due to out of memory error

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 ABAPSAP ECCSAP 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

Keywords

ACDOCA, replication, streaming read, memory, allocation, Prefetch timed out, datasphere , KBA , DS-DI-RT , Remote Tables , Problem

Product

SAP Datasphere all versions