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 primary key value. The layer that manages the sequencing and queuing cache requires that records that are inserted into a multiple-record file have unique ascending numerical values in the primary key column.

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.