Hi All
Everytime I runa Job foloowing error pops up just before the jobs finishes satying....
DataStage Job 112 Phantom 27637
Program "JOB.869489309.DT.1363449358.TRANS7": Line 228, Variable previously undefined. Zero length string used.
DataStage Phantom Finished
It does not have a transformer TRANS7 in the JOB design. Any clue about the source of this error.
Phantom 27637 Error
Moderators: chulett, rschirm, roy
Rubu,
you might not see a TRANS7 when you look at the job, but DS thinks it is there... Have you tried recompiling your job to ensure that your Designer view and the object code are the same? The undefined error will be in a TRANsform stage - how many transforms do you have in the job?
If you wish to delve into the gory details:
If you do a "LIST DS_JOBS WITH @ID EQ <yourjobname>" from the DS command line or execute command in the Administrator and get the job number, then from UNIX go to your project directory and do a "cd RT_BP<jobnumber>". The separate programs generated are in that directory - there will most likely be a TRANS7 in there. Edit the source and go to the general vicinity of line 228 looking for an assignment statement. Most likely it will be to one of your stage variables or a derivation type statement.
you might not see a TRANS7 when you look at the job, but DS thinks it is there... Have you tried recompiling your job to ensure that your Designer view and the object code are the same? The undefined error will be in a TRANsform stage - how many transforms do you have in the job?
If you wish to delve into the gory details:
If you do a "LIST DS_JOBS WITH @ID EQ <yourjobname>" from the DS command line or execute command in the Administrator and get the job number, then from UNIX go to your project directory and do a "cd RT_BP<jobnumber>". The separate programs generated are in that directory - there will most likely be a TRANS7 in there. Edit the source and go to the general vicinity of line 228 looking for an assignment statement. Most likely it will be to one of your stage variables or a derivation type statement.
</a>Hi Rubu,
(1) Look in your Jobdesign, perhaps you use a routine, where a variable is not correctly defined.
(2) If not, you have to look in the sourcecode.
(a) Identify the jobnumber of your job
(b) go into the projectdirectory
(c) go into the BP_RT<jobno> subdirectory
(d) open there the file "JOB.869489309.DT.1363449358.TRANS7" around line 228
Wolfgang
(1) Look in your Jobdesign, perhaps you use a routine, where a variable is not correctly defined.
(2) If not, you have to look in the sourcecode.
(a) Identify the jobnumber of your job
(b) go into the projectdirectory
(c) go into the BP_RT<jobno> subdirectory
(d) open there the file "JOB.869489309.DT.1363449358.TRANS7" around line 228
Wolfgang