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



Reply
LinkBack Thread Tools Display Modes
KB13573 - SyncServerState error during BlackBerry Enterprise Server maintenance
 
  #1 (permalink)  
Old 11-25-2008, 10:48 AM
Si's Avatar
Si Si is offline
Proprietor
 
Join Date: Nov 2008
Location: London, UK
Posts: 1,046
Blog Entries: 6
Default KB13573 - SyncServerState error during BlackBerry Enterprise Server maintenance

KB13573 - SyncServerState error occurs during BlackBerry Enterprise Server maintenance

Environment

* BlackBerry® Enterprise Server software version 4.1 for Microsoft® Exchange
* BlackBerry® Enterprise Server software version 4.1 for Novell® GroupWise®
* SDR133048

Problem

When performing a BlackBerry Enterprise Server maintenance backup, the following error message appears in the Microsoft® SQL Server® database log:

Database '', index 'SyncServerState.PK_SyncServerState' (ID 946102411)

Cause

The application SyncServerState table allows null values in the ServerConfigID field. The ServerConfigID column is part of a unique index on the SyncServerState table. A unique index can only have one null value, and if it is built with multiple null values, a data consistency error occurs.

Resolution

This is a previously reported issue that has been escalated internally to our development team. No resolution time frame is currently available.

Workaround

Warning: Modifying databases used by the BlackBerry Enterprise Server can cause irreparable damage, resulting in unexpected server behavior or service failure. Back up the databases prior to implementing any changes.

Complete the following steps:

1. Open a command prompt and type the following commands in the specified order:

C:\> osql -E
1> backup database besmgmt to disk="c:\besmgmt.bak"
2> go
3> use besmgmt
4> dbcc dbreindex("SyncServerState")
5> go

where besmgmt is the name of the BlackBerry Configuration Database.

2. Close the command prompt.
__________________
Si MCTS
Co-Owner
Port3101 - Your BES Connection

Don't forget, you can follow us on Twitter

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
Reply With Quote
Sponsored Links
Reply

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
KB04426 - How to run Microsoft SQL Server maintenance jobs for the BB Config DB hdawg Featured BlackBerry KB Articles 0 09-12-2009 12:23 PM
KB14017 - Run Microsoft SQL Server maintenance using SQL Server 2005 Express hdawg Featured BlackBerry KB Articles 0 09-12-2009 12:22 PM
KB14047 - What are BlackBerry Enterprise Server software maintenance releases hdawg Featured BlackBerry KB Articles 0 08-23-2009 08:56 PM
KB15773 - Enable the Enterprise-Only message icon in BlackBerry Enterprise Server hdawg Featured BlackBerry KB Articles 1 07-20-2009 08:10 PM
KB04586 - BlackBerry Enterprise Server support for Microsoft Exchange Server 2003 SP2 hdawg Featured BlackBerry KB Articles 0 06-25-2009 11:16 AM


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


 

SEO by vBSEO 3.3.2 PL2