OTM 6.4.1 Migration Issue (Doc ID 2111390.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Transportation Management - Version 6.4.1 and later
Information in this document applies to any platform.

Symptoms



Encountered the error below when running dbpatch.sh when running migration from OTM 6.3.7 to 6.4.1


Load new data content...
BEGIN security.insert_user_menu_layout_data; END;

*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("GLOGOWNER"."USER_ACCESS"."INSERT_USER")
ORA-06512: at "GLOGOWNER.SECURITY", line 59
ORA-06512: at "GLOGOWNER.SECURITY", line 223
ORA-06512: at "GLOGOWNER.SECURITY", line 92
ORA-06512: at line 1


*** ERROR *** Migration errors, migration not completed. Return Code 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run dbpatch.sh


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