08-25-2009, 09:56 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,238
|
|
KB17063 - Corrupt table index results in SQL errors
KB17063 - Corrupt table index results in SQL errors
Environment
- BlackBerry® Enterprise Server
- Microsoft® SQL Server™
- Microsoft® SQL Server™ Desktop Engine (MSDE)
Overview
The Windows® Event Viewer Application log show errors similar to the following: Event Type: Error
Event Source: DevMgmtConnector
Event Category: None
Event ID: 10000
Date: 7/22/2007
Time: 8:11:25 AM
User: N/A
Computer: <BlackBerry_Enterprise_Server_name>
Description:
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find the index entry for RID '3600000000020000010044004400650076004d0067006d00740053006500720076006500720043006f006e0066006900670 0' in index page (1:749), index ID 0, database 'BESMgmt'.[SqlState HY000][ODBCRecord: oSetValue]Error executing SQL statement "UPDATE SyncServerState SET State = ? WHERE Type = ?"..
Event Type: Error
Event Source: DevMgmtConnector
Event Category: None
Event ID: 10000
Date: 7/22/2007
Time: 8:11:21 AM
User: N/A
Computer: <BlackBerry_Enterprise_Server_name>
Description:
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find the index entry for RID '3600000000020000010044004400650076004d0067006d00740053006500720076006500720043006f006e0066006900670 0' in index page (1:749), index ID 0, database 'BESMgmt'.[SqlState HY000][ODBCRecord:oSetValue]DATA: State[190428] Type[DevMgmtServerConfigHistoryId]..
Cause
A table index in the BlackBerry Configuration Database is corrupt.
Resolution
This resolution involves restarting the BlackBerry Enterprise Server.
Important: Restarting certain BlackBerry Enterprise Server services will delay email message delivery to BlackBerry smartphones. For more information, see KB04789.
To resolve this issue, complete the following steps:
- Stop the BlackBerry Enterprise Server services.
- Back up the BlackBerry Configuration Database. For instructions, see KB10292.
- Complete the appropriate steps for your environment. For Microsoft SQL Server
- Open the SQL Query Analyzer and select the BlackBerry Configuration Database.
- Run the following command to list the corrupt tables: dbcc checkdb
- Run the following command to reindex each table that has a corrupt index: dbcc dbreindex('TableName')
where TableName is the table with the corrupt index.
For MSDE
- Open a command prompt window.
- Type OSQL -E and press Enter.
- Type the following commands in the specified order and press Enter after each line to obtain a list of the corrupt tables: 1>use DBName
2>go
1>dbcc checkdb
2>go
Where DBName is the name of the BlackBerry Configuration Database.
- Run the following command to re-index each table that has a corrupt index. 1>dbcc dbreindex('TableName')
2>go
Where TableName is the table with the corrupt index.
- Restart the BlackBerry Enterprise Server services.
Additional Information
Note that DBCC DBREINDEX is an offline operation. While this operation is running, the underlying table is unavailable to database users.
For more information search the Microsoft Developer Network website for DBCC DBREINDEX.
__________________
http://blog.port3101.org/hdawg/
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
|
Linear Mode
