Search FAQs

ENM Diagnostic message: "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value"

Environment

PowerSCADA Expert 8.x, Power Monitoring Expert 8.x, Power Monitoring Expert 9

Product Line

ENM 8.3, ENM 8.3.1, ENM 8.3.2, ENM 8.3.4

Description of the issue:
ENM diagnostic is full of error message like the one below.

"HandlingInstanceID: 03b1616f-490f-4fce-97f0-39bc07e168ca An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught. ---------------------------------------------------------------------------------- 08/22/2019 17:59:19 Type : System.Data.SqlClient.SqlException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. Source : .Net SqlClient Data Provider Help link : Errors : System.Data.SqlClient.SqlErrorCollection ClientConnectionId : 8d687016-7a87-4897-8122-99523f9ac0c8 Class : 16 LineNumber : 1 Number : 242 Procedure : Server : DK-PME\ION State : 3 ErrorCode : -2146232060 Data : System.Collections.ListDictionaryInternal TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) HResult : -2146232060 Stack Trace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader "

Cause:

This issue may appear if the computer locale, date and time setting is other than English US. (Like if it is Italian, German, Finish etc)

Workaround:

* Create a new account on the machine that has Administrator rights with a password that never expires.
* Log on using this account and change the Regional Settings to English US and make sure the date and time setting is also set as English US.
* Change all ENM the services to use this new account instead of the default Local System account.

In the below screenshot the user account "support" is created to use regional setting as English US.

Once this account has been created, and the services set to use it, it is not necessary to log on to Windows with this account.