"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 NetOps Portal but have been deleted from spectrum global collection.

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

Resolution

- 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 NetOps Portal to Spectrum and will put a noticeable memory load on the Spectrum OneClick server.