Why do I get TT3001: Foreign key violation [child_FK] from a ttmigrate restore?

(Doc ID 1674483.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 7.0.1.0.0 to 11.2.2.6.3 [Release 7.0 to 11.2]
Information in this document applies to any platform.

Goal

 The following error has been reported while doing ttMigrate -c / -r on a subscriber datastore:

Restoring table DG.child
 Restoring foreign key dependency child_fk
 Restoring foreign key dependency child_fk
 Restoring index DG.child_UDX
 Restoring rows...
ttMigrate: Error received while inserting row 2704 -- 23000:
[TimesTen][TimesTen 11.2.1.9.8 ODBC Driver][TimesTen]TT3001: Foreign key
violation [child_FK]: the row in child table DG.child has no key in the
parent table DG.parent -- file "constr.c", lineno 2357, procedure
"sbSmxCheckAllConstr()" (TimesTen error code = 3001).
Dropping partially-restored table DG.child...

Solution

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