Procedure to remove long pending tasks from the Recent Tasks list in Veritas InfoScale Operations Manager.

book

Article ID: 100033543

calendar_today

Updated On:

Description

Error Message

There are no error messages reported.

The tasks simply remain in the In Progress status indefinitely.

Cause

This issue can occur due to one or more of the following:
  • Software incompatibility between VIOM and the array vendor software (CLI/API). 
  • Storage issue
  • Network/SAN issue

Note: VIOM documentation can be found at https://sort.veritas.com/documents

Resolution

Remove the hung tasks using the steps below:

 

For VIOM Management Server on Unix

1) Run the command below to find out the password for the database user habdbsync:

# /opt/VRTSsfmh/bin/xdbadm -g -u habdbsync -c /var/opt/VRTSsfmcs/conf


2) Run the command below to find the IDs of the pending tasks (in the RUNNING state).

#/opt/VRTSsfmcs/pgsql/bin/psql "dbname=SFMdb3 host=localhost user=habdbsync password= port=5636" -c "select ID,name,display_name from habdbsync.p_sf_task where STATE='RUNNING';"

This command output shows the ID, name and display_name of tasks in the RUNNING state.

3) Remove the pending tasks.

# /opt/VRTSsfmcs/pgsql/bin/psql "dbname=SFMdb3 host=localhost user=habdbsync password= port=5636" -c  ”delete from habdbsync.p_sf_task where ID='';”


Note: The output from Step #2 shows the IDs of all tasks in the RUNNING state, including normal running tasks. Ensure, no running tasks are deleted. .
 

 

For VIOM Management Server on Windows

a) Create a file named cleartask.sql on the Management Server (MS) with the following syntax:

delete from habdbsync.p_sf_task where STATE='RUNNING';

b) Run the command below to remove the hanging tasks

"C:\Program Files\Veritas\VRTSsfmh\bin\xdbadm.exe" -f c:\temp\cleartask.sql -o c:\ProgramData\Symantec\VRTSsfmcs\.odbc.ini -c "c:\ProgramData\Symantec\VRTSsfmcs\conf" -d SFMdb3 –v


Note: The same procedure can also be implemented on the VIOM MS for Unix

/opt/VRTSsfmh/bin/xdbadm.exe -f /var/temp/cleartask.sql -o /var/opt/VRTSsfmcs/odbc.ini -c /var/opt/VRTSsfmcs/conf -d SFMdb3 -v

where the file cleartask.sql is located in the /var/temp path, then run the same command below:

delete from habdbsync.p_sf_task where STATE='RUNNING';

Issue/Introduction

For Veritas InfoScale Operations Manager (VIOM), certain tasks such as adding new storage may get stuck in In Progress state when seen from the Recent Tasks list. These tasks would continue to remain in this state indefinitely, without moving to Completed state.

Error Message

There are no error messages reported. The tasks simply remain in the In Progress status indefinitely.
Powered by Wolken Software