ORA-01400: Cannot Insert NULL Into ("WMSYS"."WM$WORKSPACES_TABLE$"."POST_VERSION") Migrating To 12c (Doc ID 1940280.1)

Last updated on NOVEMBER 06, 2014

Applies to:

Workspace Manager - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Attempting to manually migrate a database from 11.2.0.4 to 12.1.0.1 resulted in errors that led the following in the catupgrd.sql output log:

===================================================================
.   ORA-20001: Errors encountered during table migration.  Query
.   wmsys.wm$migration_error_table.
.   ORA-06512: at "WMSYS.OWM_VSCRIPT_PKG", line 3615
.   ORA-06512: at "WMSYS.OWM_VSCRIPT_PKG", line 3429
.   ORA-06512: at line 2
===================================================================

wmsys.wm$migration_error_table listed the following error :

===================================================================
ERROR: ORA-01400: cannot insert NULL into ("WMSYS"."WM$WORKSPACES_TABLE$"."POST_VERSION")
===================================================================

Cause

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 hundreds of Community platforms