SAP Knowledge Base Article - Preview

3387013 - Activating a real-time replication task for OracleLogReaderAdapter with Trigger capture mode returns error 'ORA-01031:insufficient privileges'

Symptom

  • When trying to activate a replication task, you run into an error below.
    • Error: exception 151050: CDC add subscription failed: RS[<REMOTE_SOURCE_NAME>]: Failed to add the first subscription. Error: java.sql.SQLSyntaxErrorException: ORA-01031:insufficient privileges


Read more...

Environment

  • DP Agent version 2.7.1.1
  • ORACLE 19c
  • ECC 6.0

Product

SAP HANA smart data integration all versions

Keywords

  • SDI, Smart Data Integration, ORACLE, ORA-01031, insufficient privileges, trigger-based replication, rep task, replication task, trigger
, KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.