Category Archives: Blackberry

Blackberry: Changes in BES 12.5.0a

On July 26 2016 BlackBerry released "BlackBerry Enterprise Service 12 Service Pack 5a" (BES 12.5.0a) without release notes. So there was no direct way of finding out what the "a" really changed.

Digging through the KB articles I found this:

http://support.blackberry.com/kb/articleDetail?articleNumber=000038323

So the short answer is: The "a" fixes one specific issue that would block you from upgrading from a previous BES version to 12.5.

If you already have upgraded to BES 12.5.0 successfully, you don't need to apply 12.5.0a. If you could not upgrade (e.g. from 12.4), version 12.5.0a now lets you upgrade.

Find below the full text of the KB, in case Blackberry deletes or changes it:

Unable to upgrade to BlackBerry Enterprise Service 12 Service Pack 5

Article Number: 000038323 First Published: July 13, 2016 Last Modified: August 12, 2016 Type: Support

Environment

  • BlackBerry Enterprise Service 12

Issue Tracking

  • JI 1557439

Overview

When attempting to upgrade to BlackBerry Enterprise Service 12 Service Pack 5 the upgrade fails during the database deployment phase.

Looking in the db_start_command_log log file in the deployment directory (the default location is C:\Program Files\BlackBerry\BES\Logs\deployment) the following error is seen:

2016-07-12T17:04:17,596 main MDMLogger ERROR  Problem processing sql: 
/* 59.13.4 */
UPDATE def_policy_setting_definition
    SET name = './Vendor/MSFT/Policy/Config/Privacy/AllowInputPersonalization'
  WHERE internal_id = 'IT_CONFIG.WP.dataprotection.allow.input.personalization.x'
    AND name = './Vendor/MSFT/Policy/Config/DataProtection/AllowInputPersonalization'
    AND id_device_os_family IN (SELECT id_device_os_family
                                    FROM def_device_os_family
                                   WHERE name = 'WP');
com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY constraint 'AK_def_policy_setting_dfn'. 
Cannot insert duplicate key in object 'dbo.def_policy_setting_definition'. 
The duplicate key value is (IT_CONFIG.WP.dataprotection.allow.input.personalization.x, ./Vendor/MSFT/Policy/Config/Privacy/AllowInputPersonalization, 6).

Cause

An IT Policy Pack update was pushed out on July 12th, 2016. This introduced some data into the database that is causing the Service Pack 5 upgrade to fail. Customers who upgraded prior to this update would have completed the upgrade successfully and will not be affected by this issue.

Resolution

Please run the attached script only once against the SQL server that hosts the BlackBerry Enterprise Service 12 database following these steps:

  1. Backup the BES Database.
  2. Download and execute the attached script.
  3. Re-run the BlackBerry Enterprise Service 12 Service Pack 5 setup.exe file to upgrade BES to the latest version.

Repeat step 3 above on the BES12 instances installed in the same BES12 domain (sharing the same database).

Additional Information

On July 26 2016 BlackBerry released "BlackBerry Enterprise Service 12 Service Pack 5a" which includes a fix for this issue for customers who did not already upgrade to Service Pack 5.  This version can be used to upgrade without the need to manually run an additional script.

Note: If the server is already running Service Pack 5 and the above issue either did not occur or was already corrected, there is no need to upgrade to Service Pack 5a.

Attachment

 

Blackberry 10: Remove Anti-Theft Protection from Device

With OS version 10.3.2, Blackberry has introduced Anti-Theft Protection (the company was required to do so by law). It did this by integrating Anti-Theft functionality in its "Blackberry Protect" offering.

While this might reduce the number of stolen devices, it is a horror for people that have forgotten their Blackberry ID password. Their Blackberry has turned into a useless brick and Blackberry support was in many cases less than useful.

But there is now a method to remove Anti-Theft Protection. It basically consists of 2 steps: Install an older device OS (e.g. 10.3.1) which removes Anti-Theft and then update to the latest OS again. Here are the steps in detail (this is for a Z30 with the currently latest 10.3.2.2836 Software Release on):

  1. Switch your "bricked" phone on and go through the setup wizard until you get to the "The anti-theft protection feature is on. To continue with device set-up you must enter your BlackBerry ID" screen.
  2. Download the developer version of the 10.3.1 Autoloader of your device, e.g. for the Z30 it is
    Autoload-STA100-3-10.3.1.997.exe
    downloadable from the Blackberry web site here:
    http://downloads.blackberry.com/upr/developers/downloads/Autoload-STA100-3-10.3.1.997.exe
  3. If you have a different device, download the correct Autoloader from here:
    https://developer.blackberry.com/devzone/blackberry10devalpha/allautoloaders.html
  4. Run the executable on a PC (must have BB Link installed for the correct drivers).
  5. Once it says "Connecting to Bootrom", connect your Blackberry device.
  6. It will restart and load the old OS. Wait until this is 100% complete. There might be an error on the computer, saying "Error: This OS version is blocked from device." Don't worry about this, it does not matter.
  7. Once the device is restarted, it will run you through the setup wizard. Sign in with your new Blackberry ID. Then, indicate that you want to install updates.
  8. Once the setup is completed, check if updates get installed via "Settings > Software Updates".
  9. It will install the updates, restart, and that's it! You have a "de-bricked" device.

If step 6 failed with a double-blinking red LED, first load OS version 10.3.2 with the autoloader. You can download it from here: https://mega.nz/#!8shEkQQD!5LzrH8Vj-jZIHOVYAnTnEvr44hZVjq9XMt21fi1-jNQ. The file name is: AutoLoader_Z30-Classic-Leap_10.3.2.2876.exe

Once 10.3.2 is loaded go to step 1 and do the whole procedure. It should now work.

Blackberry OS 10: How to mute the dial pad on the phone

When you dial a number on a Blackberry OS 10 device like the Classic or the Z30, you hear the typcal "dialling" sound, also called DTMF. Unfortunately, there is no switch to turn that off.

The only way to do this is to switch your sound profile to "Silent" or "Vibrate", but that mutes any other notifications as well.

Here are the instructions to turn the dial pad tone off but still hearing other notifications:

Settings > Notifications

Make sure, the active profile is "Normal"

Under the Profiles heading, tap on "Normal"

On the "Normal" profile, toggle "Sound" off

Tap on "Customize App Notifications"

Tap on "Phone" and toggle "Sound" on

With that, you will hear the ring tone, but you will not hear the dial pad.

If you have other apps that should do sound notifications, e.g. Calendar, you have to go to "Customize App Notifications" > "Calendar" and set the Sound to on as well.

Blackberry KB03112: BES 5.0: How to move the BlackBerry Configuration Database to a new Microsoft SQL Server instance

Last modified: 05-05-2015
Environment
  • BlackBerry Enterprise Server 2.1 to 5.0 SP4
  • BlackBerry Enterprise Server for Office 365
  • Microsoft SQL Server 2000 SP3 to 2012
  • Microsoft SQL Server Desktop Engine (MSDE)
Overview

Confirm that the Database version is compatible with the Microsoft SQL Server version before moving the BlackBerry Configuration Database to a new Microsoft SQL Server instance. Refer to compatibility matrix at:

BlackBerry Enterprise Server Compatibility Matrix

The BlackBerry Enterprise Server services must be stopped during the process described in this article.

Note: In a Microsoft Exchange environment, complete the tasks using the BlackBerry Enterprise Server service account unless otherwise stated.

Complete the following tasks to move the BlackBerry Configuration Database to a new Microsoft SQL Server instance:

Task 1: Prepare the new Microsoft SQL Server
Task 2: Back up the BlackBerry Configuration Database
Task 3: Restore the BlackBerry Configuration Database
Task 4: Configure the BlackBerry Enterprise Server

Task 1 - Prepare the new Microsoft SQL Server

Note: Complete this task using an account with administrator access to the new Microsoft SQL Server. Microsoft SQL Server 2005 or 2008 requires the following server role permissions:
System Administrator, Database Creator.

Step 1: Assign the appropriate permissions based on the applicable environment

Microsoft SQL Server 2000 to 2012

  1. Open Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 to 2012).
  2. Go to Microsoft Server Group > <SQL_Server_name> > Security.
  3. Right-click Logins and select New Login.
  4. From the General tab, click the double quotation marks ( "" ) button.
  5. From the Global Address List, select the name of the BlackBerry Enterprise Server service account.
  6. Click Add, then click OK.
  7. On the Server Roles tab, select Server Administrators and Database Creators.
    Note: In BlackBerry Enterprise Server 4.1, the System Administrator role is needed for role-based administration.
  8. Close Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 to 2012).

Microsoft SQL Server Desktop Engine (MSDE)

  1. Log in to the new Microsoft SQL Server.
  2. Right-click My Computer, and click Manage.
  3. Expand Local Users and Groups.
  4. Select Groups and then click the Administrators group.
  5. Click Add.
  6. Type the name of the BlackBerry Enterprise Server service account and then click Check Name.
  7. Click OK.
  8. Close the Computer Management window.
  • Step 2: Turn on the correct server protocols based on the applicable environment

Microsoft SQL Server 2008 to 2012 Express or Microsoft SQL Server2008 to 2012

  1. Click Start > Microsoft SQL Server 20xx > Configuration Tools > SQL Server Configuration Manager.
  2. Expand SQL Server Network Configuration.
  3. Select the Microsoft SQL Server instance that will be used for the BlackBerry Configuration Database.
  4. If necessary, turn on the TCP/IP and Named Pipes protocols.
  5. If a protocol is turned on in the previous step, restart the Microsoft SQL Server services.

Microsoft SQL Server 2005 Express or Microsoft SQL Server 2005

  1. Click Start > Microsoft SQL Server 2005 > Configuration Tools > Microsoft Server Configuration Manager > Microsoft Server 2005 Network Configuration.
  2. Select the Microsoft SQL Server instance that will be used for the BlackBerry Configuration Database.
  3. If necessary, turn on the TCP/IP and Named Pipes protocols.
  4. If a protocol is turned on in the previous step, restart the Microsoft SQL Server services.

Microsoft SQL Server Desktop Engine (MSDE) or Microsoft SQL Server 2000

  1. Click Start > Run.
  2. Type svrnetcn.
  3. Click OK. The Microsoft Server Network Configuration Utility opens.
  4. Make sure that TCP/IP and Named Pipes are both listed as protocols that have been turned on.
  5. Close the Microsoft Server Network Configuration Utility.
  6. If a protocol is turned on in step 2, restart the Microsoft SQL services.

Step 3: Make sure that the SQL Server Agent service is running

Note: This step only applies to BlackBerry Enterprise Server  4.1.7 and earlier. BlackBerry Enterprise Server 5.0 and later no longer relies on the SQL Server Agent service for maintenance procedures.

Note: The SQL Server Agent service is not available for Microsoft SQL Server Express editions. If running Microsoft SQL Server 2005 Express or Microsoft SQL Server 2008 Express, see KB14017.

  1. Open the Windows Control Panel, then open Administrative Tools > Services.
  2. Make sure that the SQL Server Agent service is started for the instance and that the Startup type is set to Automatic.
  3. Close the Services window.

Step 4: Update the BlackBerry Configuration Database schema

Important: If the BlackBerry Enterprise Server software was installed to create a blank BlackBerry Configuration Database on a new Microsoft SQL Server instance, do not perform the following steps, because the schema has already been updated.

Note: If you are running BlackBerry Enterprise Server 5.0, CreateDB.exe is recommended, but not necessary to run prior to restoring the database backup.

  1. Download the installation package for the version of the BlackBerry Enterprise Server that is being used.
  2. Extract the contents of the installation package.
  3. Copy the Database folder to the new Microsoft SQL Server.
    Note: The default location of this folder is C:\Research In Motion\BlackBerry Enterprise Server 4.x.x\Database
  4. Go to the Database folder and open the BESMgmt.cfg file in a text editor, such as Notepad.
  5. Locate the DB_NAME=BESMgmt or (DATABASE_NAME=BESMgmt) line depending on the version of the upgrade and then make sure that the name specified matches the BlackBerry Configuration Database name.
  6. If using a named instance of Microsoft SQL Server, change the SERVER=local line to SERVER=<SQL_Server_Name>\< instance_name>.
  7. Close the file, and Save the changes.
  8. From a command prompt, navigate to the Database directory.
  9. Type createdb.exe BESMgmt.cfg and press Enter.
  10. After the command has finished executing, close the command prompt.

Task 2 - Back up the BlackBerry Configuration Database

Note: When backing up the BlackBerry Configuration Database, complete the steps based on the applicable environment.

Microsoft SQL Server 2000 to 2012

  1. Open Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 or 2008).
  2. Right-click the BlackBerry Configuration Database (for example, BESMgmt).
  3. Select Backup Database.
  4. Click Add to specify the Directory Name and File Name.
  5. Click OK to accept the settings.
  6. Click OK again to start the backup process.
  7. Close Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 or 2008) when the process is complete.

Microsoft SQL Server Desktop Engine (MSDE)

  1. From a command prompt, type osql -E and press Enter.
    Note: If logging in to a named instance of the Microsoft SQL Server, use the following command syntax to log in: osql -E -S <SQL_Server_name>\<instance_name>
  2. Type the following commands in the specified order:
    1. backup database <BlackBerry_Configuration_Database_name> to disk = 'C:\<BlackBerry_Configuration_Database_name>.bak'
    2. go
    3. quit
  3. Close the command prompt.

Task 3 - Restore the BlackBerry Configuration Database

There are two methods available to restore the BlackBerry Configuration Database and each are dependent upon the applicable environment:

  • Restore the BlackBerry Configuration Database from a backup
  • Detaching and re-attaching the BlackBerry Configuration Database files.

Restore database method for Microsoft SQL Server 2000 to 2012

  1. Open Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 to 2012).
  2. Right-click the Databases (for example, BESMgmt).
  3. Select Tasks>Restore Database.
  4. Click From Device and browse for the .bak file.
  5. Select Options and ensure Overwrite the existing database is selected.
  6. Click OK to accept the selection.
  7. Close Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 to 2012) when the process is complete.

Detach and re-attach database method for Microsoft SQL Server 2000 to 2012

  1. Open the Control Panel, and open Administrative Tools > Services.
  2. Stop each service that has a name that begins with BlackBerry.
  3. Log in to the existing Microsoft SQL Server.
  4. Open Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 to 2012).
  5. Right-click the BlackBerry Configuration Database name.
  6. Select All Tasks, and click Detach Database for Microsoft SQL Server 2000 or for Microsoft SQL Server 2005 or 2008, select Tasks and click Detach.
  7. Close Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 to 2012).
  8. Go to the Microsoft SQL Server Data directory and copy the MDF and LDF files.
    Note: The default path is C:\Program Files\Microsoft SQL Server\MSSQL\Data\ and the default filenames are BESMgmt.mdf and BESMgmt.ldf.
  9. Log in to the new Microsoft SQL Server.
  10. Open Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 to 2012).
  11. Right-click the BlackBerry Configuration Database name.
  12. Select All Tasks, then click Detach Database for Microsoft SQL Server 2000 or for Microsoft SQL Server 2005 select Tasks and click Detach.
  13. Move the files that were copied in step 8 to the Microsoft SQL Server Data directory.
  14. When prompted to overwrite the files, click Yes.
  15. In Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 or 2008), right-click the Database folder, then click All Tasks.
  16. Select Attach Database for Microsoft SQL Server 2000 or for Microsoft SQL 2005 to 2012 right-click the Database folder and select Attach.
  17. Select the MDF file to attach, then click OK.
  18. Close Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 to 2012).

Restore database method for Microsoft SQL Server Desktop Engine on a Microsoft SQL Server having the same directory structure

  1. Copy the BlackBerry Configuration Database backup to the C:\ path of the new Microsoft SQL Server.
  2. From a command prompt, type osql -E and press Enter.
    Note: When logging in to a named instance of the Microsoft SQL Server, use the following command: osql -E -S <SQL_Server_name>\<instance_name>
  3. Type the following commands in the specified order:
    1. restore database <BlackBerry_Configuration_Database_name> from disk = 'c:\<BlackBerry_Configuration_Database_name>.bak' with recovery, replace
    2. go
    3. quit
  4. Close the command prompt.

Restore database method for Microsoft SQL Server Desktop Engine on a Microsoft SQL Server having a different directory structure

  1. Copy the BlackBerry Configuration Database backup to the C:\ path of the new Microsoft SQL Server.
  2. From a command prompt, type osql -E and press Enter.
    Note: When logging in to a named instance of the Microsoft SQL Server, use the following command: osql -E -S <SQL_Server_name>\<instance_name>
  3. Type the following commands in the specified order:
    1. restore database <BlackBerry_Configuration_Database_name> from disk =
      "C:\<BlackBerry_Configuration_Database_name>.bak" with move
      "<BlackBerry_Configuration_Database_name>_data" to
      "<new_path>\MSSQL\Data\<BlackBerry_Configuration_Database_name>.mdf", move
      "<BlackBerry_Configuration_Database_name>_log" to "<new_path>\MSSQL\Data\<BlackBerry_Configuration_Database_name>.ldf"Note: To determine the logical file names <BlackBerry_Configuration_Database_name>_data and <BlackBerry_Configuration_Database_name>_log for the BlackBerry Configuration Database, complete the following steps:

      1. On the Microsoft SQL Server hosting the BlackBerry Configuration Database, open a command prompt and type the following command:
        OSQL -E or OSQL -E -S <SQL_Server_name>\<instance_name>
      2. Type the following commands in the specified order, pressing Enter after each command:
        exec sp_helpdb <BlackBerry_Configuration_Database_Name>
        go
        The two logical file names for the BlackBerry Configuration Database are BESMgmt_data and BESMgmt_log.
      3. Close the command prompt.
    2. go
    3. quit
  4. Close the command prompt.

Detach and re-attach database method for Microsoft SQL Server Desktop Engine

  1. Open the Control Panel, and open Administrative Tools > Services.
  2. Stop each service that has a name that begins with BlackBerry.
  3. Log in to the existing MSDE Server.
  4. From a command prompt, type osql -E and press Enter.
    Note: When logging in to a named instance of the Microsoft SQL Server, use the following command: osql -E -S <SQL_Server_name>\<instance_name>
  5. Type the following commands in the specified order:
    1. exec sp_detach_db @dbname = "<BlackBerry_Configuration_Database_name>"
    2. go
    3. quit
  6. Go to the Microsoft SQL Server Data directory and copy the MDF and LDF files.
    Note: The default path is C:\Program Files\Microsoft SQL Server\MSSQL\Data\ and the default filenames are BESMgmt.mdf and BESMgmt.ldf.
  7. Move the files that were copied in step 6 to the new Microsoft SQL Server.
  8. Log in to the new MSDE Server.
  9. From a command prompt, type osql -E and press Enter.
    Note: When logging in to a named instance of Microsoft SQL Server, use the following command: osql -E -S <SQL_Server_name>\<instance_name>
  10. Type the following commands in the specified order:
    1. exec sp_detach_db @dbname = "<BlackBerry_Configuration_Database_name>"
    2. go
    3. quit
  11. Move the files that were copied in step 6 to the Microsoft SQL Server Data directory. When prompted to overwrite the files, click Yes.
  12. From a command prompt, type osql -E and press Enter.
    Note: If logging in to a named instance of Microsoft SQL Server, use the following command syntax to log in: osql -E -S <SQL_Server_name>\<instance_name>
  13. Type the following commands in the specified order:
    1. exec sp_attach_db @dbname = "<BlackBerry_Configuration_Database_name>"
    2. @filename1 = "C:\Program Files\Microsoft SQL Server\MSSQL\Data\<BlackBerry_Configuration_Database_name>.mdf",
    3. @filename2 = "C:\Program Files\Microsoft SQL Server\MSSQL\Data\<BlackBerry_Configuration_Database_name>.ldf"
    4. go
    5. quit
  14. Close the command prompt.

Task 4 - Configure the BlackBerry Enterprise Server

To configure the BlackBerry Enterprise Server to connect to the new BlackBerry Configuration Database, complete the following steps:

For BlackBerry Enterprise Server for Office 365

Note: BlackBerry Enterprise Server for Office 365 does not have a change database option like previous versions.

  1. Manually update the BESMgmt database with the new SQL instance name by running the following Transact-SQL command against the BESMgmt database:
    UPDATE DatabaseServer SET Name = 'SQLServer\SQLInstance'
    Where SQLServer\SQLInstance is the SQL server and SQL instance information for the new destination SQL server.
  2. Then continue with following KB18129 that explains the configuration and connect process for BlackBerry Enterprise Server 5.0.

For BlackBerry Enterprise Server 5.0

BlackBerry Enterprise Server 5.0 does not have a change database option like previous versions. KB18129 explains the configuration and connect process for BlackBerry Enterprise Server 5.0.

For BlackBerry Enterprise Server 4.0 to 4.1

  1. On the BlackBerry Enterprise Server, click Start > Programs > BlackBerry Enterprise Server > BlackBerry Server Configuration.
  2. On the Database Connectivity tab, click Change Database.
  3. In the Change Database Wizard, specify the new Microsoft SQL Server name and the existing BlackBerry Configuration Database name.
  4. Complete the wizard. Make sure that the Start Services check box is selected and click Finish.
  5. Open Administrative Tools > Services and make sure that all of the BlackBerry Enterprise Server services started successfully.
    Note: The BlackBerry Database Consistency Service might be unavailable, this is normal.
  6. Open BlackBerry Manager and make sure that the correct database is set up by completing the following:
    1. For BlackBerry Enterprise Server 4.0
      1. Right-click BlackBerry Manager, and click Properties.
      2. Select the Properties tab and verify that the Microsoft SQL Server information and BlackBerry Configuration Database name are correct.
    2. For BlackBerry Enterprise Server 4.1
      1. Go to Tools > Options > Database and verify that the Microsoft SQL Server information and BlackBerry Configuration Database name are correct.
      2. Verify that all of the BlackBerry smartphone user accounts appear on BlackBerry Manager.
      3. If there is a remote BlackBerry Manager, make sure to check the settings from step 6.
      4. Test email message flow from the BlackBerry smartphone.
      5. For BlackBerry Enterprise Server 4.1, install the database notification system.
        Note: This is only required in smaller environments running a maximum of 3 BlackBerry Enterprise Server instances.
      6. Copy the RimEsp.dll file to the C:\Program Files\Microsoft SQL Server\MSSQL\Binn folder on the new Microsoft SQL Server.
      7. In Microsoft Query Analyzer, go to the Database\DBInstallScripts\SQLServer\4.1 folder on the installation media.
      8. Open the NotifyInstall.sql file and replace <_databasename> with the name of the BlackBerry Configuration Database.
      9. Run the script.
  7. Verify that the Microsoft Query Analyzer displays the following message:  Function dbo.xp_RIM_xxxx registered
Additional Information

When moving from a Microsoft SQL Server Desktop Engine (MSDE) server instance to a full Microsoft SQL Server instance on a separate computer, see KB04039 for information on how to increase the mail agent limitation on the BlackBerry Enterprise Server.

If receiving an error that the BlackBerry Configuration Database is in use, complete the following steps:

  1. Remove all the BlackBerry smartphone user accounts from the BlackBerry Configuration Database by typing the following commands at a command prompt:
    1. OSQL -E
    2. use master
    3. alter database <BlackBerry_Configuration_Database_name> set single_user with rollback immediate
    4. go
    5. use <BlackBerry_Configuration_Database_name>
    6. go
    7. exit
  2. Detach the BlackBerry Configuration Database by typing the following commands at a command prompt:
    1. OSQL -E
    2. use master
    3. sp_detach_db @dbname = <BlackBerry_Configuration_Database_name>
    4. go
    5. exit
  3. Attach the BlackBerry Configuration Database by typing the following commands at a command prompt:
    1. OSQL -E
    2. use master
    3. exec sp_attach_db @dbname = "<BlackBerry_Configuration_Database_name>",
    4. @filename1 = "C:\<Path_to_database_file>\<BlackBerry_Configuration_Database_name>.mdf",
    5. @filename2 = "C:\<Path_to_transaction_log_file>\<BlackBerry_Configuration_Database_name>.ldf"
    6. go
    7. exit
      Note: The default path is C:\Program Files\Microsoft SQL Server\MSSQL\Data and the default filenames are BESMgmt.mdf and BESMgmt.ldf.

Blackberry Q10/Z10: OS and Software Versions

When it comes to Blackberry device software (= OS = Operating System) there is some confusion regarding versions. There are 2 version numbers:

  1. Software Release Version (= Bundle Version)
  2. OS Version

The Software Release Version is the one displayed when you are notified that new device software is available.

Find below a table of the Q10/Z10 device software versions I could find:

Software Release OS Version
10.0.10.85 10.0.10.672
10.0.10.90 10.0.10.690
 .
10.1.0.238 10.1.0.1483
10.1.0.273 10.1.0.1720
10.1.0.2309 10.1.0.2342
10.1.0.2312 10.1.0.2354
10.1.0.4181 10.1.0.4633
10.1.0.4200 10.1.0.4780
.
10.2.0.415 10.2.0.1767
10.2.0.424 10.2.0.1791
10.2.1.537 10.2.1.1925
10.2.1.2102 10.2.1.2141
10.2.1.2941 10.2.1.3175
10.2.1.2977 10.2.1.3247
10.2.1.3062 10.2.1.3442
.
10.3.1.1779 10.3.1.2576
10.3.1.1784 10.3.1.2582
10.3.2.2474 10.3.2.2639

BES 10.1: Order to start services

If you need to start the services on BES 10.1 manually, do it in the order below:

  1. BES10 - Scheduler
  2. BES10 - BlackBerry Controller
  3. BES10 - BlackBerry MDS Connection Service
  4. BES10 - BlackBerry Dispatcher
  5. BES10 - BlackBerry Secure Connect Service
  6. BES10 - Administration Console
  7. BES10 - BlackBerry Administration Service - Native Code Container
  8. BES10 - BlackBerry Administration Service - Application Server
  9. BES10 - BlackBerry Management Studio
  10. BES10 - BlackBerry Licensing Service

 

Blackberry OS10 Modes: Standby, Bedside and Shutdown

The modes in the Blackberry Z10 device are different than for previous devices (OS 7.1, e.g. Bold 9900). There are five modes:

  • On
    Screen: On
    Notifications: On
    Alarm: On
    Network: On
    How to invoke: Press the standby button or swipe from bottom to top
  • Standby (or Screen Lock)
    Screen: Off
    Notifications: On
    Alarm: On
    Network: On
    How to invoke: Press the standby button
  • Password Lock  (only if device password is set)
    Screen: Off
    Notifications: On
    Alarm: On
    Network: On
    How to invoke: Press the standby button and release it before the countdown ends, then click the lock icon
  • Bedside (or Sleep)
    Screen: Off (when on battery), Dimmed clock (when on power)
    Notifications: Off
    Alarm: On
    Network: On
    How to invoke: Swipe from top to bottom
  • Shutdown
    Screen: Off
    Notifications: Off
    Alarm: Off
    Network: Off
    How to invoke: Press the standby button until countdown ends (from 3 to 1)

In addition to this, you can restart (reboot) the Z10 by pressing the standby button and release it before the countdown ends, then click the restart icon.

RegEx for BES Proxy URL Setting

Have you ever wondered what the default pattern matching string for the proxy URL settings in BES means?

.*://.*(:\d*)?(/.*)*(\?.*)?

Well, this is Java RegEx (Regular Expression) language. Find below some examples that help understand the RegEx:

.       matches exactly one character
.*      matches any number of characters (including 0), short for .{0,}
.+      matches one or more characters, short for .{1,}
.?      matches zero or one character, short for .{0,1}
.{7}    matches exactly 7 characters

\d      matches exactly one digit, short for [0-9]
\d*     matches any number of digits (including 0), short for \d{0,}
etc

[a-z]   matches exactly one small letter
[A-Z]   matches exactly one capital letter

(:\d*)? matches a column followed by any number of digits. Element is optional (matches if occurs zero or one time)

(/.*)*  matches a forward slash followed by any number of characters. Element can occour any number of times

(\?.*)? matches a question mark followed by any number of characters. Element is optional (matches if occurs zero or one time)

\.      matches exactly one dot

So the default URL string means:

Any number of characters must be followed by a column. (i.e. http: or https: or ftp:). Then, any number of characters follow (i.e. the fully qualified host name). Optionally, a column and a port number can follow. Then a sequence of forward slashes and characters can follow. Optionally a question mark and any numbers of characters can follow.

Version and Bundle numbers for Blackberry Enterprise Server for Exchange

Find below the version and corresponding bundle number of the BES versions. The third number is the Service Pack (SP) number, e.g. 4.1.5 means version 4.1 with SP5.

HF = Hotfix
MR = Maintenance Release

The bundle number is important when you need to find out which version you are running. It is listed in “Add/Remove Programs”.

Version
Bundle
4.0.2 11
4.0.2 HF1 13
4.0.2 HF2 15
4.0.2 HF3 16
4.0.3 9
4.0.3 HF1 11
4.0.3 HF2 14
4.0.3 HF3 16
4.0.3 HF4
4.0.4 7
4.0.4 HF1 8
4.0.4 HF2 9
4.0.4 HF3 11
4.0.5 23
4.0.5 HF1 28
4.0.6 19
4.0.7 14
4.0.7 MR1 23
4.0.7 MR2 38
4.0.7 MR3 51
4.1 60
4.1 HF1 66
4.1.2 47
4.1.2 HF1 67
4.1.2 HF2 90
4.1.3 37
4.1.3 HF1 43
4.1.3 HF2 61
4.1.4 25
4.1.4 MR1 70
4.1.4 MR2 89
4.1.4 MR3 117
4.1.4 MR4 134
4.1.4 MR5 159
4.1.4 MR6 172
4.1.5 79
4.1.5 MR1 89
4.1.6 30
4.1.6 MR1 60
4.1.6 MR2 73
4.1.6 MR3 92
4.1.6 MR4 105
4.1.6 MR5 144
4.1.6 MR6 170
4.1.6 MR7 174
4.1.6 MR8 222
4.1.7 27
4.1.7 MR1 32
4.1.7 MR2 45
4.1.7 MR3 52
5.0 223
5.0 MR1 236
5.0 MR2 244
5.0 MR3 255
5.0 MR4 267
5.0.1 70
5.0.1 MR1 82
5.0.1 MR2 117
5.0.1 MR3 139
5.0.2 36
5.0.2 MR1 51
5.0.2 MR2 96
5.0.2 MR3 119
5.0.2 MR4 133
5.0.2 MR5 146
5.0.3 33
5.0.3 MR1 41
5.0.3 MR2 53
5.0.3 MR3 93
5.0.3 MR4 107
5.0.3 MR5 143
5.0.3 MR6 163
5.0.3 MR7 227
5.0.3 MR8 256
5.0.4 38
5.0.4 MR1 52
5.0.4 MR2 70
5.0.4 MR3 86
5.0.4 MR4 100
5.0.4 MR5 116
5.0.4 MR6 128
5.0.4 MR7 160
5.0.4 MR8 183
5.0.4 MR9a 198
5.0.4 MR10 223
5.0.4 MR11 234
5.0.4 MR12 261