DSXchange

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

Use Oracle EE stage.

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

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).

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

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).

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.

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