Lookup: Fatal Error

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
bond88
Participant
Posts: 109
Joined: Mon Oct 15, 2012 10:05 am
Location: USA

Lookup: Fatal Error

Post by bond88 »

Hi,
I am getting following error

Lookup_3,0: Fatal Error: Unable to allocate communication resources

Can you please help me in resolving this issue?
I am getting 5-6 millions of records from source and after lookup I am using aggregator stage (aggregation on keys from lookup stage).

Thanks,
Bhanu
max.madsen
Premium Member
Premium Member
Posts: 62
Joined: Tue Dec 07, 2004 7:41 am
Location: Brasil
Contact:

Post by max.madsen »

Didnt exist any error before that message?
bond88
Participant
Posts: 109
Joined: Mon Oct 15, 2012 10:05 am
Location: USA

Post by bond88 »

Errors Order:

node_node1: Player 7 terminated unexpectedly.

Lookup_3,1: Failure during execution of operator logic.

Lookup_3,1: Fatal Error: Unable to allocate communication resources

node_node2: Player 4 terminated unexpectedly.

Lookup_3,0: Failure during execution of operator logic.
Bhanu
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

There are several possible reasons for this error, I've been fighting that problem at this site for a while.

How long between job startup and getting this error? Is it around 10 seconds? If yes, then 8.7 Fixpack 2 has a fix for this issue - see APAR JR43681
max.madsen
Premium Member
Premium Member
Posts: 62
Joined: Tue Dec 07, 2004 7:41 am
Location: Brasil
Contact:

Post by max.madsen »

No more? Any warning before?
bond88
Participant
Posts: 109
Joined: Mon Oct 15, 2012 10:05 am
Location: USA

Post by bond88 »

I got some warnings regarding Hash file. I thought these warnings/errors are occurring because of hash type in aggregator stage and changed it to sort type in aggregator stage then it ran successfully.
Bhanu
bond88
Participant
Posts: 109
Joined: Mon Oct 15, 2012 10:05 am
Location: USA

Post by bond88 »

ArndW wrote:There are several possible reasons for this error, I've been fighting that problem at this site for a while.

How long between job startup and getting this error? Is it around 10 seconds? If yes, then 8.7 Fixpack 2 has a fix for this issue - see APAR JR43681
I was getting this error after 15-20 sec's. But I used aggregator after lookup and I changed hash type to sort type in aggregator stage then it ran successfully.
Bhanu
Post Reply