Select query fails sometimes

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

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

[asorrell]

Moved to Server Forum

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

[cassi_bsb]

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