SAP Knowledge Base Article - Preview

3019249 - Error: "Common User Name (Case Sensitive)] is mandatory" when executing replication task with Oracle RAC as remote source

Symptom

  • Execute replication task with Oracle 19c RAC as remote source
  • Remote source is through OracleECCAdapter with capture mode "Trigger", "Common User Name" is already provided in the remote source configuration
  • Error: "SQL Error: start task error: Error executing SQL command in task.;Error executing ALTER_REMOTE_SUBSCRIPTION_QUEUE with command: 'ALTER REMOTE SUBSCRIPTION <SUBSCRIPTION_NAME> QUEUE'. ,exception 71000256: QUEUE: <SUBSCRIPTION_NAME>: Error occurred in start subscription call to adapter OracleECCAdapter for remote subscription <Subscription_Name>  in remote source <REMOTESOURCE_NAME>. Error: exception 151052: CDC start subscription failed: RS[REMOTE_SOURCE]: Adapter validation failed. Failed to validate properties. Error(s): 
    Property [Common User Name (Case Sensitive)] is mandatory.
    Property [Common User Password] is mandatory.”


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

SDI, RAC, oracle 19c, trigger, ECC , 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.