In a PowerCenter session that performs a multiple-record write to a nonrelational target, an attempt was made to insert a record with an invalid foreign key value. The layer that manages the sequencing and queuing cache requires that records that are inserted into a multiple-record file have numerical values that do not descend in the foreign key column within a particular queue name.

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.