In this article, we are going to discuss an SQL exception that displays in the Orion web console in the Node Management view. It will display the error “The conversion of a varchar data type to DateTime data type resulted in an out of range value.” This means the conversion of a navchar data type to a DateTime data type has created a value that is out of range.

You are watching: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Reason:

This error occurs due to the different languages that represent and parse dates in SQL Server. If the English is set as your default language, then the SQL server expects dates in MM/DD/YYYY format. Other languages may expect a DD/MM/YYYY format. SQL Server will generate this error when there is a mismatch between what is provided and what the SQL server is expecting.

Solution:

On your SQL database server, open the SQL Server Management studio.Click Start -> All programs -> Microsoft SQL Server -> SQL Server Management Studio.Using sa credentials login to mysql server instance hosting your Orion database.Expand security -> login.Right-click on SolarWinds Orion user and then click on properties.From the page pane click general.In the default language field select English.Click Ok.

See more: Anyone Use This On Divinity Original Sin 2 Definitive Edition Cheat Engine V3


comment

Please log in or register to add a comment.


More Posts


*
What type of value should not be represented by null in a relational database?Tegra Balonga - May 5
*
Error converting data type varchar to numeric SQLHafsa_Rao - Aug 7
*
Index was out of range. must be non-negative and less than the size of the collection.Tegra Balonga - May 4
How to select 10 rows in SQLsakshi - Jul 11
*
what is the difference between char and varchar?Being human - Jun 8
Write a query to display the smallest integer value not less than 1.23. give an alias as int_value.sakshi - 6 days
What command will return data from the database to you?amna - May 24
*
Set selected value of dropdown in Javascript.Lalit Kumar - Oct 8, 2020
*
How to solve : “cannot perform an aggregate function on an expression containing an aggregate or a subquery”Sabbir Hossain - Mar 30
How to get selected option value in PHPsakshi - Jun 24