unique constarint violated

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
rsunny
Participant
Posts: 223
Joined: Sat Jul 03, 2010 10:22 pm

unique constarint violated

Post by rsunny »

HI everyone,

when i run a job with some transformations ,everyting is working fine .i am getting a warning as

jsControlTie1..xfm7: ORA-00001: unique constraint (CSS.PK5) violated

so i am unable to load all the records in the table.

please can any one suggest what should i do in order to get rid of this issue.

thanks in advance
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

That one's easy. Don't send records to Oracle that violate that particular UNIQUE constraint.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

Re: unique constarint violated

Post by yaminids »

Try storing rejected records to a file and check what's causing the unique constraint violation
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”