My Oracle Support Banner

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.

Symptoms

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:

Changes

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.

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!


In this Document
Symptoms
Changes
Cause
Solution


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