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

(Doc ID 2152621.1)

Last updated on DECEMBER 18, 2017

Applies to:

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


During an upgrade from 11.2 to, 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 #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),
  from wmsys.wm$ric_triggers_table t)
ERROR: ORA-01400: cannot insert NULL into ("WMSYS"."WM$RIC_TRIGGERS_TABLE$"."PT_

----- 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



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


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