Views:

To resolve this issue, make sure that the language of the SQL account used by TMCM/Apex Central™ is English.

For example, the German SQL can be configured by doing the following:

Open the SQL Management Studio.
Go to Security > Logins.
Right-click the SQL account used by TMCM to log in, then click Properties.
In the General tab, set the Default Language to English.
Click OK.
Restart the TMCM Service and Trend Micro Management Infrastructure Service.

For other languages, the settings should be adjusted accordingly.

Keywords: SQL Server,non-english,cannot generate static report,automatic logout,operation center stuck,operation s=center does not load

Issues encountered when installing Control Manager (TMCM) / Apex Central™ with a non-English SQL server

Product / Version includes:

Apex Central2019 , Control Manager7.0

Last updated: 2021/08/28

Solution ID: KA-0008030

Category: Troubleshoot

Summary

You may encounter the following problems when installing TMCM/Apex Central™ with a non-English SQL server:

The Operation Center is continuously loading and unable to respond.
From UI_Debug.log, in the <CM Root>\Debuglog folder, the following error is displayed and the SQL Language is in German:

ERROR - __ExeDashboard__: ExeDashboardDatabaseUtility.QueryReportingLineMap: SQL Exception(no:8114) : System.Data.SqlClient.SqlException (0x80131904): Fehler beim Konvertieren des nvarchar-Datentyps in datetime.
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)
Unable to generate the static report.
From TMCM_CSharpReportViewer.log, in the <CM Root>\DebugLog folder, the following error is displayed and the SQL Language is in French:

FATAL - System.Data.SqlClient.SqlException (0x80131904): Erreur de conversion du type de données nvarchar en datetime.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1
wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean
callerHasConnectionLock, Boolean asyncClose)
When you open the User/Endpoint menu, you may be logged-out automatically.

To resolve this issue, make sure that the language of the SQL account used by TMCM/Apex Central™ is English.

For example, the German SQL can be configured by doing the following:

Open the SQL Management Studio.
Go to Security > Logins.
Right-click the SQL account used by TMCM to log in, then click Properties.
In the General tab, set the Default Language to English.
Click OK.
Restart the TMCM Service and Trend Micro Management Infrastructure Service.

For other languages, the settings should be adjusted accordingly.

Was this article helpful?