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:
- Stop the Supervising Engine service in the Argent SNMP Monitor.
- Open SQL Server Enterprise Manager and access Design View for the table ASR_SnmpTrapMonitor.
- Change the value for the column set_as_answered from BIT to INT and save your changes.
- Manually run ASR_DBCheck.exe from the drive where Argent is installed.
drive:\Argent\ArgentManagementConsole\ArgentSNMPMonitor
- Verify no errors occur.
- Restart the Supervising Engine service in the Argent SNMP Monitor.
See Also: Warning About Registry