March 2012 Daylight Savings Time Update

Article ID: KB30209

Type: Support Content

Last Modified: 09-20-2012

 

Product(s) Affected:

  • BlackBerry Enterprise Server 5
CollapseEnvironment
  • BlackBerry Enterprise Server
  • BlackBerry Device Software 4.2.0.74 to 7.1
CollapseOverview

The March 2012 Daylight Savings Time (DST) update is cumulative and includes updates to the following time zones:

New Time Zones:

Country

Time Zone

DST Start

DST End

Russia Kaliningrad (GMT +3)*

No Daylight Savings Time

Novosibirsk (GMT +7)*
Samoa Apia (GMT +13) Saturday, September 29 at 3:00AM Sunday, April 1 at 4:00AM

Updated Time Zones:

Country

Time Zone

DST Start

DST End

Israel Jerusalem Friday, March 30, 2012 at 2:00AM Sunday, September 23, 2012 at 2:00AM
Chile Santiago Midnight between Saturday, September 1 and Sunday, September 2, 2012 Midnight between Saturday, April 28 and Sunday, April 29, 2012
Jordan Amman (GMT +2) Midnight between Thursday, March 29 and Friday, March 30, 2012 local standard time Friday, October 26, 2012 at 1:00 AM
Iran Tehran (GMT +3:30) Midnight between Tuesday, March 20 and Wednesday, March 21, 2012 Midnight between Thursday, September 20 and Friday, September 21, 2012
Brazil Ciuaba (GMT -4)* Midnight between Saturday, October 20 and Sunday, October 21, 2012 Midnight between Saturday, February 25 and Sunday, Feburary 26, 2012
Fiji Fiji (GMT +12)* Sunday, October 21, 2012 at 2:00AM Sunday, January 22, 2012 at 3:00AM
Belarus Minsk (GMT +3)

DST has been removed and the GMT offset has been set to +3

Armenia Yerevan

DST has been removed

Note: Ciuaba (GMT -4) has been renamed from Manaus (GMT -4)

Note: These updates were originally included in the February 2012 DST Update.

CollapseResolution

Prerequisites for installing the March 2012 DST update

To install the March 2012 DST update, the BlackBerry smartphone must be running a minimum of BlackBerry Device Software 4.2.

If the version of BlackBerry Device Software that is below 4.2, the BlackBerry smartphone must be upgraded to a supported version before the updates can be applied successfully. To determine what version of BlackBerry Device Software is currently installed go to Options->About. To upgrade the BlackBerry smartphone to a newer version of BlackBerry Device Software see KB13427 or visit http://www.blackberry.com/upgrades on your PC.


Installing the March 2012 DST update for individual BlackBerry smartphone users

BlackBerry Device Software 4.2 to 7.1

http://www.blackberry.com/dst2012/patches/carrier/Spring2012/net_rim_bb_timezoneupdater.jad

Note: The link above must be accessed directly from the BlackBerry Browser to download the patch over the wireless network. The BlackBerry smartphone may prompt to be reset after the patch has been downloaded and installed.

To determine if the March 2012 update has been installed, complete the following:

  1. Go to Options->Applications.
  2. Click the BlackBerry button and select Modules.
  3. Search for net_rim_bb_timezoneupdater and verify the version is 1.0.1.260.
  4. If the net_rim_bb_timezoneupdater is not found or has a lower number then the update has not been applied.

In order to fully support DST changes a Microsoft Windows update will need to be applied to the BlackBerry Enterprise Server. This requirement is applicable for all mail platforms. For additional information about DST and Windows please see Microsoft KB 914387.

Important note for BlackBerry Enterprise Server for Microsoft Exchange.

Early version of CDO.dll maintained separate internal time zone tables which required an update when a time zone changed. However, in more recent versions of cdo.dll Microsoft has designed CDO.dll to read DST information from the Windows registry. To support this feature CDO.dll, on the BlackBerry Enterprise Server, must be at 6.5.7654.01 or higher; or 6.5.8067.0 or higher. DST changes that require the creation of a NEW time zone will require an update to CDO.dll.

Note: Updates may also be required to other computers in your organization. Please see your individual mail platform vendors for details and instructions.

Option 1: SQL Script Update

This process involves executing a SQL query against the BlackBerry configuration database. Once executed the BlackBerry Synchronization service will automatically send the updated time zone information to the BlackBerry smartphone.

In order to leverage this method the BlackBerry Enterprise Server and BlackBerry smartphone must meet the following requirements:

- BlackBerry Enterprise Server 4.1 SP3 to SP7

OR

- BlackBerry Enterprise Server 5.0

AND

- BlackBerry Device Software 4.2.0 to 7.0

Note: The March 2012 DST updates contains updates to the display name of some timezones. Example Moscow (+3) has been updates to Moscow (+4). In order to update the display name of the time zone the TimeZoneUpdater application must be installed on the BlackBerry. Using this update option will update the BlackBerry smartphone with the correct DST Information however, the display name will not be updated.

If the BlackBerry Enterprise Server and/or BlackBerry Device Software do not meet the prerequisites please proceed to Option 2.

For instructions on applying the SQL script update please see the Additional Information section below.

Option 2: Using the TimeZoneUpdate application

This is required in order for the new and renamed time zones to be updated on the BlackBerry Device.

Administrators have five options for deploying the TimeZoneUpdater application to their end users.

   1. BlackBerry Desktop Software
   2. BlackBerry Application Web Loader
   3. Standalone Application Loader
   4. BlackBerry Browser
   5. Wireless Application Push

The BlackBerry Enterprise Server administrator can verify which users have the TimeZoneUpdater application using the BlackBerry Application Reporting Tool from the BlackBerry Resource Kit. For more information visit http://na.blackberry.com/eng/support/server_resourcekit.jsp.

CollapseAdditional Information

Updating the BlackBerry Configuration Database

Warning: The process modifies the BlackBerry Configuration Database. It is recommended that a full backup is made prior to the execution of the script.

This process can be completed from any workstation or server.      

    Download the TimeZoneUpdateMarch2012.zip and extract the contents.
    Open a command prompt and navigate to the folder that contains BBDBUpdate.exe
    Type BBUpdate.exe and add the switches application to your environment.

    The full command syntax is as follows:

        BBDBUpdate.exe -db <Database Name> -dbms <SQL> -n <SQL Server Name> -dbauth -dbuser <User Name> -dbpass <Password> -input <LoadSyncDeviceConfig.sql>

    Example:

    For BlackBerry Enterprise Server 4.1 SP3 to 4.1 SP7:
    BBDBUpdate.exe -db BESMgmt -n SQL1 -input .\SQLServer\4.1\LoadSyncDeviceConfig.sql

    For BlackBerry Enterprise Server 5.0:
    BBDBUpdate.exe -db BESMgmt -n SQL1 -input .\SQLServer\5.0\LoadSyncDeviceConfigData.sql

Required Switches

Switch Description
-db Use this switch to specify the name of the BlackBerry Configuration Database you are updating. The default value is BESMgmt
-n Use this switch to specify the hostname or instance of the database server.
-input Specifies the path and file name of the script to execute. Ensure that you are select the script for your applicable database server type.

Optional Switches

Switch Description
-dbms Use this switch to specify if you are using Microsoft SQL Server or IBM DB2 Universal Server. If this switch is not used, Microsoft SQL Server is assumed.
-dbauth Use this switch if you are using SQL Authentication. If this switch is not used, Windows Authentication is used.
-dbuser Use this switch to specify the user name to be used with the Microsoft SQL Server authentication. This switch is required if the -dbauth switch is used.
-dbpass Use this switch to specify the password to be used with the Microsoft SQL Server authentication. This switch is required if the -dbauth switch is used.

Note: If you receive the error Unable to read input file, check that the name and path of LoadSyncDeviceConfig.sql is correct.

 

CollapseAttachments

Disclaimer

By downloading, accessing or otherwise using the Knowledge Base documents you agree:

   (a) that the terms of use for the documents found at www.blackberry.com/legal/knowledgebase apply to your use or reference to these documents; and

   (b) not to copy, distribute, disclose or reproduce, in full or in part any of the documents without the express written consent of RIM.


Visit the BlackBerry Technical Solution Center at www.blackberry.com/btsc.