My Oracle Support Banner

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 later
Information in this document applies to any platform.


This knowledge article reflects updated product names. Data Integration Platform Cloud (DIPC) was formerly known as Autonomous Data Integration Platform Cloud (ADIPC). Data Integration Platform Cloud Classic (DIPC Classic or DIPC-C) was formerly known as Data Integration Platform Cloud (DIPC). Please see KM <document 2493395.1> for the full list of recently renamed PaaS services.

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(
  at oracle.jdbc.driver.T4CTTIoer11.processError(
  at oracle.jdbc.driver.T4C8Oall.processError(
  at oracle.jdbc.driver.T4CTTIfun.receive(
  at oracle.jdbc.driver.T4CTTIfun.doRPC(
  at oracle.jdbc.driver.T4C8Oall.doOALL(
  at oracle.jdbc.driver.T4CStatement.doOall8(
  at oracle.jdbc.driver.T4CStatement.doOall8(
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
  at oracle.jdbc.driver.OracleStatement.executeQuery(
  at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(
  at oracle.dicloud.connection.core.OracleConnectionHelper.isPDBConnection(
  at oracle.dicloud.connection.core.OracleConnectionHelper.getPdbInfo(
  at oracle.dicloud.connection.dto.GetPdbInfoConnectionDTO.execute(
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(
  ... 23 more

Steps to reproduce:

  1. Configure source Data Source - container database (CDB) and pluggable database (PDB), and target ADWC data source in the DIPC console.
  2. Test connection of source and target from DIPC.
  3. Configure the replication task in DIPC console.
  4. When the task is executed, it fails on Initialize capture task.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.