Error "CFGFWK-64219: Failed to bind the schema component data" and "Invalid column name" When Upgrading ODI Standalone Agent Domain to ODI 12.2.1.3.0

(Doc ID 2349055.1)

Last updated on JANUARY 23, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When attempting reconfigure the domain during an upgrade of Oracle Data Integrator (ODI) 12.2.1.2.0 to ODI 12.2.1.3.0 using the reconfig.sh tool, the following error occurs.

CFGFWK-64219: Failed to bind the schema component data
com.oracle.cie.domain.gui.jdbc.ShadowTableConfigurationPanel$BindThread - com.oracle.cie.rcu.external.ComponentSchemaInfoException: SQLException thrown
  at com.oracle.cie.rcu.external.ComponentSchemaInfoFactory.getComponentSchemaInfos(ComponentSchemaInfoFactory.java:48)
  at com.oracle.cie.domain.gui.jdbc.ShadowTableConfigurationPanel$BindThread.run(ShadowTableConfigurationPanel.java:915)
  ...
Caused by: java.sql.SQLException: Invalid column name
  at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3757)
  at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:264)
  at oracle.jdbc.driver.GeneratedResultSet.getString(GeneratedResultSet.java:594)
  ...

Changes

 

Cause

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 hundreds of Community platforms