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.
SAP Knowledge Base Article - Preview