Microsoft KB Archive/826373

= Event ID 17055 Event Message &quot;Invalid object name 'dbo.GroomLock'&quot; When the Microsoft SQL Server Service Starts =

Article ID: 826373

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Operations Manager 2000 Service Pack 1

-





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:  Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.  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  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.

Keywords: kbqfe kbnofix kbbug KB826373

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.