Phantom 14763 Variable previously undefined. Zero length s

ketfos · Post by **ketfos** » Wed Dec 07, 2011 10:16 am

Hi,
I have job running fine in one enviornment.

While I run the job in another enviornment with teh same data set, I am getting a message in the log with following entries.

Phantom 14763

Variable previously undefined. Zero length string
Line 33, Variable previously undefined. Zero length string used.
Line 46, Variable previously undefined. Zero length string used.
Line 57, Variable previously undefined. Zero length string used.
Line 68, Variable previously undefined. Zero length string used.

Any help is appreciated.
Thanks
ketfos.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 07, 2011 2:50 pm

Can you please identify which stage (and its type, which I'm guessing is Transformer) is throwing this error, and what that stage is doing?

ketfos · Post by **ketfos** » Wed Dec 07, 2011 3:46 pm

The message is coming at the end of the job in the following order

TransInNote: DSD.StageRun Active stage finishing.

DataStage Job 468 Phantom 29860

Program "DSU.TranslatePicCodeOther": Line 13, Variable previously undefined. Zero length string used.

The transform DSU.TranslatePicCodeOther is being used in the first stage of the job which is selecting from table.

Finished Job PolicyNoteOther

adams06 · Post by **adams06** » Wed Dec 07, 2011 4:06 pm

Whats the job design?

ketfos · Post by **ketfos** » Wed Dec 07, 2011 4:19 pm

OCI Stage (Selects) -- Transformer (uses the trasnform routine) -- puts into another transformer --- does a look up against the hash file with code returned by transform -- inserts/updates into an table --

The warning messages appear at the end of the job.
None of the above stage ahs any warning message

ray.wurlod · Post by **ray.wurlod** » Wed Dec 07, 2011 4:36 pm

The problem is in your routine TranslatePicCodeOther. The code in the routine is attempting to use the value of a variable before that variable has been assigned a value.

adams06 · Post by **adams06** » Wed Dec 07, 2011 4:44 pm

Post the routine

ray.wurlod · Post by **ray.wurlod** » Wed Dec 07, 2011 4:46 pm

The code may be subject to non-disclosure. In that case post a suitably anonymous variant of the code.

ketfos · Post by **ketfos** » Thu Dec 08, 2011 1:45 pm

Hi Ray,

This is what I did to resolve the problem.

I deleted the job in the current enviornment.
Imported the job from QA enviornment and exported the dsx files to the current project.
Ran the job again and did not find any warning messages.

Any idea why it resolved the problem.

The existing code which gae the error message was earlier promoted from the Qa enviornment only.

chulett · Post by **chulett** » Fri Dec 09, 2011 7:20 am

No way to know without seeing the actual code. Perhaps someone 'fixed' it in the other environment...