Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

cisco cdr insert + cdr database (sql)

Hello,

the problem that we have is :

the cisco cdr insert can't insert the generated cdr into sql databse ( CDR database).

some generated cdr are stocked in [C:\Program Files\Cisco\CallDetail\BAD] and the most are stocked in the [C:\Program Files\Cisco\CallDetail\CDR].

and the cdr insert service is started.

can you help me please

3 REPLIES

Re: cisco cdr insert + cdr database (sql)

Restart the CDR insert service a few times, then move manually the files from the BAD folder to either the CDR folder or the CMR folder (according to what the file is) you can use the following scripts:

@echo off

move C:\Progra~1\Cisco\CallDetail\BAD\cmr*.* C:\Progra~1\Cisco\CallDetail\CMR\

@echo off

move C:\Progra~1\Cisco\CallDetail\BAD\cdr*.* C:\Progra~1\Cisco\CallDetail\CDR\

Save each script on a different file and save them as .bat and then run it on the publisher.

Then restart again the CDR insert service, see if the files are inserted to the CDR database or are still going to the BAD folder

Community Member

Re: cisco cdr insert + cdr database (sql)

Hi jorge,

all the generated cdr still stocked int the

c:\Progam\Cisco\CallDetaill\CDR, but no data in the cdr database.

and in the event view ,i dont have any error message!

i dont know how to resolve this problem?!

thanks

hicham

Re: cisco cdr insert + cdr database (sql)

>>>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.

512
Views
10
Helpful
3
Replies
CreatePlease to create content