DST for Callmanager 4.0.2a

Unanswered Question
Feb 1st, 2007

I have tested a DST fix for callmanager 4.0.2a. I made an adjustment in MS SQL >> CCM300 Database >> Tables >>TypeTimezone >> Return All Rows in the eastern time to the new dates for DST. The change took effect with a reset of the phones.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 1 (1 ratings)
Loading.
Erick Bergquist Thu, 02/01/2007 - 10:23

Why not upgrade to 4.1(3) or 4.2(3) which have fix for this?

Why stay on 4.0(2a) which has no more updates?

4.1(3) is a upgrade you can download from CCO and run, to get up to 4.1(3). 4.2(3) is also a downloadable upgrade from CCO.

Cisco also now has a standalone DST patch available for 3.3(5), 4.1(3), and 4.2(3) on the CCO Download page for 3.3, 4.1, and 4.2 updates.

So , you need to go to 4.1(3) or 4.2(3) , and current SR , then apply the standalone DST fix if you want to address this issue and be supported.

CCO Links:

http://www.cisco.com/cgi-bin/tablebuild.pl/callmgr-41

http://www.cisco.com/cgi-bin/tablebuild.pl/callmgr-42

http://www.cisco.com/cgi-bin/tablebuild.pl/callmgr-33

shawnohearn Tue, 03/13/2007 - 07:23

tomcatdroll

i'm running callmanager 4.12sr1. what did you enter for 'stddate' and 'dstdate'?

old dst

stddate = 0/10/0/5,2:0:0:0 - how does this translate to october 28?

dstdate = 0/4/0/1,2:0:0:0 - how does this translate to april 1

new dst

stddate = ????

dstdate = ????

thanks

rob.huffman Tue, 03/13/2007 - 09:18

Hi Shawn,

Here is the info from Mahesh @ Cisco;

However as a workaround, you could resolve it by going into the Start >> Programs >> Microsoft SQL Server >> Enterprise Manager >> CCM database >> Table >> "TypeTimeZone" >> Right Click Open Table >> Return All Rows and manually set the "stddate" and "dstdate" to "0/11/0/1,2:0:0:0" and "0/3/0/2,2:0:0:0" respectively for each US timezone.

CM Service needs to be restarted.

From this detailed thread;

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=IP%20Telephony&CommCmd=MB%3Fcmd%3Ddisplay_location%26location%3D.1dddd0fe

Hope this helps!

Rob

Here is a guess for;

old dst

stddate = 0/10/0/5,2:0:0:0 - 10=October 5= 5th week 0=Sunday

dstdate = 0/4/0/1,2:0:0:0 - 4=April 1= 1st week 0=Sunday

Actions

This Discussion