Smarts NCM: Keep getting Java "Error: Could not find or load main class com.voyence.migration.StoredProcedureInvoker" while executing the database-utility commands.

Products

• VMware Smart Assurance

Issue/Introduction

Symptoms:


User will try and run archive jobs, but the job fails as shown below:

root@help1234 ~]# $VOYENCE_HOME/tools/db-utility/database-utility.pl archive jobs 15

Script started at Wed Dec 10 10:00:56 2017

Archving/Pruning 2568 Parent jobs older than 15 days...
Archving/Pruning 2 Child Jobs older than 15 days...

Invoking Java process to archive the jobs

***************************************
***Checking if this is a large data set.****
***************************************
Error: Could not find or load main class com.voyence.migration.StoredProcedureInvoker

ERROR: Java program com.voyence.migration.StoredProcedureInvoker failed while performing archive jobs

Script failed while executing java program (StoredProcedureInvoker). Please check dbutil_console.log and dbutil_java.log for any exceptions before re running the script.

Script exited at Wed Dec 10 10:01:00 2017

Users will also notice there is limited information in the dbutil_console and dbutil_java logs and will not explain the problem. 

Environment

VMware Smart Assurance - NCM

Cause

The database-utility.pl script is not able to find the proper classpath when executing complete path of $VOYENCE_HOME/tools/db-utility/database-utility.pl archive jobs 15.

Resolution

To resolve the issue:
1) Navigate to the path $VOYENCE_HOME/tools/db-utility:
cd $VOYENCE_HOME/tools/db-utility
2) Now execute the command as below:
./database-utility.pl archive jobs 15

When executing the command from any other directory with the complete path of $VOYENCE_HOME/tools/db-utility/database-utility.pl archive jobs 15, it is not able to find the proper classpath for the database-utility.pl script to run properly.