<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Arial;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.emailstyle17
{font-family:Tahoma;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle19
{font-family:Tahoma;
color:black;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=black face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:black'>Just a follow up.. SQL was caching
corrupted entries. I deleted the Route Pattern and Route List, rebooted Call
Manager (to clear the SQL Cache), recreated the Route Pattern and Route List
and life is good…</span></font></p>
<p class=MsoNormal><font size=2 color=black face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:black'> </span></font></p>
<p class=MsoNormal><font size=2 color=black face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:black'>I going to get a beer!</span></font></p>
<p class=MsoNormal><font size=2 color=black face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:black'> </span></font></p>
<div>
<p class=MsoNormal><b><font size=2 color=black face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:black;font-weight:
bold'>Thanks, <br>
Bill Carter</span></font></b><b><font color=black face="Comic Sans MS"><span
style='font-family:"Comic Sans MS";color:black;font-weight:bold'> <br>
</span></font></b><em><b><i><font size=1 color=olive face="Comic Sans MS"><span
style='font-size:8.0pt;font-family:"Comic Sans MS";color:olive;font-weight:
bold'>Senior Business Communications Analyst</span></font></i></b></em><b><font
size=1 color=olive face="Comic Sans MS"><span style='font-size:8.0pt;
font-family:"Comic Sans MS";color:olive;font-weight:bold'><br>
<a href="http://www.sentinel.com/" target="_blank"><font color=olive><span
style='color:olive;text-decoration:none'>Sentinel Technologies, Inc.</span></font></a></span></font></b><b><font
size=1 color=olive face="Comic Sans MS"><span style='font-size:8.0pt;
font-family:"Comic Sans MS";color:olive;font-weight:bold'> <br>
</span></font></b><font size=1 color=olive face="Comic Sans MS"><span
style='font-size:8.0pt;font-family:"Comic Sans MS";color:olive'><a
href="mailto:bcarter@sentinel.com">bcarter@-nospam-sentinel.com</a> <br>
</span></font><font size=1 color=black face="Comic Sans MS"><span
style='font-size:8.0pt;font-family:"Comic Sans MS";color:black'>217.391.5015
(W) <br>
800.860.8102 (P) <br>
217.698.9222 (F) </span></font></p>
<div>
<div class=MsoNormal><b><font size=3 color=olive face=Arial><span
style='font-size:12.0pt;color:olive;font-weight:bold'>
<hr size=2 width="65%" align=left>
</span></font></b></div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 color=olive
face=Arial><span style='font-size:10.0pt;color:olive;font-weight:bold'><a
href="http://newsroom.cisco.com/dlls/partners/news/2004/pr_prod_02-11.html"
target="_blank"><span style='text-decoration:none'>Cisco Systems 2003 Global IP
Communications Partner of the Year</span></a></span></font></b><b><font size=2
color=olive><span style='font-size:10.0pt;color:olive;font-weight:bold'> </span></font></b></p>
</div>
<p class=MsoNormal><font size=2 color=black face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:black'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Carter, Bill <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, August 26, 2004
2:59 PM<br>
<b><span style='font-weight:bold'>To:</span></b> cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> [cisco-voip] CCM
3.3(4)SR1 SQL Database corruption</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face=Arial><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>The exact same problem has happened
to me twice in the last 3 days. I have a specific route pattern for Least
cost routing pointing to a RouteList, then to a RouteGroup, then to a
Gateway. After working on it, I got it to work. I then made a
change to the calling party transformation mask, and then the route pattern
fails.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>The site has 2 LD route patterns</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>9.1XXXXXXXXXX</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>and</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>9.1217XXXXXXX</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>The pattern with the area code is
the one in question. I point it to its own route list. I do not
strip any digits. The H323 VG has a dial-peer with a destination pattern
of 91217.T</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>The problem is, using debug isdn
q931, the call never is presented to the VG. CCM traces show the call
failing at the route list because the route list can not route the call.
I deleted both of the above route patterns so there is no LD route patterns.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>A LD call to any area code other
than 217 gets a fast busy after 9.16. A call to 912175551212 gets a fast
busy after all digits are dialed. Again, this is with both route patterns
deleted.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>TAC had me go into SQL Enterprise
Manager and manually delete the route list for the 91217 route pattern.
There were 3 extraneous entries in SQL. After the manual delete, I
recreated the route patterns and route lists and everything worked….For 2
days. The customer went into the 9.1217 route pattern and enabled Feature
Access Codes. After this no calls can be placed to the 217 area code, but
all other long distance calls work.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>I am waiting for TAC to call me
back to manually delete the SQL entries again.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>I am concerned about the condition
of the CCM SQL database. I don’t like that I can replicate a SQL
corruption. </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>My questions for Puck are:</span></font></p>
<p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'><font size=2
face=Symbol><span style='font-size:10.0pt;font-family:Symbol'>·<font size=1
face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></font><font size=2 face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma'>Has any else experienced similar SQL corruptions</span></font></p>
<p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'><font size=2
face=Symbol><span style='font-size:10.0pt;font-family:Symbol'>·<font size=1
face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></font><font size=2 face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma'>Are there tools to verify the condition of the SQL
database</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><b><font size=2 face="Comic Sans MS"><span
style='font-size:11.0pt;font-family:"Comic Sans MS";font-weight:bold'>B</span></font></b><b><font
size=2 face="Comic Sans MS"><span style='font-size:10.0pt;font-family:"Comic Sans MS";
font-weight:bold'>ill </span></font></b><b><font size=2 face="Comic Sans MS"><span
style='font-size:11.0pt;font-family:"Comic Sans MS";font-weight:bold'>C</span></font></b><b><font
size=2 face="Comic Sans MS"><span style='font-size:10.0pt;font-family:"Comic Sans MS";
font-weight:bold'>arter</span></font></b><b><font face="Comic Sans MS"><span
style='font-family:"Comic Sans MS";font-weight:bold'> </span></font><br>
</b><b><font size=1 color="#9b9b00" face="Comic Sans MS"><span
style='font-size:7.5pt;font-family:"Comic Sans MS";color:#9B9B00;font-weight:
bold'>S</span></font></b><em><b><i><font size=1 color=olive face="Comic Sans MS"><span
style='font-size:7.5pt;font-family:"Comic Sans MS";color:olive;font-weight:
bold'>enior Business Communications Analyst</span></font></i></b></em><b><font
size=1 color=olive face="Comic Sans MS"><span style='font-size:7.5pt;
font-family:"Comic Sans MS";color:olive;font-weight:bold'> <br>
<a href="http://www.sentinel.com/" target="_blank"><font size=1 color=olive><span
style='font-size:8.0pt;color:olive;text-decoration:none'>Sentinel Technologies,
Inc.</span></font> </a><br>
</span></font></b><font size=1 color=olive face="Comic Sans MS"><span
style='font-size:8.0pt;font-family:"Comic Sans MS";color:olive'><a
href="mailto:bcarter@sentinel.com">bcarter@-nospam-sentinel.com</a> </span></font><b><font
size=1 color=olive face="Comic Sans MS"><span style='font-size:7.5pt;
font-family:"Comic Sans MS";color:olive;font-weight:bold'><br>
</span></font></b><font size=1 color=black face="Comic Sans MS"><span
style='font-size:8.0pt;font-family:"Comic Sans MS";color:black'>217.391.5015
(W) <br>
800.860.8102 (P) <br>
217.698.9222 (F) </span></font></p>
<div>
<div>
<div class=MsoNormal style='margin-left:.5in'><b><font size=3 color=olive
face=Arial><span style='font-size:12.0pt;color:olive;font-weight:bold'>
<hr size=2 width="65%" align=left>
</span></font></b></div>
</div>
</div>
<p class=MsoNormal style='margin-left:.5in'><b><font size=2 color=olive
face=Arial><span style='font-size:10.0pt;color:olive;font-weight:bold'><a
href="http://newsroom.cisco.com/dlls/partners/news/2004/pr_prod_02-11.html"
target="_blank"><span style='text-decoration:none'>Cisco Systems 2003 Global IP
Communications Partner of the Year</span></a> </span></font></b></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face=Arial><span
style='font-size:12.0pt'> </span></font></p>
</div>
</body>
</html>