<html><head><style type="text/css"><!-- DIV {margin:0px} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">Any other workarounds to this CMR bug below, besides stopping CDR Insert until a upgrade to 4.2(3) can be done? Seeing this issue where the regsvc.exe service spikes CPU while CDRInsert is trying to insert CMR file which is causing call processing delays, etc. Tried the manual workaround below but the field already exists in the database and table and field properties are correct. <br><br><font color="#0000ff" face="Arial" size="2">Event Type: Error<br>Event
Source: Cisco Anonymous Alarms<br>Event Category: None<br>Event
ID: 3<br>Date: 9/11/2006<br>Time: 8:49:34
AM<br>User: N/A<br>Computer: CMPUB<br>Description:<br>Error:
UNKNOWN_ALARM:kErrorInsertingCDR<br> Error: Error executing "insert into
CallDetailRecordDiagnostic
(cdrRecordType,globalCallID_callManagerId,globalCallID_callId,nodeId,dire<br>
File: <a target="_blank" id="bodyLinks" rel="nofollow">\\CMPUB\CDR\CMR\cmr_CMPUB-Cluster01091120060848</a><br>
ErrorCode: 207<br> State: 42S22<br>. <br><br></font><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Wes Sisk <wsisk@cisco.com><br>To: Robin Inderberg <robin.inderberg@candidator.se><br>Cc: cisco-voip@puck.nether.net<br>Sent: Thursday, August 31, 2006 10:02:01 PM<br>Subject: Re: [cisco-voip] Version Stability Opinions<br><br>
For anyone upgrading from 4.1 to 4.2(1) please be aware of <br>
CSCse68968 CMR files not inserted into DB on upgrade from 4.1 to 4.2<br>
<br>
Calldetailrecorddiagnostics did not get updated with a field it
requires during upgrade. Workaround:<br>
• Stop insertCDR Service <br>
• Through Enterprise manager or Query analyzer, execute on CDR
database <br>
ALTER TABLE CallDetailRecordDiagnostic ADD varVQMetrics varchar(600)
DEFAULT NULL NULL <br>
• In CDR file location, move CMR_xxxxxxx files in BAD folder to CMR
folder <br>
• Start insertCDR Service <br>
<br>
This is only resolved via this manual workaround or with CM 4.2(3)
which just posted to Cisco.com tonight.<br>
<br>
/Wes<br>
<br>
Robin Inderberg wrote:
<blockquote type="cite">
<style>
<!--
_filtered {font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{
margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{
font-family:Arial;
color:navy;}
_filtered {
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Hi Duncan,</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">We are
running CCM 4.2(1)sr1b and Cisco
Unity 4.0(5), and we are not expericen any problems at all.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">The only
problem we found now were on the
upgrade to 4.2(1)sr1b, and Cisco Unity did Crash… So a restart after
this
one, everything worked well again.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">And some
more problem is the bug in Cisco
7920 with 3.0 and the HLOG function, it doesn’t work at all. The
softkey
is removed.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">And in 2.01
it shows wrong when you have
loged in and loged out from a hlog… </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">I don’t know
if it is CCM 4.2, or if
it is my setup, but the SIP trunk, after installing CCM 4.2 don’t work
very well.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">The MRM
seems to have some problems,
atleast is it what I have localised the problem too. </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Is this a
problem anyone else has?</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">If anyone is
interrested in the debugs
from it, I have them right here. </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Hope you got
any information that could be
valuable for you Duncan .
</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<div>
<p class="MsoPlainText"><font color="navy" face="Courier New" size="2"><span style="font-size: 10pt; color: navy;" lang="SV">Med vänliga
hälsningar/Best Regards</span></font></p>
<p class="MsoPlainText"><font color="navy" face="Courier New" size="2"><span style="font-size: 10pt; color: navy;" lang="SV"> </span></font></p>
<p class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt;">
<font color="navy"><span style="color: navy;" lang="SV">Robin Inderberg</span></font></span></font><font color="silver" face="Courier New" size="2"><span style="font-size: 10pt; color: silver;"></span></font></p>
</div>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr tabindex="-1" align="center" size="2" width="100%"></span></font></div>
<p class="MsoNormal"><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">
<a id="bodyLinks" rel="nofollow" class="moz-txt-link-abbreviated" target="_blank" href="mailto:cisco-voip-bounces@puck.nether.net">cisco-voip-bounces@puck.nether.net</a>
[<a id="bodyLinks" rel="nofollow" class="moz-txt-link-freetext" target="_blank" href="mailto:cisco-voip-bounces@puck.nether.net">mailto:cisco-voip-bounces@puck.nether.net</a>] <b><span style="font-weight: bold;">On Behalf Of </span></b>DUNCAN, WILLIAM B.<br>
<b><span style="font-weight: bold;">Sent:</span></b> den 31 augusti
2006 18:58<br>
<b><span style="font-weight: bold;">To:</span></b>
<a id="bodyLinks" rel="nofollow" class="moz-txt-link-abbreviated" target="_blank" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> [cisco-voip]
Version
Stability Opinions</span></font></p>
</div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I was interested in what
you all thought were currently the
best versions of CCM and Unity from a stability standpoint. We are
running CCM 4.13 and Unity 4.04 BTW. </span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Thanks,</span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Brian Duncan</span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Coordinator of
Telecommunications</span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Ozarks</span></font><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Technical
Community College</span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
<pre><hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a id="bodyLinks" rel="nofollow" class="moz-txt-link-abbreviated" target="_blank" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a id="bodyLinks" rel="nofollow" class="moz-txt-link-freetext" target="_blank" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
<div>_______________________________________________<br>cisco-voip mailing list<br>cisco-voip@puck.nether.net<br><a target="_blank" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br></div></div><br></div></div></body></html>