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.