Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

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

    • Updated:
    • 11 Sep 2015
    • Product/Version:
    • Deep Security 8.0
    • Deep Security 9.0
    • Deep Security 9.5
    • Deep Security 9.6
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2008 Enterprise
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)
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
Details
Public
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:
  1. Open the SQL Management Studio.
  2. Go to Seguridad (Security) > Inicios de session (Session startup).
  3. Right-click the SQL account used by Deep Security to log in, and then click Propiedades (Properties).
  4. In the General tab, set Idioma predeterminado (Default Language) to English.
  5. Click OK.
  6. Restart the Trend Micro Deep Security Manager service.
For other languages,please adjust accordingly.
Premium
Internal
Rating:
Category:
Configure; Install
Solution Id:
1058616
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.