Failure During DIPC-C Replication Task at "Initialize Capture" Action
(Doc ID 2510734.1)
Last updated on JUNE 16, 2022
Applies to:
Data Integration Platform Cloud Classic - Version 18.4.3 and laterInformation in this document applies to any platform.
Symptoms
While configuring a Data Integration Platform Cloud Classic (DIPC-C) Data Replication task between Database Cloud Service (DBCS) and Autonomous Data Warehouse Cloud Service (ADWC), it fails on the "Initialize capture" action.
The error seen in the <AGENT_HOME>/dicloud/agent/<Agent_Name>/logs/dicloudAgent.log file:
[2019-02-21T12:56:47.673+00:00] [dicloud] [ERROR] [] [oracle.dicloud.agent.conn.plugin.ConnectivityPlugIn] [tid: <TID>] [ecid: <ECID>] ORA-00942: table or view does not exist[[
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1051)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:537)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:609)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:724)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:921)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1099)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1293)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)
at oracle.dicloud.connection.core.OracleConnectionHelper.isPDBConnection(OracleConnectionHelper.java:261)
at oracle.dicloud.connection.core.OracleConnectionHelper.getPdbInfo(OracleConnectionHelper.java:287)
at oracle.dicloud.connection.dto.GetPdbInfoConnectionDTO.execute(GetPdbInfoConnectionDTO.java:19)
...
Caused by: Error : 942, Position : 16, Sql = SELECT CDB FROM V$DATABASE, OriginalSql = SELECT CDB FROM V$DATABASE, Error Msg = ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 23 more
Steps to reproduce:
- Configure source Data Source - container database (CDB) and pluggable database (PDB), and target ADWC data source in the DIPC console.
- Test connection of source and target from DIPC.
- Configure the replication task in DIPC console.
- When the task is executed, it fails on Initialize capture task.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |