Oracle Load method

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
mc_harsha
Premium Member
Premium Member
Posts: 32
Joined: Mon Mar 06, 2006 5:44 am
Location: bangalore

Oracle Load method

Post by mc_harsha »

Hi,

Using oracle load method, index=Rebuild.

Getting Fatal error :
RPM_ITEM_ZONE_PRICE: Oracle call failed; sqlcode = -12801; message: ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

But job finished.

Finished Job ldEGMY006RPMItemZonePrice.

Why job not aborted? Any suggestions?
Do i need to set any property to make job abort?

with regards,
MCh
harshakumar mc
satya99
Participant
Posts: 104
Joined: Thu Nov 30, 2006 1:22 pm

Post by satya99 »

Can you move the job to parallel edition :)
satya
Post Reply