ORA-02291: integrity constraint error after OTM migration

(Doc ID 1316876.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.0 and later   [Release: 6.2 and later ]
Information in this document applies to any platform.


=== ODM Issue Clarification ===
After migrating OTM 6.1 to 6.2 receiving the following error in the update_content log:

<sqlString>insert into TRANSLATION_D ( TRANSLATION_GID,LANG,COUNTRY,VARIANT,TEXT,DOMAIN_NAME) values (?,?,?,?,?,?)</sqlString>
<Exception>ORA-02291: integrity constraint (GLOGOWNER.FK_TRNSD_TRANSLATION_GID) violated - parent key not found
<Data>field.contact/group/saved_query/xid,en,*,*,Saved Query ID,PUBLIC</Data>


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