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

Create a technical support case if you need further support.

Rapid increase in Control Manager (TMCM) / Apex Central database size due to the large number of plug-in service (PLS) status logs sent by the OfficeScan server

    • Updated:
    • 19 Mar 2019
    • Product/Version:
    • Apex Central All.All
    • Control Manager 7.0
    • Platform:
    • Windows 2008 Server R2
    • Windows 2008 Standard
    • Windows 2008 Standard 64-bit
    • Windows 2012 Enterprise
    • Windows 2012 Standard R2
    • Windows 2016
Summary

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.

Details
Public

To resolve the issue, follow these steps based on your product version:

  1. Apply OfficeScan XG SP1 Critical Patch 4406.
  2. Stop the following Services:

    • Trend Micro Apex Central Service
    • Trend Micro Management Infrastructure Service
    • World Wide Web Publishing Service
  3. Open SQL Management Studio then connect to the Apex Central™ Database Server.
  4. Select the Apex Central™ Database. The default name is <db_ApexCentral>.
  5. 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.
  6. Start the following Services:

    • Trend Micro Management Infrastructure Services
    • Trend Micro Apex Central Service
    • World Wide Web Publishing Service
  7. Log on to the Apex Central™ console then go to Directories > Products.
  8. On the Product Tree, select the Officescan XG SP1.
  9. Click Task then click Synchronize OfficeScan Clients and Domains.

    All Status will be synchronized later.

  1. Apply OfficeScan XG SP1 Critical Patch 4406.
  2. Stop the following TMCM Services:

    • Trend Micro Control Manager Service
    • Trend Micro Management Infrastructure Service
    • World Wide Web Publishing Service
  3. Open SQL Management Studio then connect to the TMCM Database Server.
  4. Select the TMCM Database. The default name is <db_ControlManager>.
  5. 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.
  6. Start the following TMCM Services:

    • Trend Micro Management Infrastructure Services
    • Trend Micro Control Manager Service
    • World Wide Web Publishing Service
  7. Log on to the TMCM console then go to Directories > Products.
  8. On the Product Tree, select the Officescan XG SP1.
  9. Click Task then click Synchronize OfficeScan Clients and Domains.

    All Status will be synchronized later.

  1. Apply Officescan XG SP1 Critical Patch 4406.
  2. 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
  3. Open SQL Management Studio then connect to the TMCM Database Server.
  4. Select the TMCM Database. The default name is <db_ControlManager>.
  5. 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
  6. 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
  7. Log on to the TMCM console then go to Directories > Products.
  8. On the Product Tree, select Officescan XG SP1.
  9. Click Task then click Synchronize OfficeScan Clients and Domains.

    All Status will be synchronized later.

Premium
Test Now
Internal
Rating:
Category:
Troubleshoot; Deploy; Upgrade; Migrate; Register
Solution Id:
1118888
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.