BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-07-2006, 08:46 AM   #1 (permalink)
New Member
 
Join Date: Sep 2006
Model: 8100
Carrier: Vodafone
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Users pending delete problem

Please Login to Remove!

Since we upgraded to BES 4.1 from 4.0 (for lotus domino), the users are not deleted as quickly and just get stuck in the 'Users pending delete queue'. In fact they just don't delete at all and remain in the queue for days.. (even when manually purging it, it doesn't seem to delete the user 100%). We work around this by simply restarting the BES Task on the Domino server,a s soon as we have to delete a user. This clears the queue immediately. Any ideas would be much appreciated
Offline  
Old 03-28-2007, 12:17 PM   #2 (permalink)
New Member
 
somi's Avatar
 
Join Date: May 2006
Location: MN
Model: 8703e
Carrier: Verizon
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Smile

You can perform following tasks on SQL server.

***********
Run SQL maintenance jobs for the BlackBerry Configuration Database
Doc ID : KB04426
Last Modified : 2006-11-07
Document Type : How To


Print this page

Environment

*
BlackBerry® Enterprise Server software versions 4.0 and 4.1
*
IBM® Lotus® Domino®
*
Microsoft® Exchange
*
Novell® GroupWise®



Procedures

In some environments, large numbers of transactions may cause the BlackBerry Configuration Database to increase in size. In some instances, this may be caused by the Microsoft SQL Server not running BlackBerry maintenance jobs automatically. The BlackBerry maintenance jobs should run automatically once a week by default; however, unless the SQLSERVERAGENT service is running, these jobs do not execute.
To run the SQL Server maintenance jobs

1.
Go to Control Panel>Administrative Tools>Services and double-click the SQLSERVERAGENT service. This opens the SQLServerAgent Properties window.

2.
Click Start and wait until the following jobs complete:

RIMPurgeDeletedUsersBESMgmt
RIMPurgeHistoryBESMgmt
RIMPurgeMDSMsgBESMGmt
RIMPurgeMDSStatsBESMgmt (for version 4.1 only)
RIMPurgeWorkQueueBESMgmt

Upon completion of the job for RIMPurgeDeletedUsersBESMgmt, the BlackBerry Configuration Database retains entries from the last 30 days or the last 10,000 entries, and deletes all prior entries.

3.
Upon completion of the RIMPurgeHistoryBESMgmt task, the BlackBerry Configuration Database retains entries from the last 60 days or the last 10,000 entries, and deletes all prior entries.

Upon completion of the job for RIMPurgeMDSMsgBESMgmt, the BlackBerry Configuration Database deletes the old data from push messages table and does not retain any old messages.

Upon completion of the job for RIMPurgeMDSStatsBESMgmt, the BlackBerry Configuration Database deletes the old statistic data for the BlackBerry Mobile Data Service (BlackBerry MDS) and does not retain any old statistics.

Upon completion of the job for RIMPurgeWorkQueueBESMgmt, the BlackBerry Configuration Database retains entries from the last 15 days or the last 10,000 entries, and deletes the prior entries.

4.
From the Startup type drop-down list, selectAutomatic so that the BlackBerry Configuration Database jobs run at consistent intervals, and so its size is kept to a manageable level.

Note: The SQLSERVERAGENT service is set to a Startup type of Manual in the default installation. If you set the service to Automatic, all BlackBerry maintenance jobs execute regularly, as in the following:


RIMPurgeDeletedUsersBESMgmt starts every week on Sunday at 2:00 AM.
RIMPurgeHistoryBESMgmt starts every week on Sunday at 1:00 AM.
RIMPurgeWorkQueueBESMgmt starts every week on Sunday at 2:00 AM.
RIMPurgeMDSMsgBESMgmt starts every day at 3:33 AM.
RIMPurgeMDSStatsBESMgmt starts every day at 2:22 AM.


You can run a job at any time. Alternatively, you can manually execute the stored procedures called by these jobs.

For Microsoft SQL 2000 Server

1.
In SQL Enterprise Manager, go to Microsoft SQL Servers\SQL Server Group\<BlackBerry_Enterprise_Server_name>\Manageme nt\SQL Server Agent and double-click Jobs.
2.
Right-click the name of the job you want to run and clickStart Job.


If you do not have SQL Enterprise Manager

1.
Open a command prompt.
2.
Type osql -E and press ENTER. The 1> prompt appears.
3.
The -E switch uses the Microsoft Windows® current account credentials to log in to the default BlackBerry Configuration Database. If you do not use the default database, add the -S<BlackBerry_Enterprise_Server_name><database_name > switch to the end of your osql command line.
4.
If a user does not have sufficient Windows permissions, or needs to use an SQL account to log in, replace -E with -U<username> -P <password>, where<user_name> is the SQL login name and <password> is the user account password.
5.
Type the following commands in the specified order:
1>use<database_name>
where <database_name> is the name of the BlackBerry Enterprise Server database.

2>exec<stored_procedure_name><days_retained>
where <stored_procedure_name> is the name of the stored procedure called by the job you want to run, and<days_retained> is the number of days for which to retain entries.

3>go

4>quit
6.
See the Additional Information section for the equivalent commands.
7.
Close the command prompt window.



Additional Information
This is a list of osql commands to specify a stored procedure for which you want to run calls, and the number of days to retain entries. You use these commands at the 2> prompt.

Job Name Stored Procedure Name Default Days Retained Value
RIMPurgeDeletedUsersBESMgmt RemoveDeletedUsers 60
RIMPurgeHistoryBESMgmt RemoveOldHistoryRows 30
RIMPurgeMDSMsgBESMgmt RemoveMDSPushMsgs None
RIMPurgeMDSStatsBESMgmt RemoveOldMDSStats None
RIMPurgeWorkQueueBESMgmt RemoveOldWorkQueue 15

Some examples of usage are the following:

2>exec RemoveDeletedUsers 30
2>exec RemoveOldHistoryRows 60
2>exec RemoveOldWorkQueue 15

The jobs without a Default Days Retained Value do not have the function to retain any old information. Do not specify a day value.

Products & Services:

* BlackBerry Enterprise Server for IBM Lotus Domino
* BlackBerry Enterprise Server for Microsoft Exchange
* BlackBerry Enterprise Server for Novell GroupWise
__________________


Samir
Offline  
Old 03-28-2007, 12:21 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2006
Model: 8800c
Carrier: Cingular
Posts: 112
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Wow, nice information. Thanks a bunch!
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





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