BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 03-01-2012, 08:52 AM   #1
superdudeGTGGG
New Member
 
Join Date: Mar 2012
Model: 9700
PIN: N/A
Carrier: Orange UK
Posts: 6
Default BlackBerry Policy Service Warnings

Please Login to Remove!

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.

Last edited by superdudeGTGGG; 03-01-2012 at 09:05 AM..
Offline  
Old 03-01-2012, 09:24 AM   #2
DarthBBerry
Wireless Sith Lord
 
DarthBBerry's Avatar
 
Join Date: Jan 2007
Location: Online
Model: iOS 6
Carrier: Verizon x2
Posts: 1,458
Default 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
__________________
DarthBBerry
6-Time BlackBerry World Champion (2007-2012)
BlackBerry® Certified Support Specialist v5.0
BlackBerry® Certified System Administrator v5.0
Offline  
Old 03-01-2012, 09:40 AM   #3
superdudeGTGGG
New Member
 
Join Date: Mar 2012
Model: 9700
PIN: N/A
Carrier: Orange UK
Posts: 6
Default 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.
Offline  
Old 03-01-2012, 10:19 AM   #4
DarthBBerry
Wireless Sith Lord
 
DarthBBerry's Avatar
 
Join Date: Jan 2007
Location: Online
Model: iOS 6
Carrier: Verizon x2
Posts: 1,458
Default Re: BlackBerry Policy Service Warnings

Okay then... try this:
BlackBerry Technical Solution Center
__________________
DarthBBerry
6-Time BlackBerry World Champion (2007-2012)
BlackBerry® Certified Support Specialist v5.0
BlackBerry® Certified System Administrator v5.0
Offline  
Old 03-01-2012, 10:36 AM   #5
freakinvibe
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: Class
PIN: N/A
Carrier: Swisscom
Posts: 1,616
Default 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?
Offline  
Old 03-01-2012, 10:42 AM   #6
superdudeGTGGG
New Member
 
Join Date: Mar 2012
Model: 9700
PIN: N/A
Carrier: Orange UK
Posts: 6
Default Re: BlackBerry Policy Service Warnings

I have already searched the BlackBerry Technical Solution Center, but I could not find anything relevant.
Offline  
Old 03-01-2012, 10:45 AM   #7
freakinvibe
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: Class
PIN: N/A
Carrier: Swisscom
Posts: 1,616
Default 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?
Offline  
Old 03-01-2012, 10:48 AM   #8
superdudeGTGGG
New Member
 
Join Date: Mar 2012
Model: 9700
PIN: N/A
Carrier: Orange UK
Posts: 6
Default 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.
Offline  
Old 03-01-2012, 10:51 AM   #9
superdudeGTGGG
New Member
 
Join Date: Mar 2012
Model: 9700
PIN: N/A
Carrier: Orange UK
Posts: 6
Default Re: BlackBerry Policy Service Warnings

How do you check to find when the DB maintenance is being performed.
Offline  
Old 03-01-2012, 11:09 AM   #10
superdudeGTGGG
New Member
 
Join Date: Mar 2012
Model: 9700
PIN: N/A
Carrier: Orange UK
Posts: 6
Default 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.
Offline  
Old 03-01-2012, 02:42 PM   #11
DarthBBerry
Wireless Sith Lord
 
DarthBBerry's Avatar
 
Join Date: Jan 2007
Location: Online
Model: iOS 6
Carrier: Verizon x2
Posts: 1,458
Default Re: BlackBerry Policy Service Warnings

Quote:
Originally Posted by superdudeGTGGG View Post
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.
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.
__________________
DarthBBerry
6-Time BlackBerry World Champion (2007-2012)
BlackBerry® Certified Support Specialist v5.0
BlackBerry® Certified System Administrator v5.0

Last edited by DarthBBerry; 03-01-2012 at 02:43 PM..
Offline  
Old 03-01-2012, 02:59 PM   #12
knottyrope
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
Default 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?
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter

Rocking the Motion with out lotion.
Offline  
Closed Thread


Thread Tools

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 Off

Forum Jump

Similar Threads for: BlackBerry Policy Service Warnings
Thread Thread Starter Forum Replies Last Post
Databases on a BlackBerry jsconyers General BlackBerry Discussion 5 04-13-2010 07:53 AM
Web Desktop 5 no application loader Walter_Str BES Admin Corner 2 08-27-2009 07:05 AM
Initialize problem with BES and GroupeWise dupere BES Admin Corner 2 07-02-2008 02:09 PM
Mark Rejhon's Top 7 Most Important BlackBerry Requests for RIM's Growth Success Mark Rejhon General BlackBerry Discussion 15 06-06-2007 03:30 AM
BES 4.1 SP2 for Microsoft Exchange - Now Available jibi BES Admin Corner 51 01-10-2007 10:30 AM


Schneider 140CPU65150 Processor/Controller MODICON Quantum NEW picture

Schneider 140CPU65150 Processor/Controller MODICON Quantum NEW

$2899.00



PROFACE PFXSP5B10 Processor Module picture

PROFACE PFXSP5B10 Processor Module

$1500.00



AlphaSmart Neo2 Laptop Word Processor, . picture

AlphaSmart Neo2 Laptop Word Processor, .

$90.00



2023 Brand New B&R X20BM11 X20B M11 PLC Processor Module One year warranty US picture

2023 Brand New B&R X20BM11 X20B M11 PLC Processor Module One year warranty US

$23.80



New Allen-Bradley AB 1747-L532 /D SLC 500 SLC 5/03 CPU Processor Unit 1747L532 picture

New Allen-Bradley AB 1747-L532 /D SLC 500 SLC 5/03 CPU Processor Unit 1747L532

$394.70



New Sealed AB 1747-L543 SER C SLC 500 CPU Processor Unit Module 1747L543 picture

New Sealed AB 1747-L543 SER C SLC 500 CPU Processor Unit Module 1747L543

$703.23







Copyright © 2004-2016 BlackBerryForums.com.
The names RIM © and BlackBerry © are registered Trademarks of BlackBerry Inc.