DataStage Job 2288 Phantom 16902

[Prashantoncyber]

Hi All,

I ran a job and got the phantom error mentioning

DataStage Job 2288 Phantom 16902
Program "JOB.969034386.DT.1369240453.TRANS1": Line 71, Nonnumeric data when numeric required. Zero used.
.
.
.
.
. <repeating as many times as rows in the source table>

in order to resolve this i went in the &PH& folder under that particular
Project and ran below cmd to locate the log file

$find . -type f -exec grep -l "DataStage Job 2288";

this command is not executed telling

find: -exec not terminated with `;`

Pls guide what correction is required to locate the file under &PH&

thanks

[roy]

Hi,

Code: Select all

man find

would get you on your way to learn you also need { } there and perhaps some more cahracters.
Your best freind in this should be your sys admin on the unix end.

IHTH,

[elavenil]

Go to projects folder and look for RT_BPnnn folder. You will find this piece of code there. Look at the line number that was caused the problem.

HTWH.

Regards
Saravanan

[roy]

Hi,
Just wanted to point this was covered before several times and that some times the row number is not 100% acurate so look around 71 .

IHTH,

[chulett]

There's no need to 'find' the phantom, you've got what you need to know from the log already. However, your -exec syntax should look like this:

Code: Select all

-exec grep -l "DataStage Job 2288" {} \; 

The curly braces mark where each found filename should go in the command.

Also wanted to add to what elavenil posted. The 'nnn' is the Job Number of the job you are having a problem with, in this case (as noted in your message) it would be 2288. You'll find a file called "JOB.969034386.DT.1369240453.TRANS1" in that directory and around line 71 you may be able to spot the problem.