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) database size due to the large number of plug-in service (PLS) status logs sent by the OfficeScan server

    • Updated:
    • 6 Dec 2017
    • Product/Version:
    • Control Manager 6.0
    • 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, the TMCM database unexpectedly grows rapidly. The growth happens on the database MDF file.

 
Details
Public

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

  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.

  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.

Premium
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.