a non-numeric character was found where a numeric was expect
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 13
- Joined: Tue May 09, 2006 2:19 am
a non-numeric character was found where a numeric was expect
hi,
i am getting the following error,"a non-numeric character was found where a numeric was expected" .
after 5 million data i am getting this error.
please help me ASAP.
i am getting the following error,"a non-numeric character was found where a numeric was expected" .
after 5 million data i am getting this error.
please help me ASAP.
satheesh
Re: a non-numeric character was found where a numeric was ex
The solution is in your error message. You might be trying to insert a non-numeric character where a numeric character was expected.satyame171 wrote: "a non-numeric character was found where a numeric was expected" .
Check for consistency in your source data, see if you need to do any conversions.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 40
- Joined: Sun Jan 21, 2007 1:52 pm
- Location: Chennai
- Contact:
Re: a non-numeric character was found where a numeric was ex
Yes as Narasimha said, check source data, am sharing similar exp in this regard, target column is Decimal and from source i got value as "0O"satyame171 wrote:hi,
i am getting the following error,"a non-numeric character was found where a numeric was expected" .
after 5 million data i am getting this error.
please help me ASAP.
They were zero & Caps "O", job aborted because of that.
regards
-
- Participant
- Posts: 13
- Joined: Tue May 09, 2006 2:19 am
-
- Participant
- Posts: 13
- Joined: Tue May 09, 2006 2:19 am
-
- Participant
- Posts: 13
- Joined: Tue May 09, 2006 2:19 am
-
- Participant
- Posts: 13
- Joined: Tue May 09, 2006 2:19 am
A search for that error message would turn up quite a number of hits, I'd wager. And most would lay out the steps needed to check what code is causing the problem. For example, this one from yesterday:
viewtopic.php?t=118656
viewtopic.php?t=118656
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 40
- Joined: Sun Jan 21, 2007 1:52 pm
- Location: Chennai
- Contact:
Hi Satya,satyame171 wrote:HI chulett,
I AM GETTING THE FOLLOWING ERROR.
DataStage Job 7887 Phantom 28820
Program "JOB.406432813.DT.1473864463.TRANS3": Line 238, Nonnumeric data when numeric required. Zero used.
Please crosscheck metadata of stage across TABLE metadata.
If both are in sync, then in that case what can be done is to debug the source data itself, but need to put in some effort to locate the record,
Job can be executed in stages as
SELECT .... FROM TABLE WHERE
ROWNUM < 100000
If it works fine, the next set till the error record is reached.
it is a dauting task though, record can be debugged.
regards
-
- Participant
- Posts: 40
- Joined: Sun Jan 21, 2007 1:52 pm
- Location: Chennai
- Contact:
Hi Satya,satyame171 wrote:HI chulett,
I AM GETTING THE FOLLOWING ERROR.
DataStage Job 7887 Phantom 28820
Program "JOB.406432813.DT.1473864463.TRANS3": Line 238, Nonnumeric data when numeric required. Zero used.
Please crosscheck metadata of stage across TABLE metadata.
If both are in sync, then in that case what can be done is to debug the source data itself, but need to put in some effort to locate the record,
Job can be executed in stages as
SELECT .... FROM TABLE WHERE
ROWNUM < 100000
If it works fine, the next set till the error record is reached.
it is a dauting task though, record can be debugged.
regards