KBI 220737 DB Check Error During Upgrade

Version

Argent SNMP Monitor 8.0A-0707

Date

23 August 2007

Summary

During the upgrade of the Argent SNMP Monitor when the DB Check runs, you may receive a pop up message:

Structural Database Errors Have Been Detected. Contact Argent Support.

Upon acknowledging the pop up, you find the DB Check picked up a value conflict.

Technical Background

During the upgrade process, the SQL upgrade script may not update all columns.

As such, the ASR_SnmpTrapMonitor will show column set_as_answered is set to a BIT value when it should be an INT value.

Resolution

To resolve this issue, please take the following steps:

  1. Stop the Supervising Engine service in the Argent SNMP Monitor.
  2. Open SQL Server Enterprise Manager and access Design View for the table ASR_SnmpTrapMonitor.
  3. Change the value for the column set_as_answered from BIT to INT and save your changes.
  4. Manually run ASR_DBCheck.exe from the drive where Argent is installed.

    drive:\Argent\ArgentManagementConsole\ArgentSNMPMonitor

  5. Verify no errors occur.
  6. Restart the Supervising Engine service in the Argent SNMP Monitor.

See Also: Warning About Registry