<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:st1="urn:schemas-microsoft-com:office:smarttags" 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 11 (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]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 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";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>fter an upgrade from 4.2.1 ES 37 to 4.2.3 SR3a CDR data is
no longer inserted into the database. CDR records are successfully transfered
from the subscriber to the publisher, but are then put into the "BAD"
directory.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The following error shows up in the CDR service trace:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>04/28/2008 10:11:44.955 CDR|-->CMonitor::InsertRecord
Error |<CLID::StandAloneCluster><NID::172.16.1.1><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>04/28/2008 10:11:44.955 CDR| CMonitor::InsertRecord Error
*ERROR* Insert failed S [21S01] E [d5]|<CLID::StandAloneCluster><NID::172.16.1.1><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>04/28/2008 10:11:44.955 CDR|Error executing "insert
into CallDetailRecord
(cdrRecordType,globalCallID_callManagerId,globalCallID_callId,origLegCallIdentifier,dateTimeOrigination,origNodeId,origSpan,origIpAddr,callingPartyNumber,callingPartyLoginUserID,origCause_location,origCause_value,origPrecedenceLevel,origMediaTransportAddress_IP,origMediaTransportAddress_Port,origMediaCap_payloadCapability,origMediaCap_maxFramesPerPacket,origMediaCap_g723BitRate,origVideoCap_Codec,origVideoCap_Bandwidth,origVideoCap_Resolution,origVideoTransportAddress_IP,origVideoTransportAddress_Port,destLegIdentifier,destNodeId,destSpan,destIpAddr,originalCalledPartyNumber,finalCalledPartyNumber,finalCalledPartyLoginUserID,destCause_location,destCause_value,destPrecedenceLevel,destMediaTransportAddress_IP,destMediaTransportAddress_Port,destMediaCap_payloadCapability,destMediaCap_maxFramesPerPacket,destMediaCap_g723BitRate,destVideoCap_Codec,destVideoCap_Bandwidth,destVideoCap_Resolution,destVideoTransportAddress_IP,destVideoTransportAddress_Port,dateTimeConnect,dateTimeDisconnect,lastRedirectDn,pkid,originalCalledPartyNumberPartition,callingPartyNumberPartition,finalCalledPartyNumberPartition,lastRedirectDnPartition,duration,origDeviceName,destDeviceName,origCallTerminationOnBehalfOf,destCallTerminationOnBehalfOf,origCalledPartyRedirectOnBehalfOf,lastRedirectRedirectOnBehalfOf,origCalledPartyRedirectReason,lastRedirectRedirectReason,destConversationId,globalCallId_ClusterID,joinOnBehalfOf,comment,authCodeDescription,authorizationLevel,clientMatterCode,origConversationId)
VALUES
('1','1','3018','16777252','1209401924','1','0','889328906','5483','','0','0','4','889328906','26400','4','20','0','0','0','0','0','0','16777253','2','21','-33554678','6042995566','6042995566','','0','16','4','33494282','17314','4','20','0','0','0','0','0','0','1209401934','1209401978','6042995566','{F4B3F461-BB56-4902-A79F-DF5DC8DB0F84}','VBOT','VBOT','VBOT','VBOT','44','SEP001B2A899E21','S0/SU2/DS1-0@VBOT-2821-01.signal.ca',0,12,0,0,'0','0','0','StandAloneCluster',0,'','','0','','0')":
[Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or
number of supplied values does not match table
definition.|<CLID::StandAloneCluster><NID::172.16.1.1><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>04/28/2008 10:11:44.955 CDR|<--CMonitor::InsertRecord
Error |<CLID::StandAloneCluster><NID::172.16.1.1><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>04/28/2008 10:11:44.955 CDR| CMonitor::ConvertFile 1
records in 0 ms|<CLID::StandAloneCluster><NID::172.16.1.1><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>04/28/2008 10:11:44.955 CDR| CMonitor::ConvertFile Moving
[\\172.16.1.1\CDR\CDR\cdr_StandAloneCluster01042820080959]->[\\172.16.1.1\CDR\Bad\cdr_StandAloneCluster01042820080959]|<CLID::StandAloneCluster><NID::172.16.1.1><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=343
style='width:257.25pt'>
<tr height=95 style='height:70.9pt'>
<td nowrap height=95 valign=top style='padding:0in 0in 11.25pt .25in;
height:70.9pt'>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:115%'><st1:PersonName w:st="on"><b><font size=1 color="#666666"
face=Arial><span style='font-size:8.5pt;line-height:115%;font-family:Arial;
color:#666666;font-weight:bold'>Leslie Meade</span></font></b></st1:PersonName><b><font
size=1 color="#666666" face=Arial><span style='font-size:8.5pt;line-height:
115%;font-family:Arial;color:#666666;font-weight:bold'> </span></font></b><b><font
size=1 color="#548dd4" face=Arial><span style='font-size:8.0pt;line-height:
115%;font-family:Arial;color:#548DD4;font-weight:bold'>ccna ccvp</span></font></b><font
size=1 color="#666666" face=Arial><span style='font-size:8.5pt;line-height:
115%;font-family:Arial;color:#666666'><br>
<b><span style='font-weight:bold'>Network Administrator</span></b><br>
<br>
<a href="mailto:lmeade@signal.ca" title="mailto:lmeade@signal.ca"><font
color="#666666"><span style='color:#666666'><span
title="mailto:lmeade@signal.ca">lmeade@signal.ca</span></span></font></a><br>
IP Phone :<b><span style='font-weight:bold'>604-453-5076</span></b><br>
<st1:City w:st="on"><st1:place w:st="on">Mobile</st1:place></st1:City>
:<b><span style='font-weight:bold'>778-228-4339</span></b><br>
IPFax :<b><span style='font-weight:
bold'>604-453-5051</span></b><o:p></o:p></span></font></p>
</td>
<td nowrap height=95 valign=top style='padding:0in 0in 7.5pt 15.0pt;
height:70.9pt'>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:115%'><font size=1 color="#666666" face=Arial><span
style='font-size:8.5pt;line-height:115%;font-family:Arial;color:#666666'><br>
Building X - <st1:address w:st="on"><st1:Street w:st="on">3500 Cornett Road</st1:Street></st1:address><br>
<st1:place w:st="on"><st1:City w:st="on">Vancouver</st1:City>, <st1:State
w:st="on">BC</st1:State></st1:place><br>
<st1:PostalCode w:st="on">V5M 2H5</st1:PostalCode><br>
<st1:place w:st="on"><st1:country-region w:st="on">Canada</st1:country-region></st1:place><br>
<a href="http://www.signal.ca/" title="http://www.signal.ca/"><font
color="#666666"><span style='color:#666666'><span
title="http://www.signal.ca/">www.signal.ca</span></span></font></a><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td colspan=2 style='padding:12.0pt .25in 4.5pt .25in'>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Calibri><span style='font-size:11.0pt;font-family:Calibri'><a
href="http://www.signal.ca/" target="_blank" title="http://www.signal.ca/"></a><img
border=0 width=79 height=45 id="_x0000_i1025"
src="cid:image001.jpg@01C8A940.63EF5710"><img border=0 width=63 height=52
id="_x0000_i1026" src="cid:image002.gif@01C8A940.63EF5710"></span></font><font
size=1 color="#999999" face=Arial><span style='font-size:7.5pt;font-family:
Arial;color:#999999'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=1 color="#999999" face=Arial><span style='font-size:7.5pt;font-family:
Arial;color:#999999'>This e-mail may contain confidential and privileged
material for the sole use of the intended recipient. Any review, use,
distribution or disclosure by others is strictly prohibited. If you are not
the intended recipient (or authorized to receive for the recipient), please
contact the sender by reply e-mail and delete all copies of this message.<o:p></o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>