3721846 - Replication flow failure due to invalid remote object name in SAP datasphere

Replication flow fails with the error: 

failed to create virtual table: SQL Error 476 - invalid remote object name: Unable to retrieve remote metadata for <table_name>.

SAP Datasphere 1.0

The issue is caused by an inconsistency in the database name during the process of publishing the delta share from the source system to the target system.

In order to resolve the issue, follow the steps below:

1. Review the process of publishing the delta share from the source system to the target system to identify any discrepancies in the database name.
2. Create a new data product from the source system and publish it to the target system.
3. During the installation of the data product, ensure that the data storage is set to remote.
4. Verify the replication flow execution and confirm that the data can be virtually read from the source system.

• Troubleshooting Scenarios in Replication Flow
• Creating a Replication Flow | SAP Help Portal

replication flow, virtual table, SQL error 476, invalid remote object name, metadata retrieval failure, SAP datasphere, CDS extraction, S/4HANA, database inconsistency, remote data storage , KBA , DS-DI-RF , Replication Flow Runtime , DS-MD-REPO , Repository Backend , Problem