This document contains frequently asked questions regarding common problems encountered with the Cisco CallManager Call Detail Records (CDR) and the Administrator Reporting Tool (ART).
Note: The information provided in this document is based on Cisco CallManager 3.x.
A. The default or initial username for the CDR Analysis and Reporting tool is admin, and the default password is also admin.
A. ART can cease to record for several reasons. These are possible causes and solutions:
Ensure that the ART scheduler service is running and CDR is enabled, along with the CDR Loader in the CDR Analysis and Reporting (CAR) tool. For more information on this, refer to the "Configuring CDR Service Parameters" section of CDR Analysis and Reporting.
If the ART scheduler service is not installed in Start > Programs > Admin Tools > Services, follow these steps to install the service:
Open a DOS window and follow this path: c:\CiscoWebs\art\SchedulerService.
Run a dir command and verify that there is a file called wrapper.properties.
Enter ART_Scheduler_Service.exe -i ART_Scheduler_Service wrapper.properties.
Issue the -net start ART_Scheduler_Service command to start this service.
Verify that you can see the ART scheduler service in the Services window under Admin Tool > Services.
It is possible that there is broken Open DataBase Connectivity (ODBC). If this is the case, manually test the ART delivery status notifications (DSNs). Follow these steps to do so:
Open Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
Select System DSN from the ODBC Data Source Administrator.
Select ART System Data Source and click Configure.
Select Next repeatedly (do not make any changes in the settings), until the final window appears with the option to Test Data Source....
Click Test Data Source... and ensure the message TESTS COMPLETED SUCCESSFULLY! appears.
Click OK and then cancel all the windows, which leaves only the ODBC Data Source Administrator window open.
Repeat steps 3 through 6 with ARTCCM1 and ARTCCM2.
A. In Cisco CallManager, globalCallId_ClusterId specifies a unique ID that identifies a cluster of Cisco CallManagers. These fields make up this unique key: GlobalCallId_ClusterId + GlobalCallId_CMId + GlobalCallId_CallId. This parameter is embedded in the Cisco CallManager call processing code and should not be modified either within the CallManager itself or in the SQL database table as a parameter/attribute.
A. In order to manually purge the ART database, first run these ART table purge queries from the Structured Query Language (SQL) Analyzer, and select the database named "art":
delete from Tbl_Load_History
delete from Tbl_Dump_PkID
delete from Tbl_Error_Id_Map
delete from Tbl_Billing_Data
delete from Tbl_Billing_Error
delete from Tbl_Dump_CallDetailRecord
delete from Tbl_Dump_CallDetailRecordDiagnostic
Restart the ART scheduler (Cisco CDR Analysis and Reporting (CAR) scheduler) service. Ideally, it begins to load CDRs as per your CDR load setting.
Note: It is advisable to perform this process after hours, so that it does not impact normal call processing. Based on the number of CDRs and the CDR load settings, it can take some time and some number of CDR load cycles to completely load all the CDRs.
A. This error can result from these situations:
CDR is not enabled properly.
Data is not synchronized between the CDR and ART databases.
The Comments column of the CallDetailRecord table has data that exceeds 256 characters.
In order to find out which issue is responsible for the problem and the appropriate workaround, refer to Data is Absent in Reports Created by the CAR Tool.
A. Call classification is done by ART. Calls must be classified in this manner:
If no configured gateways are found, classify the call as internal.
If both the origination and destination devices are gateways, classify the call as tandem.
If both the origination and destination devices are not gateways, classify the call as internal.
If only the origination device is a gateway, classify the call as incoming.
If only the destination device is a gateway, the call is an outgoing call. Classify the outgoing call as per the dial plan configuration.
A. CMRs are supported only for IP phones and Media Gateway Control Protocol (MGCP) devices and gateways in Cisco CallManager, which is why CMR values are not seen for H.323 gateways.
A. These logs and traces are helpful:
C:\ciscowebs\art\art.ini
C:\ciscowebs\art\SchedulerService\wrapper.properties
C:\ciscowebs\art\ErrorLog.txt
C:\ciscowebs\art\SchedulerService\ARTSchError.log
C:\ciscowebs\art\SchedulerService\ARTSchOutPut.log
C:\ciscowebs\CAR_Install_Log.log
Other files that can be useful are the CDRinsert, Database Layer (DBL), and Cisco CallManager and Sychronous Data Link (SDL) traces.
For more information on how to set up traces, refer to Set Up Cisco CallManager Traces for Cisco Technical Support.
A. These are the most current and relevant Cisco bug IDs and the issues addressed by each:
CSCeb54778 ( registered customers only) —CDR Analysis and Reporting (CAR) menu option not showing up
CSCea55522 ( registered customers only) —art_log.ldf file grows very large, CAR records may stop purging
CSCdx22199 ( registered customers only) —High CPU from java.exe after reboot
CSCdx48882 ( registered customers only) —Manual purge of CDR data spikes the CPU to 100%
CSCdy60211 ( registered customers only) —High CPU issues when running reports in ART
CSCeb43209 ( registered customers only) —High CPU usage by Java when Cisco Telephony Integration Enabled Users report is opened
CSCea06051 ( registered customers only) —stiBackup does not purge files after backup
CSCed51086 ( registered customers only) —CAR report taking high CPU on the Active Directory (AD)
CSCsb99593 ( registered customers only) —CAR 4.1(0.34) stops loading CDRs-Comment col. need to support 2048 chars
A. This error message occurs if you run the CDR Insert service on servers other than the publisher. In order to resolve this issue, make sure to de-activate the CDR Insert service on all nodes except the publisher server.
A. This error message might appear when the CDR is assigned a different service account login and password than the other built-in service accounts. In order to resolve the issue, you can use the Admin Utility to synchronize all the core service passwords throughout the cluster. If this does not solve the issue, you need to reinstall the CDR plug-in.
Note: The Admin Utility works best when you select all of the service accounts for password reset. It is recommended to do the procedure during off-peak hours because the utility will restart all of the services.
A. In order to resolve this issue, make sure that:
The server name is the same in the database and in the server.
The server name does not contain an underscore. The usage of the underscore character in NetBIOS names is not recommended, as some SQL stored procedures use the character to prepend or append part of their queries.
The replication works fine between the Publisher and the Subscriber server. If the replication is broken between Publisher and Subscriber, then you will receive an error stating the CDR/CAR is not able to recognize the Publisher server even if we are installing it on a Publisher server. You need to use DBLHelper in order to re-establish the broken replication.
A. There is a limit for the PDF and CSV reports in the CDR. The limit is 5000 records for the PDF report and 20,000 records for the CSV report. If the number of records exceeds these values, you will receive the Too much data and it will be truncated error message.
A. If you receive the HTTP status 500 - Internal Server Error error message while you access the CAR reports, you need to restart the Cisco Tomcat Service from Start > Programs > Administrative Tools > Services in order to resolve the issue.
Note: This issue can also occur when you try to add the CDR server to the Unified Communications Manager cluster with an server. In this case, if you start the server, it resolves the issue.
A. With Cisco Callmanager 5.x, the Owner User ID field in the User Configuration page is used in order to link the extension to the user in the CDR. You must have a device/phone with the Owner User ID field populated, or undefined_user appears as the phone login in the CDR reports. Make sure the Owner User ID field of your device/phone is populated. If not, configure the phone with this field populated, and run the CDR report again.
A. In order to prevent the excessive growth of the CDR database, you can go to CCMAdmin > Service Parameters, select Cisco Database Layer Monitor as the service and set the Max CDR Records. Also, on CAR you can use the automatic purge for CDR and CAR which always deletes records that are of certain age.
Note: The difference between the growth restriction from SQL and the settings within CAR is that if size is restricted from SQL, new records cannot be added to the database, while if you purge old records with CAR, it deletes old records and always allows new records on the database.
A. In order to resolve this issue, make sure that:
Company Name is entered under System> System Parameters>System Preferences.
You can ping the Mail Server from the Cisco CallManager.
The Mail Domain field under Mail Parameters is not empty.
The Mail ID is added without the domain name.
A. In order to resolve this issue, you need to activate the CAR Web Service from the Cisco Unified Communication Manager Serviceability page. Complete these steps:
On the Cisco Unified Communication Manager Serviceability page, choose Tools > Service Activation.
![]()
Under the CDR services, check the CAR Web Service checkbox in order to activate it.
Click Save.
A. In order to resolve this issue, complete these steps:
- Go to the CDR page.
- Choose System > Scheduler > CDR Load.
- Uncheck the Load CDR Only check box.
A. If the FAC Code is missing from the CDR output, enable the Display FAC in CDR parameter in the CCM Service Parameters.
A. In order to resolve this, restart these services:
CDR Repository
CDR Agent
CDR Scheduler
Database Layer Monitor
RIS Data collector