Symptom
When replicating Remote Table data, the following error occurs:
HanaError: transaction rolled back by an internal error: [Virtual Table Replica] could not retrieve the remote object information of XXXX, Code: 129, SQL State: 40000
Environment
SAP Datasphere
Resolution
Consider using partitioning to make a successful load for tables with high data volume:
Partitioning Remote Table Data Loads
See Also
- SAP HELP - Replicate Remote Table Data
- SAP HELP - Pausing and Restarting Real-Time Replication
- 3139720 - SAP Datasphere: View Persistency aborts with an Out of Memory exception or consumes to much memory
Keywords
DWC, partitioning, Big Query, OOO, memory, data load, RT , KBA , DS-DI-RT , Remote Tables , Problem
Product
SAP Datasphere all versions