SAP Knowledge Base Article - Public

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

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. The custom CDS development is the responsibility of the customer.

Keywords

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

Product

SAP Datasphere all versions