Event ID 17055 Event Message "Invalid object name 'dbo.GroomLock'" When the Microsoft SQL Server Service Starts (826373)



The information in this article applies to:

  • Microsoft Operations Manager 2000

SYMPTOMS

You may receive the following event message in the Windows application event log on the computer that is running Microsoft SQL Server:Source: MSSQL
Category: (2)
Type: Information Event
ID: 17055
User: N/A
Description:
17052: Invalid object name 'dbo.GroomLock'

CAUSE

This problem occurs because the Microsoft SQL stored procedure MOMGroomCoordinationReset points to the GroomLock table in the OnePoint database, but it does not point to the OnePoint database to access the table. As a result, the stored procedure tries to access the GroomLock table in the Master database instead of the OnePoint database.

WORKAROUND

To work around this problem, manually change the stored procedure to point to the OnePoint database. To do this, follow these steps:
  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  2. Type:
    ALTER PROCEDURE MOMGroomCoordinationReset AS
        declare @ErrMsg varchar(255)
    
        UPDATE OnePoint.[dbo].[GroomLock] 
            SET [isGrooming]= 0,  [LastGroomStarted] = NULL 
    
        if @@error<>0 goto Err
        return 0
    
    Err:    
        SELECT @ErrMsg = @ErrMsg + ' --SQL Server error ' + convert( varchar(20), @@error ) + 'encountered in MOMGroomCoordinationReset'
        RAISERROR (@ErrMsg, 16, 1)
        return 1
  3. On the Query menu, click Execute.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Modification Type:MinorLast Reviewed:6/13/2005
Keywords:kbQFE kbnofix kbBug KB826373 kbAudITPRO