Parallel job reports failure (code 134)-> Oracle Enterpri

yenepalli · Post by **yenepalli** » Thu Aug 25, 2011 7:33 am

Hello DS experts

I have designed a simple job which reads from an oracle db using Oracle Enterprise stage , transforms and loads it to an Oracle Enterprise. I am faced with the below error:" Parallel job reports failure (code 134)" when I run the job.

I searched the website with the error message, but none could help.

Kindly advise

Thank You

arvind_ds · Post by **arvind_ds** » Thu Aug 25, 2011 7:37 am

Have a look on this.

https://www-304.ibm.com/support/docview ... wg1JR30206

kommven · Post by **kommven** » Thu Aug 25, 2011 8:56 am

please give more specific details of Oracle EE Stage.

Are you loading using "Load"?
Are you using timestamps Vs Dates?
Changing to insert helps?

yenepalli · Post by **yenepalli** » Fri Aug 26, 2011 5:24 am

Helo Ven

Thanks for ur reply,

I am using Load method, insert does not help, simple varchar oonly, no time stamps being used....

Couldn't get job run... please help any and does this relate to setting up of oracle home path on unix server like

"anything needs to be added on UniX server environment in the $Path directory regarding $Oracle_Home ?"

Thanks and Regards
Satya

kommven · Post by **kommven** » Fri Aug 26, 2011 9:27 am

Satya,
Can you check NLS_LANG on Oracle Server and dataStage Server.
override NLS_LANG in your job with that of Oracle DB.

And if that wont help let us know more details from Director log.

Well talking about configuring. If this is your first time defining Oracle EE, sure you have to follow configuration as prescribed. Post you env from Director log.