Lookup : Could not open table /lookuptable.20140715.s2rnh4d

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
Rajesh Jale
Premium Member
Premium Member
Posts: 6
Joined: Fri Mar 14, 2014 2:29 am

Lookup : Could not open table /lookuptable.20140715.s2rnh4d

Post by Rajesh Jale »

Hi,

One of our job is getting failed in Development databse at Lookup stage with the following error.

LookupStage,1: Could not open table file "/prosess/InformationServer/Test/Data/lookuptable.20140715.s2rnh4d" for reading: No such file or directory

It has never created this problem before. Also this job is executing well in Test Server.

Can anyone help me how to solve this issue.

Regards,
Rajesh
Regards,
Rajesh
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Does the path exist?
Does the user id who is executing the job have read/write permissions to that path?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I wonder if it is related to the resolution I get to here. Granted, mine said "map" and yours says "open" but still... any chance there is a disparity in bit-ness of the two servers? Or the volume processed is higher in Dev than Test?

I'm assuming from your statement this does work, just not always.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply