Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

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

NCM Config Summary: Unexpected Website Error

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

Views: 2,080 Votes: 0 Revisions: 3


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.


All NCM versions


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.


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