DSXchange

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.

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.

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

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.

HI ,

I am extracting the data from different tables,i am not loading data into table.

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?

HI,

1)ORACLE
2)YES ITS DIRECTLY CONNETS TO TRANSFORMER
3)DOING LOOKUP IN THAT TRNSFORMER

HI,

1)ORACLE
2)YES ITS DIRECTLY CONNETS TO TRANSFORMER
3)DOING LOOKUP IN THAT TRNSFORMER

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

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.

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

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

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