Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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

Tags

Classifications

Public