My Oracle Support Banner

Why do I get TT3001: Foreign key violation [child_FK] from a ttmigrate restore? (Doc ID 1674483.1)

Last updated on AUGUST 23, 2021

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

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
Goal
Solution

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