Page 1 of 1
Job not running
Posted: Thu Aug 12, 2010 2:16 am
by arnie_nits
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.
Posted: Thu Aug 12, 2010 2:56 am
by ETLJOB
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.
Posted: Thu Aug 12, 2010 2:58 am
by arnie_nits
it is an extract job....extracts from a table.. contains few lookups and a sort stage...and loads into a sequential file....
Posted: Thu Aug 12, 2010 3:03 am
by Sainath.Srinivasan
Try stopping the job followed by reset and rerun - assuming you have waited quite long to loose your patience.
Posted: Thu Aug 12, 2010 5:18 am
by arnie_nits
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!!....
Posted: Thu Aug 12, 2010 5:54 am
by ray.wurlod
Could be contention of some kind in the source database.