SAP Knowledge Base Article - Public

3384097 - Snapshot error "HanaError: transaction rolled back by an internal error: [Virtual Table Replica] could not retrieve the remote object information of [...]" in SAP Datasphere

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

Keywords

DWC, partitioning, Big Query, OOO, memory, data load, RT , KBA , DS-DI-RT , Remote Tables , Problem

Product

SAP Datasphere all versions