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



Reply
LinkBack Thread Tools Display Modes
KB15805 - BlackBerry Dispatcher fails to start with error 5061
 
  #1 (permalink)  
Old 01-21-2009, 01:20 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB15805 - BlackBerry Dispatcher fails to start with error 5061

KB15805 - BlackBerry Dispatcher fails to start with error 5061


Environment

  • BlackBerry® Enterprise Server software version 4.0 and later for IBM® Lotus® Domino®
  • BlackBerry® Enterprise Server software version 4.0 and later for Microsoft® Exchange
  • BlackBerry® Enterprise Server software version 4.0 and later for Novell® GroupWise®
  • Microsoft® SQL Server®
  • Microsoft® SQL Server® Desktop Engine (MSDE)



Overview

The BlackBerry Dispatcher fails to start and returns an error 5061 when an administrator attempts to start it manually on the Windows® Services console.
The BlackBerry Messaging Agent (MAGT) log file may show lines similar to the following:
[30058] (03/03 09:10:29):{0x1E5C} Starting Database
[40000] (03/03 09:10:29):{0x2E74} [DIAG] EVENT=Register_thread, THREADID=0x2E74, THREADNAME="ExtUDPLogThread"
[50049] (03/03 09:10:29):{0x2E74} Waiting for external UDP log messages on port 4094
[30000] (03/03 09:10:29):{0x1E5C} ADO ConnectionTimeout value = 384s
[50000] (03/03 09:10:29):{0x2E74} Controller: This BES Agent is under control of BlackBerry Agent Controller
[40000] (03/03 09:10:44):{0x1E5C} ConnectionPool: Created pool of 5 connections

[30442] (03/03 09:11:44):{0x1E5C} [PMDatabaseSQLImp::GetUserList] Timeout or deadlock. 4 re-tries left. [ SELECT a.DisplayName, a.MailboxDN, a.ServerDN, a.DeviceType, a.PIN, a.RedirectionState, a.ExtServicesState, a.CalendarEnableState, a.CreationTime, a.OverrideSMTPAddr, a.OTAFMState, a.OTAFMConflictResolution, a.OTAPIMState, a.lurnum, a.MailboxSMTPAddr, a.ServerConfigId, a.PendingServerConfigId, a.PendingKey, a.CurrentKey, a.PreviousKey, a.OTAFMUserConfig, a.ITPolicy2Id, a.Id, a.DeviceCapabilities, a.KeyDate, a.DataSourceId, a.ServiceBookName, a.AckData, a.ActivationTime, a.RoutingInfo, a.UserDeleteStatus, a.PendingRoutingInfo, a.KeyGenPassword, a.KeyGenExpiryTime, a.AutoSignature, a.RedirectWhenInCradle, a.DisableSentItems, a.AutoKeyGenerate, a.DefaultFilterAction, a.Filters, b.LastSentTime, b.LastFwdTime, b.LastXPAction, b.MsgsSent, b.MsgsForwarded, b.MsgsPending, b.MsgsFailed, b.MsgsExpired, b.MsgsFiltered, b.LastMsgExpired, b.Status, b.UserConfigId, b.Id FROM UserConfig a, UserSta

[30442] (03/03 09:12:31):{0x1E5C} [PMDatabaseSQLImp::GetUserList] Timeout or deadlock. 3 re-tries left. [ SELECT a.DisplayName, a.MailboxDN, a.ServerDN, a.DeviceType, a.PIN, a.RedirectionState, a.ExtServicesState, a.CalendarEnableState, a.CreationTime, a.OverrideSMTPAddr, a.OTAFMState, a.OTAFMConflictResolution, a.OTAPIMState, a.lurnum, a.MailboxSMTPAddr, a.ServerConfigId, a.PendingServerConfigId, a.PendingKey, a.CurrentKey, a.PreviousKey, a.OTAFMUserConfig, a.ITPolicy2Id, a.Id, a.DeviceCapabilities, a.KeyDate, a.DataSourceId, a.ServiceBookName, a.AckData, a.ActivationTime, a.RoutingInfo, a.UserDeleteStatus, a.PendingRoutingInfo, a.KeyGenPassword, a.KeyGenExpiryTime, a.AutoSignature, a.RedirectWhenInCradle, a.DisableSentItems, a.AutoKeyGenerate, a.DefaultFilterAction, a.Filters, b.LastSentTime, b.LastFwdTime, b.LastXPAction, b.MsgsSent, b.MsgsForwarded, b.MsgsPending, b.MsgsFailed, b.MsgsExpired, b.MsgsFiltered, b.LastMsgExpired, b.Status, b.UserConfigId, b.Id FROM UserConfig a, UserSta

[30442] (03/03 09:13:05):{0x1E5C} [PMDatabaseSQLImp::GetUserList] Timeout or deadlock. 2 re-tries left. [ SELECT a.DisplayName, a.MailboxDN, a.ServerDN, a.DeviceType, a.PIN, a.RedirectionState, a.ExtServicesState, a.CalendarEnableState, a.CreationTime, a.OverrideSMTPAddr, a.OTAFMState, a.OTAFMConflictResolution, a.OTAPIMState, a.lurnum, a.MailboxSMTPAddr, a.ServerConfigId, a.PendingServerConfigId, a.PendingKey, a.CurrentKey, a.PreviousKey, a.OTAFMUserConfig, a.ITPolicy2Id, a.Id, a.DeviceCapabilities, a.KeyDate, a.DataSourceId, a.ServiceBookName, a.AckData, a.ActivationTime, a.RoutingInfo, a.UserDeleteStatus, a.PendingRoutingInfo, a.KeyGenPassword, a.KeyGenExpiryTime, a.AutoSignature, a.RedirectWhenInCradle, a.DisableSentItems, a.AutoKeyGenerate, a.DefaultFilterAction, a.Filters, b.LastSentTime, b.LastFwdTime, b.LastXPAction, b.MsgsSent, b.MsgsForwarded, b.MsgsPending, b.MsgsFailed, b.MsgsExpired, b.MsgsFiltered, b.LastMsgExpired, b.Status, b.UserConfigId, b.Id FROM UserConfig a, UserSta

[30442] (03/03 09:13:44):{0x1E5C} [PMDatabaseSQLImp::GetUserList] Timeout or deadlock. 1 re-try left. [ SELECT a.DisplayName, a.MailboxDN, a.ServerDN, a.DeviceType, a.PIN, a.RedirectionState, a.ExtServicesState, a.CalendarEnableState, a.CreationTime, a.OverrideSMTPAddr, a.OTAFMState, a.OTAFMConflictResolution, a.OTAPIMState, a.lurnum, a.MailboxSMTPAddr, a.ServerConfigId, a.PendingServerConfigId, a.PendingKey, a.CurrentKey, a.PreviousKey, a.OTAFMUserConfig, a.ITPolicy2Id, a.Id, a.DeviceCapabilities, a.KeyDate, a.DataSourceId, a.ServiceBookName, a.AckData, a.ActivationTime, a.RoutingInfo, a.UserDeleteStatus, a.PendingRoutingInfo, a.KeyGenPassword, a.KeyGenExpiryTime, a.AutoSignature, a.RedirectWhenInCradle, a.DisableSentItems, a.AutoKeyGenerate, a.DefaultFilterAction, a.Filters, b.LastSentTime, b.LastFwdTime, b.LastXPAction, b.MsgsSent, b.MsgsForwarded, b.MsgsPending, b.MsgsFailed, b.MsgsExpired, b.MsgsFiltered, b.LastMsgExpired, b.Status, b.UserConfigId, b.Id FROM UserConfig a, UserStats

[10249] (03/03 09:14:30):{0x1E5C} PMDatabaseSQLImp::GetUserList: COM Error 0x80040E31 - IDispatch error #3121 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Timeout expired" - Command "(null)"
[20284] (03/03 09:14:30):{0x1E5C} OpenDB: Populate list of pagers failed.
[10031] (03/03 09:14:30):{0x1E5C} Open() failed
[50004] (03/03 09:14:30):{0x1E5C} Stopping BlackBerry





Cause

The BlackBerry® Enterprise Server is querying the BlackBerry Configuration Database for startup data and is not receiving timely responses from the database server. The result is a database timeout or deadlock.



Resolution

To prevent a database timeout or deadlock that affects the BlackBerry Enterprise Server, complete the following steps:
  1. Make sure that unnecessary BlackBerry Enterprise Server services are not started. For example, duplicate BlackBerry Enterprise Server services set for disaster recovery on separate computers. These duplicate BlackBerry Enterprise Server services may cause an increased load and decrease performance on the database server.
  2. Review the Microsoft SQL Server or MSDE for blocked store procedure IDs (SPIDs) using the following Structured Query Language (SQL) query:
    SELECT * FROM SYSPROCESSES.
  3. If there are blocked SPIDs, consult Microsoft for the most efficient course of action.
  4. If multiple BlackBerry Enterprise Server instances are affected, stagger the startup of the BlackBerry Enterprise Server instances to minimize the load put on the database server.
  5. In large environments, consider increasing database performance by using a regional model for the BlackBerry Configuration Database. This minimizes the number of BlackBerry Enterprise Server instances that connect to a single BlackBerry Configuration Database.



Additional Information

Contact Microsoft support for the most efficient performance analysis for a Microsoft SQL Server or MSDE database.
Review the Database Connections in BlackBerry Enterprise Server Version 4.1 document located at the following link:
Livelink - Redirection
__________________
http://blog.port3101.org/hdawg/
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
KB04797 - "Service-specific error 5613" when attempting to start the Dispatcher hdawg Featured BlackBerry KB Articles 0 09-20-2009 04:18 PM
KB01274 - Error "Service fails to start, generating error 1068" appears when starting hdawg Featured BlackBerry KB Articles 0 09-02-2009 10:12 PM
KB16352 - Message Confirmation Service fails to start with error 1069 hdawg Featured BlackBerry KB Articles 0 06-09-2009 05:46 PM
KB16001 - BlackBerry Controller service fails to start with error 5003 after restart hdawg Featured BlackBerry KB Articles 1 05-26-2009 09:45 AM
KB15621 - BlackBerry Dispatcher fails to start with error 5603 (Domino BES) hdawg Featured BlackBerry KB Articles 0 12-23-2008 02:23 PM


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


 

SEO by vBSEO 3.3.2 PL2