[cisco-voip] Call Manager CDR's

[Brandon Peyton]

I rechecked everything as described by everyone:

CCM Service Parameter CDR = TRUE
CDR Insert Service = Activated
Cisco CDR Analysis and Reporting Scheduler = Running

Nothing in c:\program files\cisco\calldetail 
However the share still exists.

In the DB itself we're not close to the 2M limit.

There are no flat files being generated.  No SQL errors in the application
log

The closest thing to an error in the CCM traces are:
04/28/2005 16:28:33.944 CCM|ConnectionManager - storeMediaInfo(16824095):
EXISTING ENTRY DISCOVERED, tail ==
36|<CLID::StandAloneCluster><NID::10.3.4.10><CT::1,100,105,1.2266547><IP::10
.3.4.38><DEV::SEP001201278F7A>
04/28/2005 16:28:33.944 CCM|ConnectionManager - storeMediaInfo(16824102):
EXISTING ENTRY DISCOVERED, tail ==
36|<CLID::StandAloneCluster><NID::10.3.4.10><CT::1,100,105,1.2266547><IP::10
.3.4.38><DEV::SEP001201278F7A>

However I did look at the logs within CAR and I saw this error.  I followed
each of these steps outlined in the error and everything checks out.

Database Access Error. Perform the following checks 1. Database server is
running. 2. Check that a DSN of the name specifed in the url field of
C:/ciscowebs/art/art.ini exists. If the DSN does not exist, create a DSN
with the name in c:/ciscowebs/art/art.ini which points to the server where
the art database exists. Test the ART DSN to verify that there are no
connection problems. 3. Check that a database of the name specified in the
database field of C:/ciscowebs/art/art.ini exists on the server to which the
DSN points. If these are not the same, change the database field in
C:/ciscowebs/art/art.ini to the database name.

Anything else to look for, obviously it has some DB access issues somehow? 

Brandon

-----Original Message-----
From: Ryan Ratliff [mailto:rratliff at cisco.com] 
Sent: Thursday, April 28, 2005 3:28 PM
To: Brandon Peyton
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Call Manager CDR's

Things to check (some of which you may have already done):
CCM Service Parameter CDR Enabled true on every node?
CDR Insert service activated on the Publisher (should not be activated on
any server but the publisher)?
c:\program files\cisco\calldetail folder hasn't had its share removed for
some reason?
How many rows are in the CallDetailRecord table in your CDR database
currently?  The limit should be around 2 million.
Errors in the app log for CDR Insert?

Basically it comes down to two things.  If CDR flat files are accumulating
in the calldetail\CDR folder then CDR Insert can't put them into SQL for
some reason.
If they aren't even getting there then the CCM process isn't writing them or
can't write them.

CCM traces should show you the CDR data being written at the end of each
call.  I don't know where the errors would accumulate if it wasn't able to
write to the CallDetail folder for some reason.

HTH

-Ryan
On Apr 28, 2005, at 3:05 PM, Brandon Peyton wrote:

Hopefully a quick question.
 
I'm running 4.0.2a SR1.  I've been trying to do some CDR analysis.  All
CDR's are supposed to be going into SQL.  But when trying to query the DB, I
only find data several months ago and it hasn't updated since.
 The SQL server is running, everything else is working properly for quite
some time.  All services are running properly.  The configuration is
correct.  They're not going into text.  Nothing related to it is in the
logs.  Restart of the machine doesn't do anything.
 
The logs stopped updating around the same time I upgraded to SR1.  I didn't
read anything about the upgrade that would affect it in the documentation.
 
Any ideas how to kick start it?
 
Thanks
Brandon
 
 _______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip