"Error while updating item_model_mapping table" messages in Spectrum OneClick log

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps
• CA Spectrum

Issue/Introduction

We are seeing errors in the spectrum catalina.out:

(NetqosSyncLog) - (ERROR) - Error while updating item_model_mapping table for MH : 0x5754b42e, error-message : 0x5778b42e: No server found for landscape ID 0x57540000.

Environment

All Supported Releases

SPCINT - Integrations

Cause

These devices still exist in CAPC but have been deleted from spectrum global collection.

However, they are stuck in the netqos_integ database in spectrum.

Resolution

NOTE: Starting from DX NetOps Spectrum 21.2.4, the default root password for MySql is "MySqlR00t". For DX NetOps Spectrum versions prior to 21.2.4, the default root password is "root". In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.

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

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

- Shutdown tomcat

    - On Linux, cd to the $SPECROOT/tomcat/bin directory and run "./stopTomcat.sh"
    - On Windows run "net stop spectrumtomcat"

- cd to the $SPECROOT/mysql/bin directory and run the following command to log into mysql:

./mysql --defaults-file=../my-spectrum.cnf -uroot -p <PASSWD> netqos_integ -A

- Enter the following command at the mysql prompt:

truncate table netqos_integ.item_model_mapping;

- Enter "quit" at the mysql prompt to exit

- Start tomcat

    - On Linux, cd to the $SPECROOT/tomcat/bin directory and run "./startTomcat.sh"
    - On Windows run "net start spectrumtomcat"

This will trigger a global synch from CAPC to Spectrum and will put a noticeable memory load on the Spectrum OneClick server.