Unable to delete an "unknown" model in the Spectrum database

Products

• DX NetOps
• CA Spectrum

Issue/Introduction

We have an "unknown" model appear in the Results tab of a search and we are unable to delete the model. 

Environment

Release : Any
Component" SpectroSERVER database

Cause

Possible database corruption

Resolution

If you are running consistent SpectroSERVER backups, reload a previous database save.

However, it could be the backup still contains the corruption and the same "unknown" model is still seen.

If this occurs, do the following:

Run a Modeling Gateway export of the SpectroSERVER database:

- Log into the SpectroSERVER system as the user that owns the Spectrum installation

- If on Windows, start a bash shell by running "bash -login"

- cd to the $SPECROOT/SS-Tools directory and run the following command while the SpectroSERVER process is running where <VNM> is the hostname of this SpectroSERVER system and <FILENAME> is a filename to save the export to:

./modelinggateway -vnm <VNM> -e <FILENAME>

Reinitialize the SpectroSERVER database to the legacy catalog:

- Log into the SpectroSERVER system as the user that owns the Spectrum installation

- Shutdown the SpectroSERVER as normal

- If on Windows, start a bash shell by running "bash -login"

- cd to the $SPECROOT/SS directory and enter the following command:

../SS-Tools/SSdbload -ic legacy.SSdb

- Start the SpectroSERVER as normal

Run a Modeling Gateway import of the SpectroSERVER database:

- Log into the SpectroSERVER system as the user that owns the Spectrum installation

- If on Windows, start a bash shell by running "bash -login"

- cd to the $SPECROOT/SS-Tools directory and run the following command while the SpectroSERVER process is running where <VNM> is the hostname of this SpectroSERVER system and <FILENAME> is the filename of the exported file. This file will have an "xml" extension:

./modelinggateway -vnm <VNM> -i <FILENAME>

- Verify the the "unknown" model no longer exists

Additional Information

Please reference the "Modeling Gateway Toolkit" section of the documentation on more information.