My Oracle Support Banner

OIM Upgrade From To Fails with ORA-00904: "CONTEXTID": invalid identifier error (Doc ID 1436019.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Identity Manager - Version and later
Information in this document applies to any platform.Symptoms

When OIM is upgraded from to and for any reason, is re-run, the following error shows up in patch_weblogic.log (happening during contextdataupgrade step):


[exec] [EL Info]: 2012-03-08 21:19:40.993--ServerSession(5035392)--EclipseLink, version: Eclipse Persistence Services - 2.1.3.v20110304-r9073
[exec] [EL Info]: 2012-03-08 21:19:41.178--ServerSession(5035392)--oim login successful
[exec] Updating orchprocess table with context values
[exec] java.sql.SQLSyntaxErrorException: ORA-00904: "CONTEXTID": invalid identifier
[exec] at oracle.jdbc.driver.T4CTTIoer.processError(
[exec] at oracle.jdbc.driver.T4CTTIoer.processError(
[exec] at oracle.jdbc.driver.T4C8Oall.processError(
[exec] at oracle.jdbc.driver.T4CTTIfun.receive(
[exec] at oracle.jdbc.driver.T4CTTIfun.doRPC(
[exec] at oracle.jdbc.driver.T4C8Oall.doOALL(

This error gives an impression that something failed during patching.


This error seems to happen ONLY when OIM is upgraded from to and for any reason, is re-run.

The major and minor version are specifically those mentioned above.
It does not happen when upgraded to from or any versions prior to that like and below.


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.