SAP Knowledge Base Article - Public

3699488 - Replication flow is failing with "only INSTEAD OF triggers are allowed on SQL views" in SAP Datasphere

Symptom

Replication flow is failing with the error "feature not supported: only INSTEAD OF triggers are allowed on SQL views"

Environment

SAP Datasphere

Reproducing the Issue

  1. Check the replication flow in the Data Integration Monitor
  2. Observe that the replication flow fails with the database error message "feature not supported: only INSTEAD OF triggers are allowed on SQL views".

Cause

  • The CDS view is not defined correctly
  • A database view is used in the CDS definition instead of technical names of database tables in the annotation Analytics.dataExtraction.delta.changeDataCapture.mapping.table

Resolution

Adjust the CDS view to reference only technical names of database tables. Please note that custom CDS development is the responsibility of the customer.

Keywords

change data capture, cdc , KBA , DS-DI-RF , Replication Flows , DS-DI-ABA , Data Flow / Replication Flow with ABAP as data source , Problem

Product

SAP Datasphere all versions