Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Mobile Admin > SQL error: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

SQL error: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

Created by Mark Augustus Funcion, last modified by Karen Valdellon on May 03, 2017

Views: 20,218 Votes: 1 Revisions: 7

Updated May 3, 2017

Overview

The following SQL exception is displayed in the Node Management view of the Orion Web Console:

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

or

System.Data.SqlClient.SqlException (0x80131904): The conversion of a nvarchar data type to a datetime data type has created a value out of range.

Note: Nvarchar stores UNICODE data and is the data type of choice for storing UNICODE or multilingual data. Varchar stores ASCII data and should be the data type of choice for normal use.

Environment

All Orion Platform products

Cause 

This error is due to the way different languages represent and parse dates in the SQL Server. If English is set as your default language, the SQL Server expects dates in MM/DD/YYYY format. Other languages may expect a DD/MM/YYYY format. The SQL Server will throw this error in the event of a mismatch between what is provided and what the SQL Server is expecting.

Resolution

  1. On your SQL Server, open SQL Server Management Studio. Click Start > All Programs > Microsoft SQL Server > SQL Server Management Studio.
  2. Using sa credentials, log in to the SQL Server instance hosting your Orion database.
  3. Expand Security > Logins.
  4. Right-click the SolarWinds Orion user, and then click Properties.
  5. In the Select a page pane, click General.
  6. In the Default language field, select English.
  7. Click OK.

 

Last modified

Tags

Classifications

Public