My Oracle Support Banner

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

Last updated on NOVEMBER 21, 2019

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.


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

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