OID Generation failed

aaryabhatta · Post by **aaryabhatta** » Tue May 26, 2009 4:47 am

Hi,

We have a job which loads multiple tables from different datasets.
On running the job the following error is logged in director for some of the oracle stages randomly. Error is not thrown for the same oracle stages. It is random.

ORA-21561: OID generation failed

No error logs available in oracle database for this error.
Can somebody let me know if they have faced the similar issue earlier and the solution applied to resolve the same or if you have some idea about this error?

Thanks in Advance!

Regards

chulett · Post by **chulett** » Tue May 26, 2009 6:43 am

I've never seen it and it hasn't been posted here before. Perhaps this might help?

http://tinyurl.com/qm4eyy

ArndW · Post by **ArndW** » Tue May 26, 2009 7:28 am

Awesome link!

miwinter · Post by **miwinter** » Tue May 26, 2009 10:00 am

Now that's pure class

:D

nagarjuna · Post by **nagarjuna** » Tue May 26, 2009 11:24 am

Awesome link ....Kudos :D

chulett wrote:I've never seen it and it hasn't been posted here before. Perhaps this might help?

http://tinyurl.com/qm4eyy

...

vinothkumar · Post by **vinothkumar** » Tue May 26, 2009 11:31 am

Can you please explain what you did to resolve this issue ?

nagarjuna · Post by **nagarjuna** » Tue May 26, 2009 11:33 am

Hey sorry for digressing from the topic ...i posted awesome link because the way craig replied is good ..i dont think real problem is fixed ...

chulett · Post by **chulett** » Tue May 26, 2009 1:04 pm

While amusing, it was a legitimate attempt to help and hopefully that link actually yields some results for them. Seemed like it would to me when I checked the results it found.

aaryabhatta · Post by **aaryabhatta** » Wed May 27, 2009 6:48 am

Problem is not yet solved. We have done the basic homework but couldnt find much information on this.

Since no log is available in Oracle, I wonder if it has to do something with DataStage itself particularly reading from dataset.

chulett · Post by **chulett** » Wed May 27, 2009 6:49 am

Hard to say. Have you involved your official support provider yet?