[cisco-voip] Need help with CDR Reports

[Wes Sisk]

What version of CallManager?

This has been a big hitter recently:

CSCsb99593 CAR 4.1(0.34) stops loading CDRs-Comment col. need to support
2048 chars
<B>Symptom:</B>

Enable CDR in CallManager Service Parameters.  Make calls and the CDR
database is updated with
proper information.  Attempt to run CAR/ART report and receive error:

30023:Data is not available for the date range selected.

The Tbl_error_log table in the ART database will show an entry with the
following information:
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]String
or binary data would be truncated.
DbaDbConnect[executeStoredProc]

<B>Conditions:</B>

-CM 4.1(3)SR1 or any other CM version with CSCsa79287 integrated but without
the fix for this DDTS.
-A CDR with a Comment entry longer than 256 characters (commonly generated
by Conferences).
To verify that this DDTS is causing the issue with records loading, run the
following SQL query (from CDR database):
select max(len(comment)) from calldetailrecord

If that returns a value greater than 256, then this DDTS is the cause of the
CDRs not loading into CAR/ART. When a CDR has more than 256 characters in
the Comment column, it will not load that CDR and will keep all the others
from loading too.

<B>Workaround:</B>

This workaround will permanently fix the issue by expanding the Comment
column in the ART database to the proper size.

1. Stop CAR Scheduler.
2. From Query Analyzer select the 'art' database & run the follwoing sql
commands.

truncate table tbl_billing_data
truncate table tbl_billing_error
truncate table tbl_error_id_map
truncate table tbl_load_history
truncate table tbl_event_log
truncate table tbl_error_log
truncate table tbl_dump_calldetailrecord
truncate table tbl_dump_calldetailrecorddiagnostic
truncate table tbl_dump_pkid

ALTER TABLE Tbl_Billing_Data ALTER COLUMN Comment varchar(2048) NULL
ALTER TABLE Tbl_Billing_Error ALTER COLUMN Comment varchar(2048) NULL
ALTER TABLE Tbl_Dump_CallDetailRecord ALTER COLUMN Comment varchar(2048)
NULL

3. Configure loader to run or take default loader times.
4. Start CAR Scheduler.

/Wes


-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net]On Behalf Of Voll, Scott
Sent: Wednesday, November 09, 2005 9:11 AM
To: Monika Kapil; CiscosupportUpuck
Subject: RE: [cisco-voip] Need help with CDR Reports


How often are you updating the data?  We do it nightly, which makes the
current day unavailable.   Just a guess as I don't know the error code
number.

Scott

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Monika Kapil
Sent: Tuesday, November 08, 2005 10:55 PM
To: CiscosupportUpuck
Subject: [cisco-voip] Need help with CDR Reports

Hi All,

I am facing a problem generating the call reports through cdr analysis
and reporting tool.

I am getting the error: 30023: data is not available for the specified
date range.

Can anyone assist.

Thanks
Monika



Monika Kapil
________________________________

Network Administrator, Information Technology
Evalueserve
Tel: +91 124 251 54400(3122)
www.evalueserve.com


-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of James
Sent: Wednesday, November 09, 2005 11:51 AM
To: CiscosupportUpuck
Subject: [cisco-voip] Need help with cra scripting

I have a script that is running .  But I'm trying to create a db dip.
At this point I'm able to read. Data from the database wth the db read .
What I'm trying to do is a get digit string from callers and then check
it against my db.  If its there in the db then send the caller thru the
script
James D. Grace
System Engineer
CCNP CCNA MCSE MCDBA
Digitel Corp.
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip