Page 1 of 1
Select query fails sometimes
Posted: Wed Aug 01, 2007 12:34 pm
by karthika
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.
Posted: Wed Aug 01, 2007 2:31 pm
by ray.wurlod
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.
Posted: Mon Sep 24, 2007 5:00 pm
by asorrell
Moved to Server Forum
Posted: Mon Sep 24, 2007 7:00 pm
by ray.wurlod
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.
Re: Select query fails sometimes
Posted: Wed Jan 09, 2008 11:38 am
by cassi_bsb
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