Extract Transform Load (ETL) Fails with Error:'ODI-1228: Task Loading-SS0-Create View on Target fails on the target connection TRG_ODMCONN_PHYSICAL' after Source (Agile) Schema Password Update (Doc ID 2901050.1)

Last updated on OCTOBER 06, 2022

Applies to:

Symptoms

ETL is failing with error.

Modified the password for source connection database (Agile) and updated the same in the connection details in Oracle Product Lifecycle Analytics (OPLA).The test connection is successful.
But after the ETL is triggered, it is failing with the below error and the Agile schema account is locked.

"ODI-1226: Step odi_int_ODM_LISTNAME_933_cdc fails after 1 attempt(s).
ODI-1240: Flow odi_int_ODM_LISTNAME_933_cdc fails while performing a Loading-SS0-Create View on Target operation. This flow loads target table ODM_LISTNAME_STG.
ODI-1228: Task Loading-SS0-Create View on Target fails on the target connection TRG_ODMCONN_PHYSICAL.
Caused By: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from PLMSTAGE
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from PLMSTAGE"

In addition to the password change, upgraded the JDK version from jdk1.8.0_301 to jdk1.8.0_341.



ERROR

ODI-1226: Step odi_int_ODM_LISTNAME_933_cdc fails after 1 attempt(s).
ODI-1240: Flow odi_int_ODM_LISTNAME_933_cdc fails while performing a Loading-SS0-Create View on Target operation. This flow loads target table ODM_LISTNAME_STG.
ODI-1228: Task Loading-SS0-Create View on Target fails on the target connection TRG_ODMCONN_PHYSICAL.
Caused By: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from PLMSTAGE
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from PLMSTAGE




STEPS

The issue can be reproduced at will with the following steps:

1. Log into Agile DB as sys/sysdba.
2. Update the Agile Schema password by running below query
ALTER USER <AGILESCHEMA_USERNAME> IDENTIFIED BY <NEW_PASSWORD>;
3. Log into OPLA and go to OPLA connection details and Oracle Data Integrator (ODI) Topology.
4. For Agile profile, replace the existing password with the new password.
5. Connect to OPLA Server and upgrade jdk1.8.0_301 to jdk1.8.0_341.
6. Restart ODI Agent.
7. Test the connection from OPLA to Agile ; it is successful.
8. Trigger ETL in OPLA.
9. ETL fails with error.

Changes

 Agile schema password updated in Agile Database and in OPLA Connection details.

Cause

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