Where are CDR records?

[stevedb55]

Hi All,

I am having problems extracting CDR records from my CallManager. I have CDR enabled on both pub and sub, log calls with zero duration is set to True, Call diagnostics is enabled, but when I check the CDR database on publisher via SQL Enterprise Mgr, the CallDetailRecord table does not return any rows.

I have restarted the Database Layer and CDR insert services and also the CAR Scheduler service.

Does anyone have any ideas what could be wrong?

Thanks
Steve

 

[pndscm]

Since you said SQL, I am assuming you are not on CCM 5. Look in Enterprise Parameters. There is a URL for CDR, put in the IP address for the Publisher server, not the name that goes there by default. Make sure you don't have a DNS issue.

 

[Iwontremember]

I had this happen before. I ended up using Crystal Reports to pull the data, then after that CDR worked, but I stayed with Crystal. CDR doesnt give enough detail.

 

[Iwontremember]

I am also using Infortel Select

http://www.isi-info.com/solutions/solutions_select.htm

I really like this software but only have a 500 user lic right now. I highly recomend it.

 

[TelcoTech]

Have you also made sure that the CDR insert service is only running on the publisher?

 

[stevenChina]

TelcoTech ,yes,I meet the same issue,and i'm sure CDR Insert service is only running on the Pub?Would u pls give me some advice?

 

[TelcoTech]

I recently setup 7 clusters for CDR and there are only a few settings as you know. All subs need to have the CDR Enabled Flag set to true under service parameters for callmanager. Also, the CDR insert service should only be running on the pub. Then make sure the enterprise parameters are set to:

1. CDR File Time Interval (min)= 1
2. CDR Format= CDRs will be kept in flat files.
3. CDR UNC Path= \\"Hostname"\CDR
4. Cluster ID= "Unique Name" (i.e. Pub1)
5. Local CDR Path= C:\Program Files\Cisco\CallDetail

If you still have issues, check the SQL database within enterprise manager. Make sure its attached and that its writting to the default CDR location. (which is c:\Program Files\Microsoft SQL Server\MSSQL\Data\CDR.mdf)

 

[stevenChina]

Thanks,TelcoTech.I'll verify my configration.