[cisco-voip] Anyone seen this issue ?

[Leslie Meade]

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,origLegCal
lIdentifier,dateTimeOrigination,origNodeId,origSpan,origIpAddr,callingPa
rtyNumber,callingPartyLoginUserID,origCause_location,origCause_value,ori
gPrecedenceLevel,origMediaTransportAddress_IP,origMediaTransportAddress_
Port,origMediaCap_payloadCapability,origMediaCap_maxFramesPerPacket,orig
MediaCap_g723BitRate,origVideoCap_Codec,origVideoCap_Bandwidth,origVideo
Cap_Resolution,origVideoTransportAddress_IP,origVideoTransportAddress_Po
rt,destLegIdentifier,destNodeId,destSpan,destIpAddr,originalCalledPartyN
umber,finalCalledPartyNumber,finalCalledPartyLoginUserID,destCause_locat
ion,destCause_value,destPrecedenceLevel,destMediaTransportAddress_IP,des
tMediaTransportAddress_Port,destMediaCap_payloadCapability,destMediaCap_
maxFramesPerPacket,destMediaCap_g723BitRate,destVideoCap_Codec,destVideo
Cap_Bandwidth,destVideoCap_Resolution,destVideoTransportAddress_IP,destV
ideoTransportAddress_Port,dateTimeConnect,dateTimeDisconnect,lastRedirec
tDn,pkid,originalCalledPartyNumberPartition,callingPartyNumberPartition,
finalCalledPartyNumberPartition,lastRedirectDnPartition,duration,origDev
iceName,destDeviceName,origCallTerminationOnBehalfOf,destCallTermination
OnBehalfOf,origCalledPartyRedirectOnBehalfOf,lastRedirectRedirectOnBehal
fOf,origCalledPartyRedirectReason,lastRedirectRedirectReason,destConvers
ationId,globalCallId_ClusterID,joinOnBehalfOf,comment,authCodeDescriptio
n,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','334942
82','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 at 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>

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\CDR\Bad\cdr_StandAloneCluster01042820080959]|<CLID::StandAloneCluster>
<NID::172.16.1.1>

 

 

Leslie Meade  ccna ccvp
Network Administrator

lmeade at signal.ca <mailto: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
www.signal.ca <http://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/3688907e/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1790 bytes
Desc: image001.jpg
Url : https://puck.nether.net/pipermail/cisco-voip/attachments/20080428/3688907e/attachment.jpe 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 1295 bytes
Desc: image002.gif
Url : https://puck.nether.net/pipermail/cisco-voip/attachments/20080428/3688907e/attachment.gif