Parallel job reports failure (code 134)

jastichoudaryuu · Post by **jastichoudaryuu** » Thu Jan 31, 2013 4:21 pm

Hi,

Has anyone come across this error? Parallel job reports failure (code 134)- What is this? I don't have any other messages.

I have designed a simple job job which extracts data from db2 (odbc connector) and Transformer(one to one mapping) and loading into targte sybase(sybase bulk load stage)

i can see no other error in logs

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

Kindly advise

Thank You ,
Anil

ray.wurlod · Post by **ray.wurlod** » Thu Jan 31, 2013 4:34 pm

Try a search on just "code 134". There is a dozen hits, two of which are marked as Resolved.

jastichoudaryuu · Post by **jastichoudaryuu** » Thu Jan 31, 2013 10:09 pm

Hi ray,

Thanks for the responce, i didnt find any clue on this issue, could you explain possibilities of this error

chulett · Post by **chulett** » Fri Feb 01, 2013 7:50 am

Meaning your search didn't find anything or you read all of the posts, tried some things and nothing helped?

Out of curiousity, when the job aborted did you try resetting the job from the Director? If so, did it add anything to the log saying 'From previous run...'? If so, post the contents.

eph · Post by **eph** » Fri Feb 01, 2013 8:08 am

Hi,

I suggest you to contact your provider/IBM support for more info.

You can check this link http://www-01.ibm.com/support/docview.w ... wg1JR30206 (you didn't mention you DS version), or this one http://www-01.ibm.com/support/docview.w ... wg21410927, which has been provided by IBM to my project for such errors (DS v8.1).
Anyway I think contact your support for your case.

Regards,
Eric

chandra.shekhar@tcs.com · Fri Feb 01, 2013 8:11 am

I know my answer will sound stupid but even then try it.

Copy all the contents of your job and paste it in a new job.
Then try running it.

Nagaraj · Post by **Nagaraj** » Fri Feb 01, 2013 8:47 am

And Also please check column to column mapping and the data types sometimes if there is a completely wrong mapping done, which throws this error abruptly.

ddsouza · Post by **ddsouza** » Mon Jul 25, 2016 6:43 pm

I got this error recently and there was not further message. Upon investigation, we found that the SQL server had been virtualised and the database had been moved to the new SQL server. In doing so, the delete permissions were missing on the table being used in the job.

So when the job attempted to connect to sql server database and truncate the table before inserting rows, the generated code was Delete from <owner>.<tablename> and due to the permissions missing, datastage would throw the error code 134. The job executed successfully after the DBA granted the delete permission.

Regards,
Denzil

ray.wurlod · Post by **ray.wurlod** » Mon Jul 25, 2016 9:14 pm

Thank you for that useful contribution.

Hopefully future searchers will happen upon this post.

DSXchange

Parallel job reports failure (code 134)

Parallel job reports failure (code 134)

Re: Parallel job reports failure (code 134)