Stuck Job hanging in monitoring view

Last Updated: Sep 02, 2014 09:06AM CEST

Impact Assessment
 
This will not allow this job to be reported.  The job will still run on regular scheduled intervals regardless if there is an actively hung job in the Monitoring view.
 
Overview
 
Occasionally there will be times when a job will get stuck in the actice Monitoring screen and is unable to be cleared through cancelling the job.
  
Steps to Resolution

Before starting, make sure there are no active jobs set to run during this maintenance.
 
Make sure the NovaBACKUP Datacenter GUI is closed.
 
Open a command box and change directory to
 
DC_HOME\db-derby\bin\derby_bin

For example with the default install directory

cd C:\Program Files\novastor\DataCenter\db-derby\bin\derby_bin
 
Then set the 2 environment variables DERBY_HOME and JAVA_HOME with the following commands:

set DERBY_HOME=C:\Program Files\novastor\DataCenter\db-derby
set JAVA_HOME=C:\Program Files\novastor\DataCenter\jre
 
Now you can start the Derby access tool ij:
Type ij.bat at the prompt
At the ij> prompt, type the connection string

connect 'jdbc:derby://localhost:1527/dc5;user=dc5;password=dc5';
 
At this point we are going to empty the “ACTIVE_JOB” table by executing the following sql query
                DELETE FROM ACTIVE_JOB;
 
Open the Datacenter GUI, and you will now see the hung job is no longer in the Monitoring view.
http://assets0.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete