3215139 - Replication of remote table fails due memory shortage

• 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

SAP Datasphere

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