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

Product / Version includes:

OfficeScanXG , OfficeScan11.0

Last updated: 2021/08/28

Solution ID: KA-0002160

Category: Troubleshoot

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 servers using SQL. When the OfficeScan server uses SQL as a database, there will be no HTTPDB folder; the existing one can be removed.

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:

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.
Launch Windows Explorer and go to C:\Program Files\Trend Micro\OfficeScan\PCCSRV\HTTPDB.
Back up all the content of the HTTPDB directory and then delete all content.
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:

Restart the OfficeScan service.
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.

Was this article helpful?

Featured

Automation Center

Education Portal

Online Help Center

Service Status

TrendConnect

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

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

Product / Version includes:

Summary