How to initialize or remove all Service Manager data from the Spectrum Report Manager database?
Initializing Service Manager Data may be required if the data is no longer valid or if the data has grown to use up all disk space. This could also be used as a method of repairing corruption. Note that all data will be removed by performing the solution.
There are two methods of initializing the data relating to Service Manager in the Reporting database:
Both of these methods require the Spectrum Tomcat Service to be shut down before starting. Next:
After the scripts run, it will start to initialize the database and output any errors encountered or let you know it was successful with a message similar to: "Successfully reinitialized Service Manager DB."