SAP Knowledge Base Article - Preview

3215139 - Replication of remote table fails due memory shortage

Symptom

  • Error: {"timestamp":20XX-XX-XX XX:XX:XX.0000000,"origin":"_sys_task","message":"internal error: Error opening the cursor for the remote database No more memory available to add rows to an internal table. at federation/fedservice/FederationQueryExecutorManager.cpp:227; Statement: ,INSERT INTO...
  • Error: {"timestamp":20XX-XX-XX XX:XX:XX.0000000,"origin":"_sys_task","message":"transaction rolled back by an internal error: Remote source CONNECTION is unable to prepare transaction id XXXXXXXXX at federation/fedservice/FederationContextTXN.cpp:352; Statement: ,INSERT INTO...
  • Error: {"timestamp":20XX-XX-XX XX:XX:XX.0000000,"origin":"_sys_task","message":"cannot allocate enough memory: Allocation failed $REASON$ (unknown SQLScript function(s))"}
  • General error;403 internal error: Error opening the cursor for the remote database No more memory available to add rows to an internal table.
  • Running out of memory in DP Agent (SDI ABAPAdapter). "Agent is running very low on memory" or "Agent is shutting down".
  • Error: {"timestamp":20XX-XX-XX XX:XX:XX.0000000,"origin":"_sys_task","message":"internal error: Agent is shutting down.
    at ptime/query/plan_executor/dml/hex/qe_hex_search.cc:499; Statement: ,INSERT INTO
  • In source system there is memory dump:

Category Resource bottleneck
Runtime Errors TSV_TNEW_PAGE_ALLOC_FAILED

No more memory available to add rows to an internal table.

"TSV_TNEW_PAGE_ALLOC_FAILED"
"/SAPDS/SAPLRS_BASIS" bzw. /SAPDS/LRS_BASISU20
"Z_BODS_RFC_READ_TABLE2_FORM"

5 FORM         /SAPDS/SAPLRS_BASIS                 /SAPDS/LRS_BASISU20                   390
  Z_BODS_RFC_READ_TABLE2_FORM
4 FUNCTION     /SAPDS/SAPLRS_BASIS                 /SAPDS/LRS_BASISU20                    37
  /SAPDS/RFC_READ_TABLE2
3 FORM         /SAPDS/SAPLRS_BASIS                 /SAPDS/LRS_BASISU20                     1
  /SAPDS/RFC_READ_TABLE2
2 FORM         SAPMSSY1                            SAPMSSY1                              189
  REMOTE_FUNCTION_CALL
1 MODULE (PBO) SAPMSSY1                            SAPMSSY1                               35
  %_RFC_START


Read more...

Environment

SAP Datasphere

Product

SAP Datasphere all versions ; SAP Datasphere, SAP BW bridge all versions

Keywords

source, system, HANA Adapter, ABAP Adapter, smart, data, integration, Prefetch timed out, pre fetch, time, out, pre, fetch, dwc, data warehouse cloud, ACDOCA , KBA , DS-DI-RT , Remote Tables , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.