Issues might occur when installing the Deep Security Manager (DSM) with non-English SQL server

You may encounter the following problems when installing the Deep Security Manager (DSM) with a non-English SQL server:

• Installation does not work properly.
• DSM seems to be working fine when entering, but when you go to System > System Information, the following error may appear:

  An irrecoverable error has occurred. The request may have been invalid or the system may be experiencing loss of database connectivity. Please use your back button and try again.

If you have tested the database connectivity to be functioning properly, check the logs from DSM serve0.log file and you might encounter something similar to the following error:

• Spanish

  com.thirdbrigade.manager.core.scheduler.jobschedulers.HeartbeatJobScheduler lookForJobsToSpool  SEVERE: lookForJobs() failed:  java.sql.SQLException: La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.  at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

• German

  com.thirdbrigade.manager.core.scheduler.jobschedulers.HeartbeatJobScheduler lookForJobsToSpool SEVERE:  ThID:17|TID:0|TNAME:Primary|UID:-1|UNAME:|lookForJobs() failed: java.sql.SQLException: Bei der Konvertierung eines  varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.

• English translation

  com.thirdbrigade.manager.core.scheduler.jobschedulers.HeartbeatJobScheduler lookForJobsToSpool  SEVERE: lookForJobs() failed:  java.sql.SQLException: The conversion of the data types char to datetime produced a value datetime out of interval