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 that is greater than the primary key value. The layer that manages the sequencing and queuing cache requires that records that are inserted into a multiple-record file have foreign key values that point to records that have already been processed.
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.