[cisco-voip] CCM 3.3(4)SR1 SQL Database corruption

[Carter, Bill]

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.

 

The site has 2 LD route patterns

9.1XXXXXXXXXX

and

9.1217XXXXXXX

 

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

 

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.

 

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.

 

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.

 

I am waiting for TAC to call me back to manually delete the SQL entries
again.

 

I am concerned about the condition of the CCM SQL database.  I don't
like that I can replicate a SQL corruption.  

My questions for Puck are:

*	Has any else experienced similar SQL corruptions
*	Are there tools to verify the condition of the SQL database

 

Bill Carter 
Senior Business Communications Analyst 
Sentinel Technologies, Inc. <http://www.sentinel.com/> 
bcarter at -nospam-sentinel.com <mailto:bcarter at sentinel.com>  
217.391.5015 (W) 
800.860.8102 (P) 
217.698.9222 (F) 

  _____  

Cisco Systems 2003 Global IP Communications Partner of the Year
<http://newsroom.cisco.com/dlls/partners/news/2004/pr_prod_02-11.html>  

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20040826/8e79051a/attachment.html