Message Returned, but with error status

Recently, I've been upgrading several clients to Trend Micro's Worry Free Business Security. A couple of times the upgrade was successful, but after a couple of days, the console would become unresponsive and eventually return "Message returned, but with error status." The console would then display some default gibberish on the status screen.

Restarting the Trend Micro Security Server Master Service would usually fix this temporarily. After trying the steps in several Trend Micro kb articles (EN-1037390 most notably) without success, I resorted to calling Trend Micro support.

The bottom line - a corrupt HTTPDB database. Here are the steps that I performed to fix the issue with Trend Support. Keep in mind, these steps worked for me and you will lose some settings (URL Filtering settings as well as the group settings seem to be the biggest casualty). So I suggest getting some screen captures of the settings you'd like to keep before trying this.

1. Close the WFBS Console if you have it open.
2. Stop the Trend Micro Security Server Master Service. In my case, the service would eventually just crash after attempting to stop for a long time.
3. Open Task Manager, kill the DBServer.exe process.
4. Open Windows Explorer and navigate to your \PCCSRV folder.
5. Look for the HTTPDB folder. Rename to HTTPDB_Backup.
6. Open the TEMP Folder. Delete the contents.
7. Restart the Trend Micro Security Server Master Service.
8. Wait a minute, then re-open the WFBS Console.

You should now be able to login. Recreate your settings and everything should work fine. Note that it will take a while for the clients to check back in and show up in the console.