Running but Not Running
Posted: Tue Dec 18, 2007 12:30 am
Hi All,
I have a Job which Inserts around 5 Million records in a table. This job have been executed fine several times and takes around 1 Hour but suddenly during our last execution this job was executing for almost 3 Days but still didnt finished. Finally we stoped this job and re-run it after which it was executed successfully within an hour.
When the job executed for 3 Days we had checked the details and found that the row transfer was stuck at around 2 million rows after which no rows went in the target table but still the job was showing status as running. Also no error was thrown in the DS Director logs so we are not able to find the exact reason why it went in infinite execution mode.
Can any one list down the possible reasons why such thing happened so that we can analyze in that direction?
Thanks in Advance.
I have a Job which Inserts around 5 Million records in a table. This job have been executed fine several times and takes around 1 Hour but suddenly during our last execution this job was executing for almost 3 Days but still didnt finished. Finally we stoped this job and re-run it after which it was executed successfully within an hour.
When the job executed for 3 Days we had checked the details and found that the row transfer was stuck at around 2 million rows after which no rows went in the target table but still the job was showing status as running. Also no error was thrown in the DS Director logs so we are not able to find the exact reason why it went in infinite execution mode.
Can any one list down the possible reasons why such thing happened so that we can analyze in that direction?
Thanks in Advance.