Phantom

chou · Post by **chou** » Thu Jun 23, 2005 7:54 am

Hi All,

Can any one through some suggestions on the following Err

DataStage Job 785 Phantom 27904
Program "JOB.891742608.DT.1368838389.TRANS1": Line 1173, Improper data type.

I have checked each and every data type,every thing is perfect. The job was running fine y'day, after changing the DSN when I ran the job it was aborted with the Phantom err.

Thanks,

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 23, 2005 8:03 am

Check the stage variables and their default values.

The error can be located in the given line number on the BP dir TRANS file.

roy · Post by **roy** » Thu Jun 23, 2005 9:41 am

Hi,
I posted a while back how to get to the info you need.
Do search for it.

IHTH,

newtier · Post by **newtier** » Thu Jun 23, 2005 12:01 pm

I would suspect that when you changed the DSN, the underlying database table is defined differently than the one that ran successfully. Scrutinize the actual table definitions (and get the current definitions from the database itself, not from the DDL you "think" was used to create them).

ray.wurlod · Post by **ray.wurlod** » Thu Jun 23, 2005 5:55 pm

Within the Transformer stage are you invoking any routines that perform I/O? This message often indicates incorrect usage of a file I/O statement, in particular the file variable.