My Oracle Support Banner

'Update failure' Is Signaled When Upgrading An ODI (Sunopsis) Work Repository From V3 to V4 (Doc ID 424758.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 4.1.01.04 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When upgrading an ODI (Sunopsis) "Development" type Work Repository From V3 to V4, the following message is displayed:

Update failure
java.lang.NullPointerException
  at com.sunopsis.migration.a.a.d(a.java)
  at com.sunopsis.migration.a.a.g(a.java)
  at com.sunopsis.migration.a.b.b(b.java)

From the ODI (Sunopsis) CONSOLE Window, all SQL scripts apear to have been executed, since the last line in this Window concerns the Repository Version update:

03/21/2006 04:17:44 PM(AWT-EventQueue-0): DwgXmlSession.execute : execute order : ALTER TABLE SNP_SOURCE_TAB ALTER COLUMN IND_JRN VARCHAR2(2 CHAR)
03/21/2006 04:17:44 PM(AWT-EventQueue-0): DwgXmlSession.execute : execute order : ALTER TABLE SNP_SOURCE_TAB ALTER COLUMN IND_JRN SET VARCHAR2(2 CHAR)
03/21/2006 04:17:44 PM(AWT-EventQueue-0): DwgXmlSession.execute : execute order : UPDATE SNP_LOC_REPW set REP_VERSION = '4.1.01.01'

Note that if the Work Repository update procedure is re-started, an "Update completed" message is immediately displayed and the Work Repository may be used as normal.

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
Cause
Solution
 Work around for earlier versions:

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