Parallel job reports failure (code 134)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Mon Jan 31, 2011 7:19 am
Parallel job reports failure (code 134)
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
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
anilkumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 12
- Joined: Mon Jan 31, 2011 7:19 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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
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
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
Re: Parallel job reports failure (code 134)
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: