PID Failed
Posted: Thu Mar 06, 2008 3:55 pm
Job shows PID Failed.
However was running very fine until a week before when we last ran it.
Tried all of the following, nothing works:
1. Cleared &PH& Directory
2. Unlock user on TCL. (This clears locks indeed but locks are created again on job run)
3.Deleted and redeployed job from version control
4. Ran ds.reindex
5 Ran DS.Checker
6. Stopped and Restarted DataStage Server.
Important to note is that the job runs perfect by itself but shows this error when called from a sequence.
Also shows this log message:
From previous run
DataStage Job 1085 Phantom 14706
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Help Appreciated.
However was running very fine until a week before when we last ran it.
Tried all of the following, nothing works:
1. Cleared &PH& Directory
2. Unlock user on TCL. (This clears locks indeed but locks are created again on job run)
3.Deleted and redeployed job from version control
4. Ran ds.reindex
5 Ran DS.Checker
6. Stopped and Restarted DataStage Server.
Important to note is that the job runs perfect by itself but shows this error when called from a sequence.
Also shows this log message:
From previous run
DataStage Job 1085 Phantom 14706
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2166, Variable previously undefined. Zero length string used.
Help Appreciated.