3529104 - Does Replication flow support replication to Synonym tables of HANA DB?

Symptom

Can synonym tables be used as "target" objects in Replication Flows where the target is a HANA database?

For a Replication Flow where the source is Datasphere and target is a HANA system, if a HANA synonym table is used as the target object, below errors are received:

Failed to prepare target table for replication due to database error. (SQL error code = 330, SQL error msg = SAP DBTech JDBC: [330]: cannot use duplicate synonym name:"ABC" : line 1 col 24 (at pos 23)). Contact the system administrator for the HANA system to address the issue and then resume the replication task.

Fail to execute update statement "DM_USER"."S_TEST_33": com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [330]: cannot use duplicate synonym name: ABC: line 1 col 24 (at pos 23)

Environment

SAP Datasphere

Product

SAP Business Technology Platform all versions

Keywords

KBA , DS-DI-RF , Replication Flows , 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.