We have a domain created in FMW 12.2.1.2.0 and now we are trying to upgrade it to 12.2.1.3.0 but somehow we are unable to proceed further in the GUI. Below is the detailed information.
Domain Created in : FMW 12.2.1.2.0
Trying the Upgrade this domain to : FMW 12.2.1.3.0
Script Used to Upgrade the Domain: FMW 12.2.1.3.0<ORACLE_HOME>/oracle_common/common/bin/reconfig.sh
Below is the screen where we are getting the error
Below is the error log:
Error message: 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)
at com.oracle.cie.rcu.external.ComponentSchemaInfoFactory.getComponentSchemaInfos(ComponentSchemaInfoFactory.java:41)
... 1 more
.
On comparing the STB schemas of FMW 12.2.1.2 and 12.2.1.3 we find the below differences
Where LOCAL = STB Schema of FMW 12.2.1.2
and REMOTE = STB Schema of FMW 12.2.1.3
| SCHEMA | TABLE_NAME | COLUMN_NAME | DATA_TYPE | DATA_LENGTH | NULLABLE |
| REMOTE | COMPONENT_SCHEMA_INFO | CONNPROPS | BLOB | 4000 | Y |
| REMOTE | COMPONENT_SCHEMA_INFO | URL | VARCHAR2 | 4000 | Y |
| LOCAL | SERVICETABLE | ID | VARCHAR2 | 50 | N |
| REMOTE | SERVICETABLE | ID | VARCHAR2 | 200 | N |