If there is an OfficeScan XG SP1 server that is registered in TMCM/Apex Central, the TMCM/Apex Central database unexpectedly grows rapidly. The growth happens on the database MDF file.
To resolve the issue, follow these steps based on your product version:
- Apply OfficeScan XG SP1 Critical Patch 4406.
-
Stop the following Services:
- Trend Micro Apex Central Service
- Trend Micro Management Infrastructure Service
- World Wide Web Publishing Service
- Open SQL Management Studio then connect to the Apex Central™ Database Server.
- Select the Apex Central™ Database. The default name is <db_ApexCentral>.
-
Start a New Query, then execute the following script:
truncate table tb_statuslogjournalPLS
update tb_journalcheckpoint set bigwatermark=0 where name='tb_statuslogjournalPLS'
update tb_journalcheckpoint set watermark=0 where name='tb_statuslogjournalPLS'dbcc shrinkdatabase('db_ApexCentral')
Replace “db_ApexCentral” with your Apex Central™ database name. -
Start the following Services:
- Trend Micro Management Infrastructure Services
- Trend Micro Apex Central Service
- World Wide Web Publishing Service
- Log on to the Apex Central™ console then go to Directories > Products.
- On the Product Tree, select the Officescan XG SP1.
-
Click Task then click Synchronize OfficeScan Clients and Domains.
All Status will be synchronized later.
- Apply OfficeScan XG SP1 Critical Patch 4406.
-
Stop the following TMCM Services:
- Trend Micro Control Manager Service
- Trend Micro Management Infrastructure Service
- World Wide Web Publishing Service
- Open SQL Management Studio then connect to the TMCM Database Server.
- Select the TMCM Database. The default name is <db_ControlManager>.
-
Start a New Query then execute the following script:
truncate table tb_statuslogjournalPLS
update tb_journalcheckpoint set bigwatermark=0 where name='tb_statuslogjournalPLS'
update tb_journalcheckpoint set watermark=0 where name='tb_statuslogjournalPLS'dbcc shrinkdatabase('db_ControlManager')
Replace “db_ControlManager” with your TMCM database name. -
Start the following TMCM Services:
- Trend Micro Management Infrastructure Services
- Trend Micro Control Manager Service
- World Wide Web Publishing Service
- Log on to the TMCM console then go to Directories > Products.
- On the Product Tree, select the Officescan XG SP1.
-
Click Task then click Synchronize OfficeScan Clients and Domains.
All Status will be synchronized later.
- Apply Officescan XG SP1 Critical Patch 4406.
-
Stop the following TMCM Services:
- Trend Micro Control Manager Service
- Trend Micro Management Infrastructure Service
- Trend Micro Common CGI Service
- World Wide Web Publishing Service
- Open SQL Management Studio then connect to the TMCM Database Server.
- Select the TMCM Database. The default name is <db_ControlManager>.
-
Start a New Query then execute the following script:
truncate table tb_statuslogjournalPLS
update tb_journalcheckpoint set bigwatermark=0 where name='tb_statuslogjournalPLS'
update tb_journalcheckpoint set watermark=0 where name='tb_statuslogjournalPLS'dbcc shrinkdatabase('db_ControlManager')
Replace “db_ControlManager” with your TMCM database name - Start the following TMCM Services:
- Trend Micro Management Infrastructure Services
- Trend Micro Control Manager Service
- Trend Micro Common CGI Service
- World Wide Web Publishing Service
- Log on to the TMCM console then go to Directories > Products.
- On the Product Tree, select Officescan XG SP1.
-
Click Task then click Synchronize OfficeScan Clients and Domains.
All Status will be synchronized later.