Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Network Configuration Manager (NCM) > NCM Config Summary: Unexpected Website Error

NCM Config Summary: Unexpected Website Error

Created by Karen Valdellon, last modified by MindTouch on Jun 23, 2016

Views: 45 Votes: 0 Revisions: 3

Overview

This article discusses troubleshooting steps to address the following error found on the Config Summary page as the Orion Web Console fails to load:

Unexpected Website Error

The following errors may also appear:

  • The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:10:00'
  • ERROR SolarWinds.InformationService.Serialization.XmlSerializer - Error serializing query results
  • System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding

The following may also be found in C:\Documents and Settings\All Users\Application Data\SolarWinds\InformationService:

System.Data.SqlClient.SqlException: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.

Environment

All NCM versions

Cause 

The errors could appear because of the following:

  • The default language for the ConfMgmt_adm user is not set to English. NCM encounters an error with a SQL Server whose default language is German. The error is a result of date-time formatting differences between SolarWinds Information Services and NCM.
  • The NCM database is having performance issues because of the size of its dataset.

Resolution

Unsupported language

SolarWinds supports using NCM with database servers setup in these languages: English, German, Japanese, and Chinese; but only supports storing characters in the UTF8 set.

Perform the following as a workaround:

  1. Open the SQL Server Management Studio.
  2. Connect the SQL Server that hosts the NCM database.
  3. Click Security > logins. Your NCM username should be listed. The default NCM database user is SolarWindsCM.
  4. Right-click your username and select Properties.
  5. Set the default language to English.
  6. Reload the NCM Summary page.

Dataset size

  1. Create a back up of the NCM database.
  2. Use NCM to export configs out to an archive.
  3. Open SQL Server Management Studio and log in to the database server.
  4. Select the NCM database objects in the left pane.
  5. Issue the following SQL statement:

    declare @mdate datetime

    set @mdate=’{put date here}’

    delete from ConfigArchive where DownloadTime < @mdate

    delete from CacheDiffResults where CacheID in

    (select CacheID from ComparisonCache where TimeStamp < @mdate)

    delete from ComparisonCache where TimeStamp < @mdate

Out-of-range value

  1. Open  and connect the SQL Server Management Studio to your SQL Server where NCM database is located. Your NCM username should be listed. The default NCM database user is SolarWindsCM.
  2. Click Security > connections or Security > logins.
  3. Set the default language to English.
    Note: In case the Config Summary in the Orion Web Console continues to show the error, restart SolarWinds Information Service (Administrative Tools > Services).

 

Last modified
21:24, 22 Jun 2016

Tags

Classifications

Public