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
SYMPTOMSYou 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'CAUSEThis 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.WORKAROUNDTo 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.
Modification Type: | Minor | Last Reviewed: | 6/13/2005 |
---|
Keywords: | kbQFE kbnofix kbBug KB826373 kbAudITPRO |
---|
|