<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3314" name=GENERATOR><!--[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 name="country-region"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PostalCode"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="State"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="Street"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="address"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PersonName"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Calibri;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=515473600-29042008><FONT face=Arial
color=#0000ff size=2>Go into SQL Enterprise Manager and double click on the
calldetailrecord table of the CDR database. Make sure all of the following
columns are there:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=515473600-29042008><FONT face=Arial
size=2>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</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=515473600-29042008><FONT face=Arial color=#0000ff size=2>Most
likely you'll want to open a TAC SR once you find out which is
missing.</FONT></SPAN></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>-Ryan </FONT></P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of </B>Leslie
Meade<BR><B>Sent:</B> Monday, April 28, 2008 5:59 PM<BR><B>To:</B>
cisco-voip@puck.nether.net<BR><B>Subject:</B> [cisco-voip] Anyone seen this
issue ?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The following error shows up in the
CDR service trace:<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<TABLE class=MsoNormalTable style="WIDTH: 257.25pt" cellSpacing=0 cellPadding=0
width=343 border=0>
<TBODY>
<TR style="HEIGHT: 70.9pt" height=95>
<TD
style="PADDING-RIGHT: 0in; PADDING-LEFT: 0.25in; PADDING-BOTTOM: 11.25pt; PADDING-TOP: 0in; HEIGHT: 70.9pt"
vAlign=top noWrap height=95>
<P class=MsoNormal
style="LINE-HEIGHT: 115%; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><st1:PersonName
w:st="on"><B><FONT face=Arial color=#666666 size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 8.5pt; COLOR: #666666; LINE-HEIGHT: 115%; FONT-FAMILY: Arial">Leslie
Meade</SPAN></FONT></B></st1:PersonName><B><FONT face=Arial color=#666666
size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 8.5pt; COLOR: #666666; LINE-HEIGHT: 115%; FONT-FAMILY: Arial">
</SPAN></FONT></B><B><FONT face=Arial color=#548dd4 size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #548dd4; LINE-HEIGHT: 115%; FONT-FAMILY: Arial">ccna
ccvp</SPAN></FONT></B><FONT face=Arial color=#666666 size=1><SPAN
style="FONT-SIZE: 8.5pt; COLOR: #666666; LINE-HEIGHT: 115%; FONT-FAMILY: Arial"><BR><B><SPAN
style="FONT-WEIGHT: bold">Network Administrator</SPAN></B><BR><BR><A
title=mailto:lmeade@signal.ca href="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
style="PADDING-RIGHT: 0in; PADDING-LEFT: 15pt; PADDING-BOTTOM: 7.5pt; PADDING-TOP: 0in; HEIGHT: 70.9pt"
vAlign=top noWrap height=95>
<P class=MsoNormal
style="LINE-HEIGHT: 115%; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><FONT
face=Arial color=#666666 size=1><SPAN
style="FONT-SIZE: 8.5pt; COLOR: #666666; LINE-HEIGHT: 115%; FONT-FAMILY: Arial"><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
title=http://www.signal.ca/ href="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
style="PADDING-RIGHT: 0.25in; PADDING-LEFT: 0.25in; PADDING-BOTTOM: 4.5pt; PADDING-TOP: 12pt"
colSpan=2>
<P class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><FONT
face=Calibri size=2><SPAN style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri"><A
title=http://www.signal.ca/ href="http://www.signal.ca/"
target=_blank></A><IMG id=_x0000_i1025 height=45
src="cid:515473600@29042008-32C1" width=79 border=0><IMG id=_x0000_i1026
height=52 src="cid:515473600@29042008-32C8" width=63
border=0></SPAN></FONT><FONT face=Arial color=#999999 size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: #999999; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><FONT
face=Arial color=#999999 size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: #999999; FONT-FAMILY: Arial">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></TBODY></TABLE>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P></DIV></BODY></HTML>