Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB17063 - Corrupt table index results in SQL errors
 
  #1 (permalink)  
Old 08-25-2009, 09:56 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default 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:
  1. Stop the BlackBerry Enterprise Server services.
  2. Back up the BlackBerry Configuration Database. For instructions, see KB10292.
  3. Complete the appropriate steps for your environment. For Microsoft SQL Server
    1. Open the SQL Query Analyzer and select the BlackBerry Configuration Database.
    2. Run the following command to list the corrupt tables: dbcc checkdb
    3. 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
    1. Open a command prompt window.
    2. Type OSQL -E and press Enter.
    3. 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.
    4. 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.
  4. 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/
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
KB11751 - Invalid properties in message service table hdawg Featured BlackBerry KB Articles 0 09-14-2009 10:14 PM
KB11719 - New Data Source ID results in constant slow synchronization hdawg Featured BlackBerry KB Articles 0 07-06-2009 10:25 PM
KB18396 - "{USER}-CDOCalendar::ProcessWindowsTimezoneInfo- No Index value present" hdawg Featured BlackBerry KB Articles 0 05-28-2009 04:29 PM
KB13618 - How to update the MDSConfig table referencing an incorrect server hdawg Featured BlackBerry KB Articles 0 04-14-2009 08:02 PM
Search results in BB Manager 4.1.6 MR4 Joolie Port 3101: The BES Admin Bar & Grill 8 03-20-2009 07:00 PM


All times are GMT -4. The time now is 02:48 PM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2