Foreign key value zero is not allowed. Queue name "
queue_name
". Record number
record_number
.
In a PowerCenter session that performs a multiple-record write to a nonrelational target, an attempt was made to insert a record with a foreign key value of zero. This value is not allowed in the foreign key field of a child record.
Typically, PowerExchange generates primary keys automatically in the source definition when you select
Use Sequence Felds
in the
Import from PowerExchange
dialog box. If an attempt is made to generate primary keys within a workflow, rather than by selecting
Use Sequence Felds
, and the attempt does not produce correct values, this error message can result.
The task that encountered the error terminates.
Fix the workflow so that it produces correct values.