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

Create a technical support case if you need further support.

Identifying the *.tmp files created under the \HTTPDB folder in the OfficeScan (OSCE) server

    • Updated:
    • 17 Oct 2016
    • Product/Version:
    • OfficeScan 10.6
    • OfficeScan 11.0
    • OfficeScan XG.All
    • Platform:
    • Windows 2003 Enterprise Server
    • Windows 2003 Standard Server Edition
    • Windows 2008 Enterprise Server
    • Windows 2008 Standard Server Edition
Summary

Many large temporary files (e.g., dbvxxx.tmp and dcbxxx.tmp) are found in the \HTTPDB folder of the OfficeScan server.

The *.tmp files are automatically created by OfficeScan as database backup when Dbserver.exe crashes. In that event, OfficeScan backs up the current database to *.tmp files and creates a new and empty database. This also resets the client count to zero.

Database corruption occurs due to either of the following:

  • Not enough disk space
  • Abnormal restart or shut down of the machine
  • A DBServer.exe crash
  • A third-party backup software is locking the database during the backup process, and thus not allowing OfficeScan to modify the database entry.
 
This article is not applicable for the server using SQL.
Details
Public

Currently, there is no available tool to fix a corrupted database.

To prevent database corruption, use DBBackup.exe tool to backup database regularly and automatically:

  • On OSCE 11.0/XG:
    1. Go to Administration > Settings > Database Backup.
    2. Tick "Enable Scheduled database backup".
    3. Click Save.
  • On OSCE 10.6:
    1. Go to Administration > Database Backup.
    2. Tick "Enable Scheduled database backup".
    3. Click Save.

That way, in the event that the database gets corrupted, you may replace it with the backup files.

The DBBackup.exe tool is available under the \Admin\Utility\Dbbackup folder on the OfficeScan server.

For additional information on how to prevent the OfficeScandatabase from getting corrupted, follow the steps in this KB article: Preventing the OfficeScan Corporate Edition (OSCE) database from getting corrupted.

For now, it would be safe to remove those *.tmp files under the \HTTPDB folder to save disk space.

Though the DBserver.exe would have crashed if this issue occured, there is no need to rebuild dbserver.exe (this is the application itself and the database is residing in the HTTPDB folder) since if the HTTPDB directory had been cleaned up of all the *.tmp files, restarting the OfficeScan Master Service via the Windows services applet would address this issue.

Do the following:

  1. Stop the OfficeScan Master Service via the Windows Services applet.
    1. Click Start > Run > services.msc.
    2. At the Services applet, scroll down until you locate the OfficeScan Master Service.
    3. Hit right click and click Stop.
  2. Launch Windows Explorer and go to C:\Program Files\Trend Micro\OfficeScan\PCCSRV\HTTPDB.
  3. Back up all the content of the HTTPDB directory and then delete all content.
  4. Exit from the Windows Explorer and restart the OfficeScan Master Service.

For client machines that are not visible in the management console, do the following:

  1. Restart the OfficeScan service.
  2. Logout then login on the workstation to prompt the OfficeScan client to reconnect back to the OfficeScan server.

This would enable the OfficeScan NT Listener Service in each of the workstation to re-register with the OfficeScan database and populate the OfficeScan management console.

Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
0121265
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.


Need More Help?

Create a technical support case if you need further support.