Stuck Job hanging in monitoring view

Last Updated: Oct 12, 2017 08:40PM 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\tools

For example with the default install directory

cd C:\Program Files\novastor\DataCenter\db-derby\bin\tools
 
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