Products Affected

All ELM Products Using Microsoft SQL without SQLDMO, usually not installed by default with SQL 2008(R2).The ELM database maintenance job is failing with errors similar to the following:

ELM Maintenance Plan (ELM_PRIMARY) 0 (Job outcome) 2010-01-11 12:00:00 
Failed The job failed. 
The Job was invoked by Schedule 19 (Schedule 1). The last step to run 
was step 3 (Backup Database). 
ELM Maintenance Plan (ELM_PRIMARY) 1 Integrity Checks 2010-01-11 12:00:02 
Failed Executed as user: 
Localhost\Administrator. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). 
The step failed. 
ELM Maintenance Plan (ELM_PRIMARY) 2 Optimize Database 2010-01-11 12:00:02 
Failed Executed as user: 
Localhost\Administrator. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). 
The step failed. 
ELM Maintenance Plan (ELM_PRIMARY) 3 Backup Database 2010-01-11 12:00:02 
Failed Executed as user: 
Localhost\Administrator. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). 
The step failed.

Cause

By default, the ELM Server creates a maintenance job in the SQL Server instance hosting the ELM Primary database. This job depends on xp_sqlmaint to function, but without SQLDMO, xp_sqlmaint is unavailable.

Resolution

Option 1: Remove the ELM database maintenance job and manage the ELM primary database by other methods. To do this:

  1. Open properties of the ELM Server service.
    On a 64-bit OS, start the 32-bit version of services, i.e. Start->Run: services.msc /32
  2. Select the Database tab.
  3. Click the Database Wizard button.
  4. On the Primary Database dialog, uncheck the Install maintenance Microsoft SQL job checkbox.

KBA SQLDMO

5.Complete the Database Wizard and click the Finish button to finalize the change.

Option 2: Install SQLDMO as described in Method 2 of this Microsoft Knowledge Base article: http://support.microsoft.com/kb/955626.

Revision: 1.2

Last Modified:  12/3/2010

Last Reviewed:  12/3/2010

Article Type: Informational