SAP Knowledge Base Article - Preview

3717168 - "Failed to add the first subscription" when trying to enable real-time replication for Microsoft Fabric - SAP HANA Smart Data Integration

Symptom

  • Connection to Microsoft Fabric using the MssqlLogReaderAdapter (or MSSQL connection type in Datasphere) works, and it is possible to replicate data via snapshots.
  • However, trying to enable real-time replication fails with the following error message in the DP Agent logs:
    • DPFramework | WorkerThread.processRequest [] - com.sap.hana.dp.adapter.sdk.AdapterException: [Driver error] Failed to add the first subscription. Error: java.sql.SQLException: DROP TRIGGER is not supported.Failed to drop triggers of


Read more...

Environment

SAP HANA Smart Data Integration

Keywords

real-time replication, ms fabric, create trigger, drop trigger, snapshot replication, sql error code 256, cdc add subscription failed, unsupported statements, remote table replication, replication failure, mssql, ms sql, dp agent, dpa, dpagent, dwc, real time, realtime , KBA , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , 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.