Bug in Surrogate Key Generator Stage

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
Ankur_KapoorUK
Participant
Posts: 64
Joined: Fri Feb 05, 2010 5:29 am
Location: India, UK

Bug in Surrogate Key Generator Stage

Post by Ankur_KapoorUK »

Hi Experts ,

I am facing a very issue -- Surrogate key generatory is not generating the new surroagate id's for some Id's.
This is resulting in abort of job while loading because of unique key constraints.

I there is any bug in the stage itself. I dont see any reason why it is not doing.

One more thing to note is for 2000 records , it is generating unique id for most if the records , only for 30-40 records the sk id get repeated ??

Please clarify. I need quick help on this .. Its urgent..

Details
-------
Source Type = Flat File
Generate Key from Last Value = Yes
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Ankar,

since you have marked this as an "urgent" issue you should go to your support provider as the general reaction from the volunteers here to such demands is to ignore the post for a while, which I will do.

Also add some details to your problem description since what you posted isn't sufficient to make any determination.
Post Reply