Error: No primary key value for foreign key


Description: No primary key value for foreign key Could not execute statement.
No primary key value for foreign key 'fkey_target_id' in table
'es_paycheck_header'
SQLCODE=-194, ODBC 3 State="23000"
File: "reload.sql" on line 39672, column 1
ALTER TABLE "QBAdminGroup"."es_paycheck_header"
ADD FOREIGN KEY "fkey_target_id" ("target_id")
REFERENCES "QBAdminGroup"."es_paycheck_lineitem" ("target_id")
CHECK ON COMMIT
(Continuing after error)
Could not execute statement.
No primary key value for foreign key 'fkey_transaction_id' in table
'es_paycheck_lineitem'
SQLCODE=-194, ODBC 3 State="23000"
File: "reload.sql" on line 39736, column 1
ALTER TABLE "QBAdminGroup"."es_paycheck_lineitem"
ADD FOREIGN KEY "fkey_transaction_id" ("transaction_id")
REFERENCES "QBAdminGroup"."es_paycheck_header" ("transaction_id")
CHECK ON COMMIT
(Continuing after error)



To fix the error code "No primary key value for foreign key", click the 'Start Now' button below for Quickbooks Data Recovery.

• Recovery Procedure
• Which version of Quickbooks am I using?
• Quickbooks Error Codes
• QBFC Error Codes
• Quickbooks Upgrade Issues or Problems
• Quickbooks Condense/Optimization Service
• Quickbooks PC to Mac Conversion
• Quickbooks Mac to PC Conversion
• Quickbooks Enterprise to Pro Conversion/Downgrade
• Common Quickbooks Issues