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
DataStage Job 2288 Phantom 16902
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 108
- Joined: Wed Jul 28, 2004 7:15 am
Hi,
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,
Code: Select all
man find
Your best freind in this should be your sys admin on the unix end.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
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,
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,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
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:
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.
Code: Select all
-exec grep -l "DataStage Job 2288" {} \;
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers