Primary key value zero is not allowed. Queue name "
queue_name
". Record number
rec_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 primary key value of zero. This value is not allowed.
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.