Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Web Help Desk is down with an email data object error

Web Help Desk is down with an email data object error

Updated December 28, 2017

Overview

This article describes how to resolve the issue where WHD is down and TRUNCATE EMAIL_DATA_OBJECT gives the following error message:

 The transaction log for database 'WHD' is full due to 'LOG_BACKUP'

Environment

  • WHD 12.2.3
  • Windows Server 2012

Cause

This issue occurs when the EMAIL_DATA_OBJECT size increases exponentially. This object stores reference data, such as rejected email. 

Resolution

Address the database issue

  1. Change Database Recovery model from Full to Simple.
  2. Shrink log files using SQL Studio.
    1. Right click WHD Database and select Tasks > Shrink > Files.
    2. Select the Log in File Type field.
    3. Click OK.
  3. Truncate EMAIL_DATA_OBJECT.

Control the growth of EMAIL_DATA_OBJECT

  1. Log in to the WHD Console as an Administrator.
  2. Go to Setup > E-Mail > Options.
  3. Under E-Mail Options, set the Delete E-Mail History Entries After setting to a shorter time period.
    delete-email-history.png 
  4. Click Save.

 

 

Last modified

Tags

Classifications

Public