How to solve the " java.sql.SQLSyntaxErrorException: ORA-00904: "TITLE": invalid identifier" after installing the Oracle Knowledge 8.6.1 patch?
(Doc ID 2419420.1)
Last updated on SEPTEMBER 07, 2018
Applies to:Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.
ODI job is failing after applying the Oracle Knowledge 8.6.1 patch (step 3.8.7).
We are getting the below exception while running the MAIN package in ODI:
Error tables are created just once when the respective interface is run. In your screen shot it was in step 6. control - DIM_Locale - create error table.
In 8.6 line, we added some extra columns for some table, which would be added into E$ tables as well. If we don't drop error tables, ODI job will see an existing E$ table and thus doesn't create E$ tables which fits with 8.6. That's why we need to drop them when we migrate from 8.5 to 8.6.
A reprocess is necessary after dropping E$ tables.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!