CDR ServerDown -- bad CDR records in flat file
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > WebserverTalk Community > Voice Over IP > Voice over IP Cisco > CDR ServerDown -- bad CDR records in flat file




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    CDR ServerDown -- bad CDR records in flat file  
Erick Bergquist


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
01-20-07 12:12 AM

Hi,

I have a CCM 3.3(4)sr2 client and getting CDRServerDown error now and then, 
and have traced it to the CDR flat files and entries for Call Control on VG2
48 ports. Example records are below. If I remove these from the flat file an
d drop file back in CDR fol
der it inserts fine without problem.

There is a garbage character (little square thing) in field where number sho
uld be or blank sometimes.

I haven't found a bug on this, so was wondering if anyone seen this and know
s how to correct these records or if it is a bug.

 1,2,2258477,39778790,1167882982,2,0,3038
83018,"55512",0,1,0,0,0,0,0,0,0,
0,0,"","",0,0,0,0,0,0,0,0,1167882997,"","{8C8D88E7-8C09-4BAB-9E6E-E9C5B
E
8ECCE6}","","Line-1-Internal-Part","","",0,"VGC0f3cb2a8ac16","","Call
Control","","","",0,0,0,"StandAloneCluster","","",0,""






 ________________________________________
____________________________________
________
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com...mail_tools.html





[ Post a follow-up to this message ]



    Re: CDR ServerDown -- bad CDR records in flat file  
Wes Sisk


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
01-20-07 06:11 PM

Erick,

Square character did not come through.  Either import the 'bad' file
to Excel with headers to identify which column has bad value or send
me the raw text file.

/Wes

On Jan 19, 2007, at 5:26 PM, Erick Bergquist wrote:

Hi,

I have a CCM 3.3(4)sr2 client and getting CDRServerDown error now and
then, and have traced it to the CDR flat files and entries for Call
Control on VG248 ports. Example records are below. If I remove these
from the flat file and drop file back in CDR folder it inserts fine
without problem.

There is a garbage character (little square thing) in field where
number should be or blank sometimes.

I haven't found a bug on this, so was wondering if anyone seen this
and knows how to correct these records or if it is a bug.

 1,2,2258477,39778790,1167882982,2,0,3038
83018,"55512",0,1,0,0,0,0,0,0,0,
0,0,"","",0,0,0,0,0,0,0,0,1167882997,"","{8C8D88E7-8C09-4BAB-9E6E-E9C5B
E
8ECCE6}","","Line-1-Internal-Part","","",0,"VGC0f3cb2a8ac16","","Call
Control","","","",0,0,0,"StandAloneCluster","","",0,""






 ________________________________________
________________________________
____________
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com...mail_tools.html

 ________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip





[ Post a follow-up to this message ]



    Re: CDR ServerDown -- bad CDR records in flat file  
Erick Bergquist


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
01-21-07 12:12 AM

There seems to be 3 fields with the same garbage character in the bad flat f
iles.

The first field with bad character is originalCalledPartyNumber, then finalC
alledPartyNumber, then the lastRedirectDn field.

All these entries are Call Control entries for VG248 ports.
Excel doesn't seem to show the character, just a blank field.

I'll send you the original raw cdr file.

Thanks

----- Original Message ----
From: Wes Sisk <wsisk@cisco.com>
To: Erick Bergquist <erickbe@yahoo.com>
Cc: ciscovoip <cisco-voip@puck.nether.net>
Sent: Saturday, January 20, 2007 1:04:25 PM
Subject: Re: [cisco-voip] CDR ServerDown -- bad CDR records in flat file

Erick,

Square character did not come through.  Either import the 'bad' file
to Excel with headers to identify which column has bad value or send
me the raw text file.

/Wes

On Jan 19, 2007, at 5:26 PM, Erick Bergquist wrote:

Hi,

I have a CCM 3.3(4)sr2 client and getting CDRServerDown error now and
then, and have traced it to the CDR flat files and entries for Call
Control on VG248 ports. Example records are below. If I remove these
from the flat file and drop file back in CDR folder it inserts fine
without problem.

There is a garbage character (little square thing) in field where
number should be or blank sometimes.

I haven't found a bug on this, so was wondering if anyone seen this
and knows how to correct these records or if it is a bug.

 1,2,2258477,39778790,1167882982,2,0,3038
83018,"55512",0,1,0,0,0,0,0,0,0,
0,0,"","",0,0,0,0,0,0,0,0,1167882997,"","{8C8D88E7-8C09-4BAB-9E6E-E9C5B
E
8ECCE6}","","Line-1-Internal-Part","","",0,"VGC0f3cb2a8ac16","","Call
Control","","","",0,0,0,"StandAloneCluster","","",0,""






 ________________________________________
________________________________
____________
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com...mail_tools.html

 ________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip







 ________________________________________
____________________________________
________
Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games.
http://games.yahoo.com/games/front





[ Post a follow-up to this message ]



    Re: CDR ServerDown -- bad CDR records in flat file  
Wes Sisk


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
01-21-07 12:12 AM

Erick,

Problem is the
 lastredirectdn,originalcalledpartynumber
,finalcalledpartynumber
contains invalid character (0x0D).
CSCsc50551 is the closest I can find.  It was found & integrated in
CM4.x

A TAC case escalated to development could possibly get a closer
source code review to see if there is fix anywhere in 3.x

/Wes

On Jan 20, 2007, at 3:05 PM, Erick Bergquist wrote:

----- Original Message ----
From: Wes Sisk <wsisk@cisco.com>
To: Erick Bergquist <erickbe@yahoo.com>
Cc: ciscovoip <cisco-voip@puck.nether.net>
Sent: Saturday, January 20, 2007 1:04:25 PM
Subject: Re: [cisco-voip] CDR ServerDown -- bad CDR records in flat file

Erick,

Square character did not come through.  Either import the 'bad' file
to Excel with headers to identify which column has bad value or send
me the raw text file.

/Wes

On Jan 19, 2007, at 5:26 PM, Erick Bergquist wrote:

Hi,

I have a CCM 3.3(4)sr2 client and getting CDRServerDown error now and
then, and have traced it to the CDR flat files and entries for Call
Control on VG248 ports. Example records are below. If I remove these
from the flat file and drop file back in CDR folder it inserts fine
without problem.

There is a garbage character (little square thing) in field where
number should be or blank sometimes.

I haven't found a bug on this, so was wondering if anyone seen this
and knows how to correct these records or if it is a bug.

 1,2,2258477,39778790,1167882982,2,0,3038
83018,"55512",0,1,0,0,0,0,0,0,0,
0,0,"","",0,0,0,0,0,0,0,0,1167882997,"","{8C8D88E7-8C09-4BAB-9E6E-E9C5B
E
8ECCE6}","","Line-1-Internal-Part","","",0,"VGC0f3cb2a8ac16","","Call
Control","","","",0,0,0,"StandAloneCluster","","",0,""






 ________________________________________
________________________________
____________
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com...mail_tools.html

 ________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip







 ________________________________________
________________________________
____________
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail
<cdr-ServerDown.zip>





[ Post a follow-up to this message ]



    Re: CDR ServerDown -- bad CDR records in flat file  
Erick Bergquist


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
01-21-07 06:11 AM

Wes,

Thanks for looking into that. I'll open a case to get it checked out further
.

----- Original Message ----
From: Wes Sisk <wsisk@cisco.com>
To: Erick Bergquist <erickbe@yahoo.com>
Cc: "cisco-voip@puck-nether.net Voip" <cisco-voip@puck.nether.net>
Sent: Saturday, January 20, 2007 4:21:36 PM
Subject: Re: [cisco-voip] CDR ServerDown -- bad CDR records in flat file

Erick,

Problem is the
 lastredirectdn,originalcalledpartynumber
,finalcalledpartynumber
contains invalid character (0x0D).
CSCsc50551 is the closest I can find.  It was found & integrated in
CM4.x

A TAC case escalated to development could possibly get a closer
source code review to see if there is fix anywhere in 3.x

/Wes

On Jan 20, 2007, at 3:05 PM, Erick Bergquist wrote:

----- Original Message ----
From: Wes Sisk <wsisk@cisco.com>
To: Erick Bergquist <erickbe@yahoo.com>
Cc: ciscovoip <cisco-voip@puck.nether.net>
Sent: Saturday, January 20, 2007 1:04:25 PM
Subject: Re: [cisco-voip] CDR ServerDown -- bad CDR records in flat file

Erick,

Square character did not come through.  Either import the 'bad' file
to Excel with headers to identify which column has bad value or send
me the raw text file.

/Wes

On Jan 19, 2007, at 5:26 PM, Erick Bergquist wrote:

Hi,

I have a CCM 3.3(4)sr2 client and getting CDRServerDown error now and
then, and have traced it to the CDR flat files and entries for Call
Control on VG248 ports. Example records are below. If I remove these
from the flat file and drop file back in CDR folder it inserts fine
without problem.

There is a garbage character (little square thing) in field where
number should be or blank sometimes.

I haven't found a bug on this, so was wondering if anyone seen this
and knows how to correct these records or if it is a bug.

 1,2,2258477,39778790,1167882982,2,0,3038
83018,"55512",0,1,0,0,0,0,0,0,0,
0,0,"","",0,0,0,0,0,0,0,0,1167882997,"","{8C8D88E7-8C09-4BAB-9E6E-E9C5B
E
8ECCE6}","","Line-1-Internal-Part","","",0,"VGC0f3cb2a8ac16","","Call
Control","","","",0,0,0,"StandAloneCluster","","",0,""






 ________________________________________
________________________________
____________
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com...mail_tools.html

 ________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip







 ________________________________________
________________________________
____________
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail
<cdr-ServerDown.zip>









 ________________________________________
____________________________________
________
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL





[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 01:45 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register