BlackBerry® Professional Software and BlackBerry® Enterprise Server Express

[Doug81]

I need some help figuring out what's going on. I've read some posts on various sites and KB articles but nothing has seemed to fit quite right.

Twice now after 2 server reboots all Blackberry users lose their contacts. Restarting the server again along wih a battery pull usually makes the contacts synch back to the devices though.

After the first reboot this message is repeated for different users in the Windows application log: "Unable to save configuration settings or statistics"

BES Express 5.0.2.29 is on Windows server 2003 with Exchange 2003.

[knottyrope]

contacts in public folders or in teh mail box?

I would apply SP3 as it has many fixes for BES 5.

[Doug81]

Thanks for the reply knotty, It's the mailbox contacts.

I upgraded to 5.0.3.41 and over the weekend the contacts cleared from the devices again.

[knottyrope]

I would look at teh sync logs to see what might be going on

default location :\Program Files\Research In Motion\BlackBerryEnterprise Server\Logs

Also look in event veiwer to seef if any errors or warnings pertain to your issue

Please post back the log info minus personal info

[Doug81]

This shows up in the SYNC log soon after the server starts.

[25137] (05/20 02:32:50.906):{0x27C0} {ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLNCLI.1;Server=Mailserver\BLACKBERRY;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[20000] (05/20 02:32:50.922):{0x27C0} COM Error 0x80004005 in ConnectionItem::ValidateConnection - TCP Provider: An existing connection was forcibly closed by the remote host.
 - Unspecified error
[25000] (05/20 02:32:50.922):{0x27C0} ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft SQL Native Client" - Description "SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. " - Command "ConnectionItem::ConnectToDB"
[20000] (05/20 02:32:50.922):{0x27C0} ConnectionPool::GetConnection(): Unable to get connection, because the Connection pool is uninitialized
[20000] (05/20 02:32:50.922):{0x27C0} [ODBCRecord::DoGetFirstValue] Unable to get connection
[20000] (05/20 02:32:50.922):{0x27C0} [ODBCRecord::DoGetFirstValue] SQL = "SELECT UserConfigID, SyncDataSourceId, DbType, CmdID, Flag FROM SyncRequest WHERE Operation = ?".
[20000] (05/20 02:32:50.922):{0x27C0} [ODBCRecord::DoGetFirstValue] DATA = "Operation[6] ".
[45060] (05/20 02:32:50.922):{0x27C0} {ConnectionPool::ValidatePool}: Pool is not initialized
[30000] (05/20 02:32:50.922):{0x27C0} ConnectionPool::ReInitializePool:  Connection Pool is being reinitialized
[25137] (05/20 02:33:35.922):{0x27C0} {ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLNCLI.1;Server=Mailserver\BLACKBERRY;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[45060] (05/20 02:33:35.922):{0x27C0} {ConnectionPool::ValidatePool}: Pool is not initialized
[20000] (05/20 02:33:35.922):{0x27C0} [ODBCDatabase::CheckConnection] ReInitializePool failed
[40000] (05/20 02:33:35.922):{0x27C0} BIPPeClient::SendInfo:: Send failure
[30000] (05/20 02:33:35.922):{0x27C0} [BIPP] Failed to send info
[26035] (05/20 02:33:35.922):{0x27C0} [SYNC-SRP] Failed to send health score to dispatcher.
[26045] (05/20 02:33:35.922):{0x27C0} [SYNC-Gate] Failed to access SyncRequest to fetch inserted "initialize" command.
[20000] (05/20 02:33:36.047):{0x27C0} [ODBCRecord::DoGetFirstValue] Unable to get connection
[20000] (05/20 02:33:36.047):{0x27C0} [ODBCRecord::DoGetFirstValue] SQL = "SELECT State FROM SyncServerState WHERE ServerConfigId = ? AND Type = ?".
[20000] (05/20 02:33:36.047):{0x27C0} [ODBCRecord::DoGetFirstValue] DATA = "ServerConfigId[1] Type[ServerConfigHistoryId] ".
[45060] (05/20 02:33:36.047):{0x27C0} {ConnectionPool::ValidatePool}: Pool is not initialized
[46010] (05/20 02:33:36.391):{0x2754} [SYNC-PIMConnectorReceiver] Thread stopped.
[30000] (05/20 02:33:36.391):{0x2754} [DIAG] EVENT=Unregister_thread, THREADID=0x2754, THREADNAME="PIMConnectorReceiver"
[46013] (05/20 02:33:36.391):{0x2758} [SYNC-PIMConnector] Prepare to exit.
[46015] (05/20 02:33:36.391):{0x2758} [SYNC-PIMConnector] Thread stopped.
[30000] (05/20 02:33:36.391):{0x2758} [DIAG] EVENT=Unregister_thread, THREADID=0x2758, THREADNAME="PIMConnector<Exchange>"

The following errors repeat many times for different users afterward.

[46064] (05/20 02:43:10.641):{0x25E4} [SYNC-SSession] DELETE request is required to be suspended. [Name:9, DS=Exchange, DB=Address Book]

[46111] (05/20 02:43:10.695):{0x25EC} [SYNC-SSession] Error Logging: Exchange.Address Book::D-7249-SUSPENDED_CHANGE,D-7250-SUSPENDED_CHANGE,D-7251-SUSPENDED_CHANGE,D-7252-SUSPENDED_CHANGE,D-7253-SUSPENDED_CHANGE,D-7254-SUSPENDED_CHANGE,D-7255-SUSPENDED_CHANGE,D-7256-SUSPENDED_CHANGE. [Name:2, SID=350453]

Windows logs during the same time

The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\BESMgmt.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

Login failed for user Domain\besadmin'. [CLIENT: Mail server IP]


CalICSAgent::Synch: Could not synchronize for User


CalICSAgent:: - SaveSyncInfo SaveProps for PR_RIM_SYNCH_x(0x80004005) failed for User



{User@domain.com} DoICS() failed: ERR_FAIL

[knottyrope]

is SQL browser service runnng?

is SQl using default ports?

[Doug81]

The SQL Browser service is running now but I don't know if it was prior to rebooting the server this morning.

The port being used is 2062. The SQL server is also on the same server with BESX and Exchange.

Side note, some devices need service books resent after a reboot and battery pull. With a few I had to delete their SYNC service book and then resend.

[knottyrope]

The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\BESMgmt.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

---

Is it really on a compressed drive or folder?

I would get this fixed ASAP

I hope you id not compress the whole server

[Doug81]

There is compression on at least some of the drive. I'm not a fan of drive compression so I'm going to try to un compress everything but right now I'm working on the SQL directory.

[Doug81]

Ok, there's no compression on this server now.

Is there anything else that sticks out to you knotty?