Duplicate insert warning in the Database

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
prajish_ap
Participant
Posts: 11
Joined: Tue Nov 21, 2006 3:08 am
Location: Pune

Duplicate insert warning in the Database

Post by prajish_ap »

INSERT,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.TableA' with unique index 'XPKTableA_SEQ'.
Top
sanjay.v
Participant
Posts: 2
Joined: Tue Nov 21, 2006 1:19 am

Post by sanjay.v »

i think your write method is upsert and upsert mode is insert only..and you are trying to insert a duplicate record into the table... check whether the option - output reject records is set to true...and try capturing the rejects...
Top
Akumar1
Participant
Posts: 48
Joined: Tue May 22, 2007 3:38 am
Location: bangalore
Contact:
Contact Akumar1

Hi

Post by Akumar1 »

Better filter the data in the source systems itself for duplication handling.

Regards,
Akumar1:)
sanjay.v wrote:i think your write method is upsert and upsert mode is insert only..and you are trying to insert a duplicate record into the table... check whether the option - output reject records is set to true...and try capturing the rejects...
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”