The following SQL exception occurs in the Node Management view of the web console:
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
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.
All Orion Core products
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/YYYYformat. 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.
sacredentials, log in to the SQL Server instance hosting your Orion database.