Summary

Trend Micro Management Infrastructure service is not starting and the logs indicate that the transaction log for the database is full.

The following can be seen in the TMCM_LogProcessor.log:

   
2023-10-02 08:11:38,916 248631028 [3] WARN - Unable to execute sp_BatchUpdateCasEntityData [0]
System.Data.SqlClient.SqlException (0x80131904): The transaction log for database 'db_ApexCentral_FORNER' is full due to 'LOG_BACKUP'.
en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
en System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
en System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
en System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption)
en System.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, String endMethod, Boolean isInternal)
en System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
en System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult asyncResult)
en TrendMicro.TMCM.JobEngine.DBExecutor.Invoke(String storedProcedure, IConnectionPool connPool, Int32 iCmdTimeout)
ClientConnectionId:f848c92a-eaf4-4db2-aa5f-9bf7ca7cfa86
Error Number:9002,State:2,Class:17
- It seems when service is starting, it failed because transaction log for database 'db_ApexCentral_FORNER' is full.