Voice over IP Cisco - CDR ServerDown -- bad CDR records in flat file

This is Interesting: Free IT Magazines  
Home > Archive > Voice over IP Cisco > January 2007 > CDR ServerDown -- bad CDR records in flat file





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

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

2007-01-19, 7:12 pm

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 fol
der 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-E9C5BE
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
Wes Sisk

2007-01-20, 1: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-E9C5BE
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
Erick Bergquist

2007-01-20, 7:12 pm

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

The first field with bad character is originalCalledPartyNumber, then finalCalledPartyNumber, 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-E9C5BE
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
Wes Sisk

2007-01-20, 7:12 pm

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-E9C5BE
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>
Erick Bergquist

2007-01-21, 1: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-E9C5BE
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
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com