My Oracle Support Banner

The ODI 12c Export of Technical Environment Does Incorrectly Detect the Database of Work Repositories If Different than the Master Repository Database (Doc ID 2987721.1)

Last updated on NOVEMBER 17, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

Having an Oracle Data Integrator (ODI) 12c environment composed of:

The "Export of Technical Environment" incorrectly shows database and version on technology A for all the Work Repositories attached, including the Work Repository on technologies other than A.

In the example below, observe the database and version for the Work Repository called WORKREP_MYSQL is incorrect, while the internal Data Server created for it shows correct information:

...
MASTER,"0","05.02.02.11","Oracle","Oracle Database 12c Enterprise Edition...","Oracle JDBC driver","19.3.0.0.0"
WORK,"<ID>","WORKREP_MYSQL","W","MySQL","Oracle Database 12c Enterprise Edition...","MySQL Connector/J","mysql-connector-java-commercial-8.0.14 (Revision: ..."
...
TECHNO,"MySQL","WORKREP_MYSQL","MySQL","8.0.33","MySQL Connector/J","mysql-connector-java-commercial-8.0.14 (Revision: ...)"
...

To be correct, the "Export of Technical Environment" must show the database and version on the correct technology and version.

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

  1. Have a Master Repository on Oracle database, and a Work Repository on MySql.
  2. In ODI Studio, activate the floating menu, and chose: Export > Export the Technical Environment.
  3. Review the .csv file generated.

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.