a non-numeric character was found where a numeric was expect

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
satyame171
Participant
Posts: 13
Joined: Tue May 09, 2006 2:19 am

a non-numeric character was found where a numeric was expect

Post by satyame171 »

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.
satheesh
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Re: a non-numeric character was found where a numeric was ex

Post by narasimha »

satyame171 wrote: "a non-numeric character was found where a numeric was expected" .
The solution is in your error message. You might be trying to insert a non-numeric character where a numeric character 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.
muruganr117
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

Post by muruganr117 »

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.
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"
They were zero & Caps "O", job aborted because of that.

regards
shamshad
Premium Member
Premium Member
Posts: 147
Joined: Wed Aug 25, 2004 1:39 pm
Location: Detroit,MI

Post by shamshad »

Try to debug the column that is giving issue like before inserting check whether the value is numeric or not and accordingly dump the rows that fails validation. We will be able to filter out which values are creating trouble.
satyame171
Participant
Posts: 13
Joined: Tue May 09, 2006 2:19 am

Post by satyame171 »

HI ,

I am extracting the data from different tables,i am not loading data into table.
satheesh
shamshad
Premium Member
Premium Member
Posts: 147
Joined: Wed Aug 25, 2004 1:39 pm
Location: Detroit,MI

Post by shamshad »

Is is possible to READ the data as CHAR?

(1) What is the database?
(2) Does the Database Stage directly connects to a transformer?
(3) Are there any transformation in transformer for that column?
satyame171
Participant
Posts: 13
Joined: Tue May 09, 2006 2:19 am

Post by satyame171 »

HI,

1)ORACLE
2)YES ITS DIRECTLY CONNETS TO TRANSFORMER
3)DOING LOOKUP IN THAT TRNSFORMER
satheesh
satyame171
Participant
Posts: 13
Joined: Tue May 09, 2006 2:19 am

Post by satyame171 »

HI,

1)ORACLE
2)YES ITS DIRECTLY CONNETS TO TRANSFORMER
3)DOING LOOKUP IN THAT TRNSFORMER
satheesh
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Post the complete error message, it should state a TRANS file and line number where the phantom error is occurring.
-craig

"You can never have too many knives" -- Logan Nine Fingers
satyame171
Participant
Posts: 13
Joined: Tue May 09, 2006 2:19 am

Post by satyame171 »

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.
satheesh
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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
-craig

"You can never have too many knives" -- Logan Nine Fingers
muruganr117
Participant
Posts: 40
Joined: Sun Jan 21, 2007 1:52 pm
Location: Chennai
Contact:

Post by muruganr117 »

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.
Hi Satya,

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
muruganr117
Participant
Posts: 40
Joined: Sun Jan 21, 2007 1:52 pm
Location: Chennai
Contact:

Post by muruganr117 »

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.
Hi Satya,

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
Post Reply