Summary
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)
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
SEVERE: lookForJobs() failed:
java.sql.SQLException: The conversion of the data types char to datetime produced a value datetime out of interval
Details
To resolve this issue, make sure that the SQL account used by Deep Security is configured to English.
For example, the Spanish SQL should be configured by doing the following:
- Open the SQL Management Studio.
- Go to Seguridad (Security) > Inicios de session (Session startup).
- Right-click the SQL account used by Deep Security to log in, and then click Propiedades (Properties).
- In the General tab, set Idioma predeterminado (Default Language) to English.
- Click OK.
- Restart the Trend Micro Deep Security Manager service.
For other languages,please adjust accordingly.
