<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:"Book Antiqua";
        panose-1:2 4 6 2 5 3 5 3 3 4;}
@font-face
        {font-family:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
        {mso-style-priority:99;
        mso-style-link:"Plain Text Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Verdana","sans-serif";}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";}
span.PlainTextChar
        {mso-style-name:"Plain Text Char";
        mso-style-priority:99;
        mso-style-link:"Plain Text";
        font-family:Consolas;}
span.plaintextchar0
        {mso-style-name:plaintextchar;
        mso-style-priority:99;
        font-family:"Verdana","sans-serif";}
span.EmailStyle21
        {mso-style-type:personal;
        font-family:"Verdana","sans-serif";
        color:blue;
        font-weight:normal;
        font-style:normal;
        text-decoration:none none;}
span.EmailStyle22
        {mso-style-type:personal;
        font-family:"Arial","sans-serif";
        color:navy;}
span.gmailquote
        {mso-style-name:gmailquote;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:Consolas;}
span.EmailStyle27
        {mso-style-type:personal-reply;
        font-family:"Verdana","sans-serif";
        color:blue;
        font-weight:normal;
        font-style:normal;
        text-decoration:none none;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
        {page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:blue'>That would be best, but if you just restart CCM service on all
servers (first on the publisher) that would be sufficient.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Rasim Duric<br>
Network Analyst (CCS)<br>
University of Guelph<br>
Guelph, N1G 2W1, ON<br>
519-824-4120x53146<br>
rduric@uoguelph.ca</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:blue'><o:p></o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> Chris D'amore
[mailto:CDAmore@jackhenry.com] <br>
<b>Sent:</b> Tuesday, March 13, 2007 11:57 AM<br>
<b>To:</b> Rasim Duric; Nick Marus; Poper, Cathy<br>
<b>Cc:</b> cisco-voip@puck.nether.net<br>
<b>Subject:</b> RE: [cisco-voip] DST Patch didn't update TypeTimeZone table?<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:navy'>Did you do a cluster wide re-boot
after the patch was applied?<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:navy'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <b>On Behalf Of </b>Rasim Duric<br>
<b>Sent:</b> Tuesday, March 13, 2007 10:44 AM<br>
<b>To:</b> Nick Marus; Poper, Cathy<br>
<b>Cc:</b> cisco-voip@puck.nether.net<br>
<b>Subject:</b> Re: [cisco-voip] DST Patch didn't update TypeTimeZone table?</span><o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoPlainText style='margin-left:.5in'>Go into the CCM database table
"TypeTimeZone" 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 the appropriate time zone.<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:10.0pt;
font-family:"Verdana","sans-serif";color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:10.0pt;
font-family:"Verdana","sans-serif";color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:10.0pt;
color:blue'>Rasim Duric<br>
Network Analyst (CCS)<br>
University of Guelph<br>
Guelph, N1G 2W1, ON<br>
519-824-4120x53146<br>
rduric@uoguelph.ca</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:blue'><o:p></o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal style='margin-left:1.0in'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <b>On Behalf Of </b>Nick Marus<br>
<b>Sent:</b> Tuesday, March 13, 2007 10:36 AM<br>
<b>To:</b> Poper, Cathy<br>
<b>Cc:</b> cisco-voip@puck.nether.net<br>
<b>Subject:</b> Re: [cisco-voip] DST Patch didn't update TypeTimeZone table?<o:p></o:p></span></p>
</div>
<p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p>
<div>
<p class=MsoNormal style='margin-left:1.0in'>Is there any reference what this
should look like on a patched system? and if it does require manual
update what it should be updated to? The format of this table seems obvious,
but just want to make sure that my assumptions are correct. <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:1.0in'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:1.0in'>Thanks,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:1.0in'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:1.0in'>Nick<br>
<br>
<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:1.0in'><span class=gmailquote>On 3/12/07,
<b>Poper, Cathy</b> <<a href="mailto:cpoper@hamilton.ca">cpoper@hamilton.ca</a>>
wrote:</span> <o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='margin-left:1.0in'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>I have the same problem happening
on our system. Still waiting on TAC's resolution. (our phones are
displaying the correct time because we modified the time-zone manually....until
TAC finds the problem for us...) </span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:1.0in'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>The log file clearly indicates
that the last thing I did was apply the DST 1.0.1 patch to the publisher -
The TypeTimeZone table did NOT update.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:1.0in'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>Just now, on my test system, I
re-applied the DST patch, and that finally udpated the table after a reboot -
and NOW the 2 phones in test are displaying the correct time.....I do NOT
understand the difference.... </span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:1.0in'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:blue'>The recommendation out there is to
manually modify the TypeTimeZone table - If I don't hear from TAC soon, I'm
going to go ahead and change this manually - but need to schedule some
downtime... </span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:1.0in'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:1.0in'> <o:p></o:p></p>
</div>
<p style='margin-left:1.0in'><b><i><span style='font-size:10.0pt;font-family:
"Book Antiqua","serif"'>Cathy Poper</span></i></b> <br>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>City of
Hamilton/IT Services</span> <br>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Network Support
Analyst</span> <br>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>55 York Blvd.,
6th floor</span> <br>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Hamilton,
Ontario </span><br>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Canada</span> <br>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>L8L 3K7</span> <br>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Tel:
905-546-2424 x5481 </span><br>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Fax:
905-546-2333</span> <br>
<i><u><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><a
href="mailto:cpoper@hamilton.ca" target="_blank">cpoper@hamilton.ca</a></span></u></i>
<o:p></o:p></p>
<div>
<blockquote style='margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:1.0in'><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>-----Original
Message-----<br>
<b>From:</b> <a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>
[mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>]
<b>On Behalf Of </b>Jason Aarons (US)<br>
<b>Sent:</b> Monday, March 12, 2007 3:43 PM<br>
<b>To:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net
</a><br>
<b>Subject:</b> [cisco-voip] DST Patch didn't update TypeTimeZone table?</span><o:p></o:p></p>
<div>
<p style='margin-left:1.0in'>I have a customer whose 7940/7960s didn't update,
the final update applied following the Field Notices step-by-step was <span
style='font-size:10.0pt;color:blue'><a
href="http://www.cisco.com/cgi-bin/Software/Tablebuild/doftp.pl?ftpfile=cisco/crypto/3DES/voice/callmgr/4.1/ciscocm.4-1-3-2007-DST-Update.1-0-1.exe&app=Tablebuild&status=showC2A"
target="_blank"><span style='font-size:11.0pt'>ciscocm.4-1-3-2007-DST-Update.1-0-1.exe</span></a>,
the log file for this patch shows Completed Successfully, however checking the
SQL Table </span><span style='color:#1F497D'>TypeTimeZone on publisher didn't
change to the new values. The operating system time and everything else looks
good. The log file timestamps show nothing was applied after </span><span
style='font-size:10.0pt;color:blue'><a
href="http://www.cisco.com/cgi-bin/Software/Tablebuild/doftp.pl?ftpfile=cisco/crypto/3DES/voice/callmgr/4.1/ciscocm.4-1-3-2007-DST-Update.1-0-1.exe&app=Tablebuild&status=showC2A"
target="_blank"><span style='font-size:11.0pt'>ciscocm.4-1-3-2007-DST-Update.1-0-1.exe</span></a>,</span><o:p></o:p></p>
<p style='margin-left:1.0in'><span style='color:#1F497D'> </span><o:p></o:p></p>
<p style='margin-left:1.0in'><span style='color:#1F497D'>Anyone else see </span><span
style='font-size:10.0pt;color:blue'><a
href="http://www.cisco.com/cgi-bin/Software/Tablebuild/doftp.pl?ftpfile=cisco/crypto/3DES/voice/callmgr/4.1/ciscocm.4-1-3-2007-DST-Update.1-0-1.exe&app=Tablebuild&status=showC2A"
target="_blank"><span style='font-size:11.0pt'>ciscocm.4-1-3-2007-DST-Update.1-0-1.exe</span></a>
show successful in logs but didn't really update the tables?</span><o:p></o:p></p>
<p style='margin-left:1.0in'> <o:p></o:p></p>
<p style='margin-left:1.0in'><span style='font-size:10.0pt'> </span><o:p></o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=590
style='width:6.15in;margin-left:1.0in;border-collapse:collapse'>
<tr>
<td width=132 valign=top style='width:99.0pt;border:solid windowtext 1.0pt;
padding:0in 5.4pt 0in 5.4pt'>
<p><span style='font-size:10.0pt'>Jason Aarons</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>Consultant</span><o:p></o:p></p>
</td>
<td width=458 valign=top style='width:343.8pt;border:solid windowtext 1.0pt;
border-left:none;padding:0in 5.4pt 0in 5.4pt'>
<p><span style='font-size:10.0pt'><a href="http://www.dimensiondata.com/na"
target="_blank">http://www.dimensiondata.com/na</a></span> <o:p></o:p></p>
<p><span style='font-size:10.0pt'>904-338-3245 cell</span><o:p></o:p></p>
</td>
</tr>
</table>
<p style='margin-left:1.0in'> <o:p></o:p></p>
<p style='margin-left:1.0in'><span style='font-size:10.0pt'>For urgent issues
notify your Project Manager, for 24x7 support contact the Dimension Data NOC at
800-974-6584.</span><o:p></o:p></p>
<p style='margin-left:1.0in'> <o:p></o:p></p>
</div>
<div style='margin-left:.5in'>
<div class=MsoNormal align=center style='margin-left:.5in;text-align:center'>
<hr size=1 width="100%" align=center>
</div>
</div>
<p style='margin-left:1.0in'><strong>Disclaimer: This e-mail communication and
any attachments may contain confidential and privileged information and is for
use by the designated addressee(s) named above only. If you are not the
intended addressee, you are hereby notified that you have received this
communication in error and that any use or reproduction of this email or its
contents is strictly prohibited and may be unlawful. If you have received this
communication in error, please notify us immediately by replying to this
message and deleting it from your computer. Thank you. </strong><o:p></o:p></p>
</blockquote>
</div>
</div>
<p class=MsoNormal style='margin-left:1.0in'><br>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
<br>
<br>
<br clear=all>
<o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-left:1.0in'><br>
<br clear=all>
<br>
-- <br>
Nick Marus<br>
<a href="mailto:nmarus@gmail.com">nmarus@gmail.com</a> <o:p></o:p></p>
<pre style='margin-left:.5in'>NOTICE: This electronic mail message and any files transmitted with it are intended exclusively<o:p></o:p></pre><pre
style='margin-left:.5in'>for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged<o:p></o:p></pre><pre
style='margin-left:.5in'>information. Any unauthorized review, use, printing, saving, copying, disclosure <o:p></o:p></pre><pre
style='margin-left:.5in'>or distribution is strictly prohibited. If you have received this message in error, please immediately<o:p></o:p></pre><pre
style='margin-left:.5in'>advise the sender by reply email and delete all copies.<o:p></o:p></pre></div>
</body>
</html>