ORA-01400: cannot insert NULL into ("WMSYS"."WM$RIC_TRIGGERS_TABLE$"."PT_ VTID#") During Upgrade to 12.1.0.2 (Doc ID 2152621.1)

Last updated on JUNE 22, 2016

Applies to:

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

Symptoms

During an upgrade from 11.2 to 12.1.0.2, the following errors were reported for Workspace Manager:

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


The wmsys.wm$migration_error_table has the following error:

ERROR_TEXT
--------------------------------------------------------------------------------
*** ERROR #1 ***
---------------------------------
SQL: insert into wmsys.wm$ric_triggers_table$
  (select (select vtid# from wmsys.wm$versioned_tables$ vt where vt.own
er=t.pt_owner and vt.table_name=t.pt_name),
  (select vtid# from wmsys.wm$versioned_tables$ vt where vt.own
er=t.ct_owner and vt.table_name=t.ct_name),
  rownum
  from wmsys.wm$ric_triggers_table t)
ERROR: ORA-01400: cannot insert NULL into ("WMSYS"."WM$RIC_TRIGGERS_TABLE$"."PT_
VTID#")

ERROR_TEXT
--------------------------------------------------------------------------------
STACK:
----- PL/SQL Call Stack -----
 object line object
 handle number name
0xd32c4168 3705 package body WMSYS.OWM_VSCRIPT_PKG
0xd32c4168 3686 package body WMSYS.OWM_VSCRIPT_PKG
0xd32c4168 2799 package body WMSYS.OWM_VSCRIPT_PKG
0xd32c4168 3532 package body WMSYS.OWM_VSCRIPT_PKG
0xe8ff8418 2 anonymous block

---------------------------------

ERROR_TEXT
--------------------------------------------------------------------------------


The status of Workspace Manager is VALID after running utlrp.sql, and there are no invalid WMSYS objects.

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