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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.