numeric overflow error

kavuri · Post by **kavuri** » Wed Dec 16, 2009 7:55 am

Hi,
I am trying to read data from a oracle DB. I am using dataDirect for ODBC. All my other jobs are running fine except one job.

I am getting the following error sometimes.

[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01426: numeric overflow [odbcUtils.C:302]

Sometimes the job runs fine but takes a long time to read about 1.2 million records. What I see is data apto about 900,000 records are fetched very quicky. After that the process slows down ( It is taking about 1 hr 40 mins.). I expect normal time of about 1 to 2min.

I tried to extract the same data using SQL developer, I am able to fetch all data in 3 mins.

One more thing is I dont have any numeric fields in my job or table.

Let me know if I can provide any other details to dig into this issue.

Thanks
Kavuri

srinivas.g · Post by **srinivas.g** » Wed Dec 16, 2009 8:25 am

Use Oracle EE stage.

This is releated oracle error.please search "ORA-01426".

chulett · Post by **chulett** » Wed Dec 16, 2009 8:30 am

What are you selecting? This issue could also be in your 'where' clause.

ORA-01426: You tried to evaluate an expression that resulted in a numeric overflow (or underflow).

kavuri · Post by **kavuri** » Wed Dec 16, 2009 9:29 am

Hi Srinivas,
I dont have an option to use Oracle EE stage. We need to buy oracle native drivers. So this is not an option for me. Thanks for your response.

Hi Chulett,
I am selecting the char and varchar fields, there is no where clause.

I think my source system is maintaining some numeric data or date field in varchar field etc. I will dig down more on this.

Please let me know if someone comes across this kind of situation.

Thanks
Kavuri

ray.wurlod · Post by **ray.wurlod** » Wed Dec 16, 2009 2:07 pm

If you have Oracle, your organization already has the requisite Oracle client software. Get your DBA to install it on the DataStage server (and any other machines executing nodes).

chulett · Post by **chulett** » Wed Dec 16, 2009 2:29 pm

kavuri wrote:I dont have an option to use Oracle EE stage. We need to buy oracle native drivers. So this is not an option for me.

Wow, I completely missed that statement. As noted, not true, you have what you need.

kavuri · Post by **kavuri** » Wed Dec 16, 2009 3:49 pm

Hi Ray,
We dont have oracle. Oracle is maintained by a third party. We just pull the data from their DB.

Any solution is greatly appreciated.

Thanks
Bhargava