[cisco-voip] Anyone seen this issue ?

Mon Apr 28 20:37:55 EDT 2008

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:
cdrRecordType,globalCallID_callManagerId,globalCallID_callId,origLegCallIden
tifier,dateTimeOrigination,origNodeId,origSpan,origIpAddr,callingPartyNumber
,callingPartyLoginUserID,origCause_location,origCause_value,origPrecedenceLe
vel,origMediaTransportAddress_IP,origMediaTransportAddress_Port,origMediaCap
_payloadCapability,origMediaCap_maxFramesPerPacket,origMediaCap_g723BitRate,
origVideoCap_Codec,origVideoCap_Bandwidth,origVideoCap_Resolution,origVideoT
ransportAddress_IP,origVideoTransportAddress_Port,destLegIdentifier,destNode
Id,destSpan,destIpAddr,originalCalledPartyNumber,finalCalledPartyNumber,fina
lCalledPartyLoginUserID,destCause_location,destCause_value,destPrecedenceLev
el,destMediaTransportAddress_IP,destMediaTransportAddress_Port,destMediaCap_
payloadCapability,destMediaCap_maxFramesPerPacket,destMediaCap_g723BitRate,d
estVideoCap_Codec,destVideoCap_Bandwidth,destVideoCap_Resolution,destVideoTr
ansportAddress_IP,destVideoTransportAddress_Port,dateTimeConnect,dateTimeDis
connect,lastRedirectDn,pkid,originalCalledPartyNumberPartition,callingPartyN
umberPartition,finalCalledPartyNumberPartition,lastRedirectDnPartition,durat
ion,origDeviceName,destDeviceName,origCallTerminationOnBehalfOf,destCallTerm
inationOnBehalfOf,origCalledPartyRedirectOnBehalfOf,lastRedirectRedirectOnBe
halfOf,origCalledPartyRedirectReason,lastRedirectRedirectReason,destConversa
tionId,globalCallId_ClusterID,joinOnBehalfOf,comment,authCodeDescription,aut
horizationLevel,clientMatterCode,origConversationId

Most likely you'll want to open a TAC SR once you find out which is missing.

-Ryan 

  _____  

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Leslie Meade
Sent: Monday, April 28, 2008 5:59 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Anyone seen this issue ?

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.

The following error shows up in the CDR service trace:

04/28/2008 10:11:44.955 CDR|-->CMonitor::InsertRecord Error
|<CLID::StandAloneCluster><NID::172.16.1.1>

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>

04/28/2008 10:11:44.955 CDR|Error executing "insert into CallDetailRecord
(cdrRecordType,globalCallID_callManagerId,globalCallID_callId,origLegCallIde
ntifier,dateTimeOrigination,origNodeId,origSpan,origIpAddr,callingPartyNumbe
r,callingPartyLoginUserID,origCause_location,origCause_value,origPrecedenceL
evel,origMediaTransportAddress_IP,origMediaTransportAddress_Port,origMediaCa
p_payloadCapability,origMediaCap_maxFramesPerPacket,origMediaCap_g723BitRate
,origVideoCap_Codec,origVideoCap_Bandwidth,origVideoCap_Resolution,origVideo
TransportAddress_IP,origVideoTransportAddress_Port,destLegIdentifier,destNod
eId,destSpan,destIpAddr,originalCalledPartyNumber,finalCalledPartyNumber,fin
alCalledPartyLoginUserID,destCause_location,destCause_value,destPrecedenceLe
vel,destMediaTransportAddress_IP,destMediaTransportAddress_Port,destMediaCap
_payloadCapability,destMediaCap_maxFramesPerPacket,destMediaCap_g723BitRate,
destVideoCap_Codec,destVideoCap_Bandwidth,destVideoCap_Resolution,destVideoT
ransportAddress_IP,destVideoTransportAddress_Port,dateTimeConnect,dateTimeDi
sconnect,lastRedirectDn,pkid,originalCalledPartyNumberPartition,callingParty
NumberPartition,finalCalledPartyNumberPartition,lastRedirectDnPartition,dura
tion,origDeviceName,destDeviceName,origCallTerminationOnBehalfOf,destCallTer
minationOnBehalfOf,origCalledPartyRedirectOnBehalfOf,lastRedirectRedirectOnB
ehalfOf,origCalledPartyRedirectReason,lastRedirectRedirectReason,destConvers
ationId,globalCallId_ClusterID,joinOnBehalfOf,comment,authCodeDescription,au
thorizationLevel,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','2
1','-33554678','6042995566','6042995566','','0','16','4','33494282','17314',
'4','20','0','0','0','0','0','0','1209401934','1209401978','6042995566','{F4
B3F461-BB56-4902-A79F-DF5DC8DB0F84}','VBOT','VBOT','VBOT','VBOT','44','SEP00
1B2A899E21','S0/SU2/DS1-0 at VBOT-2821-01.signal.ca',0,12,0,0,'0','0','0','Stan
dAloneCluster',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>

04/28/2008 10:11:44.955 CDR|<--CMonitor::InsertRecord Error
|<CLID::StandAloneCluster><NID::172.16.1.1>

04/28/2008 10:11:44.955 CDR|   CMonitor::ConvertFile 1 records in 0
ms|<CLID::StandAloneCluster><NID::172.16.1.1>

04/28/2008 10:11:44.955 CDR|   CMonitor::ConvertFile Moving
[\\172.16.1.1\CDR\CDR\cdr_StandAloneCluster01042820080959]->[\\172.16.1.1\CD
R\Bad\cdr_StandAloneCluster01042820080959]|<CLID::StandAloneCluster><NID::17
2.16.1.1>

Leslie Meade  ccna ccvp
Network Administrator

 <mailto:lmeade at signal.ca> lmeade at signal.ca
IP Phone :604-453-5076
Mobile     :778-228-4339
IPFax       :604-453-5051

Building X - 3500 Cornett Road
Vancouver, BC
V5M 2H5
Canada
 <http://www.signal.ca/> www.signal.ca

 <http://www.signal.ca/> 

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20080428/5c7b6a66/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1790 bytes
Desc: not available
Url : https://puck.nether.net/pipermail/cisco-voip/attachments/20080428/5c7b6a66/attachment-0001.jpe 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 1295 bytes
Desc: not available
Url : https://puck.nether.net/pipermail/cisco-voip/attachments/20080428/5c7b6a66/attachment-0001.gif 