Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
This article addresses the following issue that occurs when attempting to clear selected Syslog Messages from the Syslog view in the Orion console:
The error generated displays the following:
Message: Value was either too large or too small for an Int32.
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.Convert.ToInt32(String value)
at SysLogsReportControl.ClearMessages_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
NPM 11.5.3 and earlier
The occurs because the messageID column in the Syslog table is extremely large in count. When the Web Console attempts to convert that number, it fails because it is incapable of handling such a larger number. Examples of this would be if the messageID was in the high billions or trillions.
There are 2 methods to resolve this: Upgrade to NPM v12 when it comes out or reseed the Syslog table. To reseed the syslog table, perform the following:
Those queries will restart the identity of that table at 1 rather than continuing at the number it is currently at. It is possible to reseed the table at 1 without truncating the table, but the range of IDs already in the database should be taken into consideration and whether the new data will reach that point before the historical data is cleared through retention.