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.