My Oracle Support Banner

DIPC-C Sync Table Fails with "ODI-1228: Task Procedure-Initial load_PROC-DBLINK_DATAPUMP fails on the target connection" (Doc ID 2444256.1)

Last updated on JUNE 06, 2023

Applies to:

Data Integration Platform Cloud Classic - Version 18.2.3 to 18.3.3
Information in this document applies to any platform.

Symptoms

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.

 

On user-managed Oracle Data Integration Platform Cloud Classic (DIPC-C) 18.2.3, with both source and target are Plugable Database (PDB) Cloud instances, a synchronize data operation fails with an "ORA-39002: invalid operation" error.

ODI-1228: Task Procedure-Initial <PROCEDURE_TASK_NAME> fails on the target connection
Caused By: java.sql.SQLException: ORA-39002: invalid operation
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4087
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4338
ORA-06512: at line 82
ORA-06512: at line 145

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!

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