<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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;}
@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 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><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font></p>
<p class=MsoNormal><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><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>9.1XXXXXXXXXX</span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>and</span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>9.1217XXXXXXX</span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font></p>
<p class=MsoNormal><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><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font></p>
<p class=MsoNormal><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><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font></p>
<p class=MsoNormal><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><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font></p>
<p class=MsoNormal><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><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font></p>
<p class=MsoNormal><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><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font></p>
<p class=MsoNormal><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><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>My questions for Puck are:</span></font></p>
<ul type=disc>
<li class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>Has any else experienced similar SQL corruptions</span></font></li>
<li class=MsoNormal><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></li>
</ul>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font></p>
<p class=MsoNormal><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></span></font></b><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=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 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><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>
<p class=MsoNormal><font size=3 face=Arial><span style='font-size:12.0pt'> </span></font></p>
</div>
</body>
</html>