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.

Symptoms


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

<CSVUtil>
<Command>ii</Command>
<DataDir>./content_glogowner/</DataDir>
<DataFileName>V60P_TRANSLATION_D_en.csv</DataFileName>
<ExcludePublic>true</ExcludePublic>
<ProcessCSV>
<xvalidate>true</xvalidate>
<DatabaseGlobalName>OTMDEV</DatabaseGlobalName>
<TableName>TRANSLATION_D</TableName>
<ColumnList>TRANSLATION_GID,LANG,COUNTRY,VARIANT,TEXT,DOMAIN_NAME</ColumnList>
<sqlString>insert into TRANSLATION_D ( TRANSLATION_GID,LANG,COUNTRY,VARIANT,TEXT,DOMAIN_NAME) values (?,?,?,?,?,?)</sqlString>
<Error>
<TableName>TRANSLATION_D</TableName>
<Exception>ORA-02291: integrity constraint (GLOGOWNER.FK_TRNSD_TRANSLATION_GID) violated - parent key not found
</Exception>
<Data>field.contact/group/saved_query/xid,en,*,*,Saved Query ID,PUBLIC</Data>
</Error>
<ProcessCount>913</ProcessCount>
<ErrorCount>1</ErrorCount>
<SkipCount>1305</SkipCount>
</ProcessCSV>
</CSVUtil>

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