Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Network Performance Monitor (NPM) > Clearing syslog messages error: Unexpected Website Error. Value was either too large or too small for an Int32

Clearing syslog messages error: Unexpected Website Error. Value was either too large or too small for an Int32

Overview:

The following error appears when trying to clear the syslog messages thru the Website:

Unexpected Website Error. Value was either too large or too small for an Int32.

Environment

All NPM versions

Resolution:

Truncate syslog messages via Database Manager.

Execute the following query using the Database Manager:

UPDATE [dbo].[WebUserSettings]
SET SettingValue = '250'
WHERE SettingName = 'Web-OrionMessagesMaxMsgPerPage'

 

Truncate syslog messages:

You can remove all the historical Syslog messages from your database using a TRUNCATE query.

  1. Stop all Orion services using the Orion Service Manager.
  2. Open the Database Manager and connect to your Orion database.
  3. Right click on any table and select 'Query Table...'
  4. Set the radio button to Read/Write and clear out the default query.
  5. Enter the following query and click Refresh:
    *****************************************************************************
    TRUNCATE TABLE Syslog
    *****************************************************************************
    UPDATE [dbo].[WebUserSettings]
    SET SettingValue = '250'
    WHERE SettingName = 'Web-OrionMessagesMaxMsgPerPage'
    *****************************************************************************
    
     
  6. Restart the Orion services using the Orion Service Manager.

Notes:

  • Consult your database administrator before performing any of the following steps. 
  • Create a backup of the database in your local drive, in case you need to roll back later.

 

Last modified
19:41, 1 Mar 2017

Tags

Classifications

Public