1993

Prev Next

Issue:
SDConnex is full with entries like
When converting an nvarchar datatype to a datetime datatype, the value is out of valid range.

This only happens on systems with a different datetime system other than US.
Almost all systems in Europe are affected.
The timeformat is usually DD.MM.YYYY rather than MM/DD/YYYY or anything alike.


Error Message
This is an example from a German system:
Generic error while processing request for Device: IpAddress = 'XX.XX.XX.XX' Name = 'Computername' Index = 4013 UID = '95251e2b92e50d73d5c67544ab581202' Version = '9.0.000.1047'; User: Name = 'Unknown'; Operation code = 45
System.Data.SqlClient.SqlException: Bei der Konvertierung eines nvarchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
Die Daten für den @AssetDisk -Tabellenwertparameter entsprechen nicht dem Tabellentyp des Parameters. SQL Server-Fehler: 242, Status: 3

Further information.
This issue had been there in earlier versions of SES and was fixed with 7.5. See Jira case SD-21795
It came back with some version with 8. something.
But it definitely has been seen with SES 9.0 SR 3+

Alexey asked to open a Jira for every single case. See SD-45178