cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1099
Views
15
Helpful
2
Replies

no data in CDR reports?

NAVIN PARWAL
Level 2
Level 2

Folks,

We have a brand new callmanager, we have enabled crd service on the publisher and also enabled the flag to true under callmanager services, but we still see no data in our cdr reports what are we missing?

Thanks

2 Replies 2

jbarcena
Level 9
Level 9

>>>Verify that "Cisco CDR Insert" and "Cisco CDR Analysis and Reporting Scheduler" services are running ONLY in the Publisher Call Manager:

in your publisher callmanager server, go to start > programs > administration tools > services > verify the status for services "Cisco CDR Insert" and "Cisco CDR Analysis and Reporting Scheduler". If they are not "started", please restart them (just right-click on the service and select "restart").

If "Cisco CDR Insert" and "Cisco CDR Analysis and Reporting Scheduler" are running also in the subscriber servers, please stop them.

-------------------

>>>Verify service parameters in callmanager servers (publisher and subscriber).

--go to ccm admin > service > service parameters > select a callmanager server from the drop-down list > at "service" please select "Cisco CallManager" > click on "advanced" > verify that the following parameters are set to the correct values:

CDR Enabled Flag = True

CDR Log Calls with Zero Duration Flag = True

Call Diagnostics Enabled = True

***Repeat the same procedure for all callmanager servers in your cluster***

--Now go to ccm admin > service > service parameters > select a callmanager server from the drop-down list > at "service" please select "Cisco Data Base Layer Monitor" > verify that the following parameter is set to the correct value:

Max CDR Records = 1500000

***Repeat the same procedure for all callmanager servers in your cluster***

--Now go to ccm admin > system > enterprise parameters > verify that the following parameters are set to the correct values:

CDR File Time Interval (min) = 1

CDR Format = CDRs will be inserted into database

CDR UNC Path = \\\CDR

Local CDR Path = C:\Program Files\Cisco\CallDetail

***Repeat the same procedure for all callmanager servers in your cluster***

-------------------

>>>Please go to start > programs > administration tools > services and restart the following services after hours:

1) Restart service "Cisco database Layer Monitor" on publisher and subscriber servers.

2) Restart service "Cisco CDR Insert" on the publisher server.

3) Restart service "Cisco CDR Analysis and Reporting Scheduler" on the publisher server.

-------------------

By default CAR loads the information at midnight so if you enable everything today you won't be able to do the reports until tomorrow. You can go to Start --> Programs --> Microsoft SQL server --> Enterprise Manager, expand the Databases and select the CDR database, then select the tables, on the right select the CallDetailRecord table, right click and select open table --> return all rows, see if you have information on the DB.

HTH

//Jorge

I have the similar problem - the CCM 4.1(3) and CDR but havn't "Cisco CDR Analysis and Reporting Scheduler" service. Instead there is the "ARTScheduler" servise. Is it the new one?

Bills->Individual report for the my account have a very litte rows in report - approximately ten (I'm sure I did much more calls).

Please, see "CDR Error Report" file attached.

//Sergey