BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-10-2006, 04:34 PM   #1 (permalink)
CrackBerry Addict
 
ashworth's Avatar
 
Join Date: Jun 2006
Location: Ontario, Canada
Model: 9000
OS: 4.6
Carrier: Rogers
Posts: 625
Post Thanks: 0
Thanked 0 Times in 0 Posts
Question What tools help you make the BES experience better for troubleshooting/supporting?

Please Login to Remove!

Here is a list of things I find handy as a BESAdmin.

Make sure the SQL Agent is running, the BlackBerry Enterprise Server, has SQL jobs that run every week for database maintenance. If the server is not started you could run into database issues. The service is called: SQLSERVERAGENT. Be default the service is stopped and set to manual.

I use MSDE and it is always a good idea to have a backup of the database. From DOS type the following to backup the Database:

Osql E
Backup database besmgmt to disk=c:\besmgmt.bak
Go


To restore a database
Osql E
Restore database besmgmt from disk=c:\besmgmt.bak
Go


If you would like to backup the CALs from your BES, do the following from DOS from the SQL/MSDE server:

c:\> bcp besmgmt..licensekeys out c:\keys.txt -c -T

To restore the keys

c:\> bcp besmgmt..licensekeys in c:\keys.txt -c -T

This will give you a backup of the keys and save them to the root of the c drive.

To Drop the Keys:
c:\> osql -E
1> delete from licensekeys
2> go

TCPView.exe is a great application to see what port are LISTENING and ESTABLISHED.

TextPad.exe is a great application to view the logs. You can also set it to auto-reload the file when the BES is writing to it.

Something else that I use but it has expired (need to purchase it) is Outlook Spy, with this tool you can see the hidden information the BES injects into the messages.

Able to find the RefID for PIM, Cal, and mail messages is always handy to look in the logs. Open up any item on the handheld, once it is open hold down alt ( ) and type the word view IF you have a 7100 style handheld you will need to type vviieww while holding down alt

Set database to unlimited
If you are using MSDE and you had a 3.6 BES and you upgraded to 4.0 or 4.1. The 3.6 BlackBerry Enterprise Server put a limit on the database of 100 megs. If you look in the application log and you see a bunch of errors about the primary file group full for BESMgmt your database has reached the 100 meg limit. With SQL it is easy to set the size for the mdf and ldf files. But with MSDE it is a bit harder. Use the following from the command line:

Backup Database
c:\> osql -E
1> backup database besmgmt to disk="c:\backup.bak"
2> go
1>exec sp_helpdb besmgmt
2>go
1>ALTER DATABASE BesMgmt MODIFY FILE (NAME = BesMgmt, MAXSIZE = UNLIMITED)
2>go
1> quit

DBClean.exe this is a tool I have been given by RIM support to delete the hidden folder information from users mailbox. I have seen this fix all kind of funky errors for individual users. Sometime when you remove a user from a BES it does not always delete the hidden information in the users mailbox if the user has corrupt data in his exchange mailbox. It is a command line tool, and you need to run it on the users workstation with Desktop Manager software installed on it. It is also recommended to make sure you MAPI profile is not using Caches Exchange Made if you use Outlook 2003.

I will most likely be editing this list I have some more stuff somewhere just cant find it or think of it.

4.1 IT Policy list.xls
__________________
Cheers,
Ash


My BlackBerry GPS Golf Application | Mileage Calculator

Last edited by ashworth : 07-13-2006 at 05:03 PM. Reason: Added RefID, and Outlook Spy, Added unlimited database size, DBClean.exe
Offline  
Old 06-11-2006, 10:32 AM   #2 (permalink)
Thumbs Must Hurt
 
morser's Avatar
 
Join Date: Feb 2005
Location: Windsor, On
Model: 9800
Carrier: Bell Mobility
Posts: 119
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Great Information. Thanks!
__________________
Morser,
History: PB32, 9800, 9700, 8310, 8700, 7100r, 7780, 7280, 6710, 957, 950
Offline  
Old 06-12-2006, 10:00 AM   #3 (permalink)
CrackBerry Addict
 
qc_metal's Avatar
 
Join Date: Mar 2005
Location: Rockford, IL
Model: 9530
OS: 4.7.x
Carrier: Verizon
Posts: 590
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just to add to the conversation, I use BerryStats (BerryStats for NonAdmins) so the Help Desk can reset Activation passwords in addition to viewing
extended statistics - granted 4.1 has this delegation built in, but it's nice to have available from a web page.

For managing the database (and backing up and restoring), I like to use the GUI management tool from Microsoft, which is also free to download and use. Get it from http://msdn.microsoft.com/vstudio/express/sql/download/ - look for the management studio express. OSQL is great too, I have the backup job scheduled in the Windows task scheduler.

Also, as far as text editors and viewers go, I like PSPad (http://www.pspad.com), since it is freeware.

Rob

Last edited by qc_metal : 06-12-2006 at 10:04 AM.
Offline  
Old 06-12-2006, 10:47 AM   #4 (permalink)
Knows Where the Search Button Is
 
flatfour's Avatar
 
Join Date: May 2006
Model: 8700
Carrier: Tee Mobeel
Posts: 22
Post Thanks: 0
Thanked 1 Time in 1 Post
Default Another text editor

I like to use Edit Pad Lite.

This editor has no problems opening huge (500meg) text files

Jim
Offline  
Old 06-12-2006, 05:48 PM   #5 (permalink)
New Member
 
Join Date: Jun 2006
Model: 7100T
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Blast! If only I had read this post BEFORE I moved our besmgmt sql db over to our SQL server. I was getting those 'file group full' error messages all day and the even log filled very quickly. Thanks for the pointers! Any others are very welcome.
Offline  
Old 07-04-2006, 09:32 AM   #6 (permalink)
CrackBerry Addict
 
ashworth's Avatar
 
Join Date: Jun 2006
Location: Ontario, Canada
Model: 9000
OS: 4.6
Carrier: Rogers
Posts: 625
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

To Fix the Send As Permissions issue:

Quote:
Originally Posted by StlGuyNow
Below is the resolution I had to walk through with Microsoft to correct the 1 hour permission revocation...
-------------------------------------------------------------

Issue:
======

Protected members are unable to send mail through Blackberry on the Exchange 2003 server xxx8220;#MailServerName#"


Resolution:
===========

Granted the Blackberry or other application service account the Send As permission on every user in a container or domain.

To grant Send As for a single account on all user accounts in an Active Directory domain or container followed these steps:

xxx183; Start the Active Directory Users and Computers management console.

xxx183; On the View menu, make sure that the Advanced Features option is selected. If this option is not selected, the Security page will not be visible for domain and container objects.

xxx183; Open the properties of the domain or container, and then click the Security page.

xxx183; Click the Advanced button.

xxx183; If the account that needs permission is not already listed, click Add, and then select the account. Otherwise double-click the account for editing.

xxx183; In the Applies Onto list, click User Objects.

xxx183; Grant the account Send As permission.

xxx183; Click OK until you have exited and saved all changes.

From the command prompt ran:
==========================

xxx183; Dsacls "cn=administrator,cn=users,dc=domain,dc=com" /G "Domain\BlackBerry:CA;Send As"

xxx183; Dsacls "cn=adminsdholder,cn=system,dc=domain,dc=com" /G "Domain\BlackBerry:CA;Send As"

xxx183; This will add Black Berry Service Account to Mailbox user which are part of protected Group and also grant "Send As" of Black Berry Account on AdminSDHolder Object.

xxx183; Therefore, "Send As" permission of users which are member of protected group will not be removed after Hour.

xxx183; Restarted the exchange information store.

xxx183; Restarted the blackberry services.

---------------------------------------------------------------
remember, that for "cn=administrator,cn=users,dc=domain,dc=com" /G "Domain\BlackBerry:CA;Send As"

you need to replace dc=domain with your AD domain (IE:dc=microsoft)
you need to replace dc=com with your AD extension (IE:dc=net)
you need to replace Domain\Blackberry with your BES admin account
__________________
Cheers,
Ash


My BlackBerry GPS Golf Application | Mileage Calculator

Last edited by ashworth : 08-31-2006 at 01:11 PM.
Offline  
Old 10-24-2006, 04:40 PM   #7 (permalink)
Thumbs Must Hurt
 
guruleenyc's Avatar
 
Join Date: Oct 2006
Location: nYc & CT
Model: 8820
Carrier: AT&T/Sprint/Nextel
Posts: 186
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Anyone know of a Web-Based graphical analysis tool for BES?
__________________
BES Admin/Nextel 60x 7520's/10x AT&T 8800's/2x BES

"Knowledge breeds confidence and confidence breeds success"
Offline  
Old 10-25-2006, 06:49 AM   #8 (permalink)
Thumbs Must Hurt
 
morser's Avatar
 
Join Date: Feb 2005
Location: Windsor, On
Model: 9800
Carrier: Bell Mobility
Posts: 119
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

i'm currently just using PERFMON, connecting to the bes and watching the CPU, NIC traffic, 4 "Received/min" threads and the 4 "Sent/min" threads.
at least i know whether the emails are flowing and whether besalert.exe has stolen my CPU again or not.

I'd like a better monitoring tool....but this will do for now.
__________________
Morser,
History: PB32, 9800, 9700, 8310, 8700, 7100r, 7780, 7280, 6710, 957, 950
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

LinkBacks (?)
LinkBack to this Thread: http://www.blackberryforums.com/bes-admin-corner/37789-what-tools-help-you-make-bes-experience-better-troubleshooting-supporting.html
Posted By For Type Date
BlackberryExpress: September 2006 This thread Refback 10-02-2006 08:01 PM





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