Job not running

arnie_nits · Post by **arnie_nits** » Thu Aug 12, 2010 2:16 am

Hi,

I have a job that was working OK until now. Now it just keeps on running and shows no rows being extracted. In director, it is stuck at this line:
DSD.BCIConnect call to SQLConnect returned informational message

What can be the reason....please suggest.

Regards,
Arnie.

ETLJOB · Post by **ETLJOB** » Thu Aug 12, 2010 2:56 am

A search on the key word "DSD.BCIConnect" returns lot of threads. Those posts suggest it could be a problem with the ODBC connection. I hope at least one of that posts hold good for you. BTW, You didn't explain your job design.

arnie_nits · Post by **arnie_nits** » Thu Aug 12, 2010 2:58 am

it is an extract job....extracts from a table.. contains few lookups and a sort stage...and loads into a sequential file....

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 12, 2010 3:03 am

Try stopping the job followed by reset and rerun - assuming you have waited quite long to loose your patience.

arnie_nits · Post by **arnie_nits** » Thu Aug 12, 2010 5:18 am

Well I broke the job in to parts.....from the db to a seq file and then from that file I was able to extract and perform the operations like lookups,sort etc.....was very strange....wonder what can be the reason!!....

ray.wurlod · Post by **ray.wurlod** » Thu Aug 12, 2010 5:54 am

Could be contention of some kind in the source database.