Some of our server jobs which have the following flow
odbc_stage(select from t1) -->transformer--> seq file --> odbc stage (update t1) fails sometimes with the following error message
DSD.BCIGetNext call to SQLFetch failed. followed by the select query.
When the job is executed say about 3 or 4 times it does run fine. Is this a database issue?
Since our jobs are scheduled if they fail once,they have to be run manually.
Select query fails sometimes
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have posted in a forum called DSXchange Testimonials, which is not the appropriate forum for a question about server jobs. Please post in the correct forum, where your question is more likely to be answered.
You might also like to search the forum before posting, as this question may have been asked and answered previously.
You might also like to search the forum before posting, as this question may have been asked and answered previously.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
BCIGetNext() is the function called to return the next row from a SELECT query made through the ODBC or UV stage type. For some reason this has failed - perhaps the connection to the database server was lost.
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.
Re: Select query fails sometimes
karthika wrote:Some of our server jobs which have the following flow
odbc_stage(select from t1) -->transformer--> seq file --> odbc stage (update t1) fails sometimes with the following error message
DSD.BCIGetNext call to SQLFetch failed. followed by the select query.
When the job is executed say about 3 or 4 times it does run fine. Is this a database issue?
Since our jobs are scheduled if they fail once,they have to be run manually.
kathika, we had this same problem.
Sometimes the jobs run ok and sometimes the job runs with warning.
We have solved problem instaling the ODBC Driver below.
DataStage ODBC Drivers Version 5.2
August 2006
Cassiano Fontoura