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
numeric overflow error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.