Running but Not Running

[Amit_111]

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.

[us1aslam1us]

Most common reasons will be loosing the network during the load and the other might be someone else had tried to access the same table which can create lock on the table.

[jdmiceli]

Another reason could be that the system ran out of resources and is paging as things free up. Depending on the system, this can basically lock the processor, RAM and hard drive just doing the continuous swapping.

Merry Christmas!