Dataset error: Parallel job reports failure (code 141)

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ashwin2912
Participant
Posts: 57
Joined: Wed Jan 26, 2005 10:22 pm
Location: India

Dataset error: Parallel job reports failure (code 141)

Post by ashwin2912 »

I am writing into a dataset and the job is aborting giving following error:
Info:
Contents of phantom output file =>
28191 Broken Pipe

Info:
Contents of phantom output file =>
DataStage Job 2490 Phantom 28192

Fatal:
Parallel job reports failure (code 141)

When I replace it with a sequential file it runs successfully. Any clue on what is happening?
Placing a dataset on any output link in the job gives the same result.
Ashwin
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Can you create another job with a DataSet output as a test to see if it is limited to your one job and one data contents? Does the job abort at or before row one or does it happen downstream? If you use a different APT_CONFIG file (with a different amount of nodes), does it work?
ashwin2912
Participant
Posts: 57
Joined: Wed Jan 26, 2005 10:22 pm
Location: India

Post by ashwin2912 »

I have deleted 7-8 stages and backtracked to the first stage and still the issue persisted. The job aborts immediately without processing any rows.

Then I wrote the dataset in sequential mode, and the job ran successfully!!
All other jobs in the same project are running fine with regard to this issue. I wonder what the problem is? :evil:
Ashwin
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Create a quickie job to write your generated sequential file into a dataset. Does that work?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Have you checked your multi-node configuration file?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Eric
Participant
Posts: 254
Joined: Mon Sep 29, 2003 4:35 am

Post by Eric »

Have you checked that there are no previous dataset files that have the same name (from previous attempts)?
ashwin2912
Participant
Posts: 57
Joined: Wed Jan 26, 2005 10:22 pm
Location: India

Post by ashwin2912 »

The problem disappeared mysteriously....But we realised the other day there was a change in the default configuration file used by multiple projects. Most probably this was the culprit.
Ashwin
Post Reply