BlackBerry Policy Service Warnings
 

BES Ver: 4.1.7 MR3 OS: Windows 2003 R2 SP2 Exchange 2003 Sp2

For the last 2 days I have recieved the following 3 warnings in the application log.

They have been logged at nearly the same time each day.

Is it anything to be worried about? I have not noticed or have been told of any problems.

Event ID: 20640

Description:
SCS::GetRequestListForQuery(): COM Error 0x80040E31 - IDispatch error #3121 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Timeout expired" - Command " select i.Id, i.Priority, i.GroupingNumber, i.SequenceNumber, i.Status, i.Command, i.UserConfigId, u.PIN, i.PIN, u.MailboxSMTPAddr, i.TimeQueued, i.RawData from ITAdminQueue i, UserConfig u where ((i.GroupingNumber = 0 or (groupingnumber > 0 and i.id in (select id from itadminqueue t2 where groupingnumber > 0 and i.groupingnumber = t2.groupingnumber and i.sequencenumber = (select min(sequencenumber) from itadminqueue t2 where groupingnumber > 0 and i.groupingnumber = t2.groupingnumber and i.UserConfigId = t2.UserConfigId)))) and i.Status = 0 and i.UserConfigId = u.Id and u.ServerConfigId = ?) order by i.Priority, i.GroupingNumber, i.SequenceNumber, i.TimeQueued asc "


Event ID: 20000

Description:
SCS::PollDBQueueNewRequests - Error getting the list of new requests from the database.


Event ID:20000
SCS::ThreadProc - Change Detection PollDBQueueNewRequests failed


I have also added the related policy logs.

[20640] (03/01 08:05:49.212):{0x13EC} SCS::GetRequestListForQuery(): COM Error 0x80040E31 - IDispatch error #3121 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Timeout expired" - Command " select i.Id, i.Priority, i.GroupingNumber, i.SequenceNumber, i.Status, i.Command, i.UserConfigId, u.PIN, i.PIN, u.MailboxSMTPAddr, i.TimeQueued, i.RawData from ITAdminQueue i, UserConfig u where ((i.GroupingNumber = 0 or (groupingnumber > 0 and i.id in (select id from itadminqueue t2 where groupingnumber > 0 and i.groupingnumber = t2.groupingnumber and i.sequencenumber = (select min(sequencenumber) from itadminqueue t2 where groupingnumber > 0 and i.groupingnumber = t2.groupingnumber and i.UserConfigId = t2.UserConfigId)))) and i.Status = 0 and i.UserConfigId = u.Id and u.ServerConfigId = ?) order by i.Priority, i.GroupingNumber, i.SequenceNumber, i.TimeQueued asc "

[20000] (03/01 08:05:49.212):{0x13EC} SCS::PollDBQueueNewRequests - Error getting the list of new requests from the database.


[20000] (03/01 08:05:49.212):{0x13EC} SCS::ThreadProc - Change Detection PollDBQueueNewRequests failed


[40000] (03/01 08:05:49.540):{0x13EC} SCS::PollDBQueueNewRequests - Change Detection Poll: ProcessingRequests 0, LowerThreshhold 30, ProcessingBESes 1, MaxDomainJobs 300, MaxJobsToSchedule 300, MaxBESJobs 100, MaxRequestsToQueue 100, Requests 0, QueueInterval (ms) 0.

[40000] (03/01 08:05:49.540):{0x13EC} SCS::PollDBQueueNewRequests - Change Detection Poll: ProcessingRequests 0, LowerThreshhold 30, ProcessingBESes 1, MaxDomainJobs 300, MaxJobsToSchedule 300, MaxBESJobs 100, MaxRequestsToQueue 100, Requests 0, QueueInterval (ms) 0.

Re: BlackBerry Policy Service Warnings
 

Maybe this will help?
KB15788-Policy logs grow rapidly and service books and IT policy commands cannot be sent to BlackBerry smartphones after upgrading the BlackBerry Enterprise Server

Re: BlackBerry Policy Service Warnings
 

Thanks, but I don't see why that article is relevant. There are no problems sending service books or IT policy's to the BlackBerry's.

Also the logs in that article do not reflect what is showing in our logs.

Thanks.

Re: BlackBerry Policy Service Warnings
 

Okay then... try this:
BlackBerry Technical Solution Center

Re: BlackBerry Policy Service Warnings
 

Seems to be a SQL timeout. Is your SQL server on a separate box?

Is any DB maintenance going on at that time?

Re: BlackBerry Policy Service Warnings
 

I have already searched the BlackBerry Technical Solution Center, but I could not find anything relevant.

Re: BlackBerry Policy Service Warnings
 

Again: Seems to be a SQL timeout. Is your SQL server on a separate box?

Is any DB maintenance going on at that time?

Re: BlackBerry Policy Service Warnings
 

No my SQL server is on the same box as the BES.

I have noticed an informational message just before the 20640 warning is logged.
Event ID: 17055

17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.

Re: BlackBerry Policy Service Warnings
 

How do you check to find when the DB maintenance is being performed.

Re: BlackBerry Policy Service Warnings
 

I have just been looking through the app log in more detail. I see there are more timeouts errors occurring for backup exec as well. These have been logged as informational so I have not checked these before. There's timeout informational messages logged almost everyday at 8am.

I will have to do some further digging to see if I can find what is running at 8am to cause these timeouts.

Re: BlackBerry Policy Service Warnings
 

You are using MSDE or Personal Edition of SQL Server. These have a workload governor that limits the number of concurrent queries that can be executed on the server. See below topic for more details:

http://msdn.microsoft.com/en-us/libr...sql.80%29.aspx

So if you need to run more queries concurrently then you need to upgrade to standard or workgroup or enterprise edition depending on your requirements.

Re: BlackBerry Policy Service Warnings
 

most likely using MSDE and SQL 2005 express should work better unless you have many users.

how many users do you have?