Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
337
Views
0
Helpful
3
Replies

CAR issue in 5.1.3

Go to solution
vinayjaiswal
Level 3
Level 3

‎08-01-2008 01:28 AM - edited ‎03-15-2019 12:21 PM

Hi,

I am having a cluster of 9 servers which are running UCM 5.1.3.It is integrated with Third party Call Billing server for CDR reporting.Everything was fine till 9th july, after that we were not able to receive any report neither in Call Billing server nor in CAR reports.To solve this I had disabled and enabled the CDR from the service parameters in all the servers and restarted all the CDR related services including Database Layer monitor service, after which I was able to see the reports in Call Billing server but cannot see the reports in CAR(i.e. https://firstnode-ip/car).

Need help on this.

Thanks,

Vinay

Labels:
0 Helpful
1 Accepted Solution

Accepted Solutions

Go to solution
florian.kroessbacher
Level 1
Level 1
In response to vinayjaiswal

‎08-26-2008 10:31 AM

Hy out there!

we have a cluster from 3 CUCM 5.1(2) and there weren't any entries in CAR since 29th July (But there where still entries in the Billing Systems).

So we wanted to manualy purge, but the Purge didn't run.

So we restarted the Cisco CAR Webservice and Purge again, and it again didn't the job.

So i go along in the forum and found this entry

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=Unified%20Communications%20Applications&topicID=.ee835d2&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.2cbe3b3b/1#select...

Than a run the following command from the CLI

run sql select * from car:tbl_system_preferences where param_name='MANUAL_PURGE_STATUS'

The param MANUAL_PURGE_STATUS was 1 so a Purge Job was running for the System (which couldn't run, because of the restart of the CAR Webservice, after that you should run a new Purge if you did one before restarting the Webservice)

so I did this command

run sql update car:tbl_system_preferences set param_value='0' where param_name='MANUAL_PURGE_STATUS'

After that the Purge now runs

And there are CDR's on the CAR

cheers Floh

please rate!!!

View solution in original post

0 Helpful
3 Replies 3

Go to solution
ivillegas
Level 6
Level 6

‎08-07-2008 06:04 AM

Run the command " run sql select * from car:tbl_billing_data where callingpartynumber ='(different DN)' “. Check if the records are available.

Once you integrated with the Billing Server then all the records will be pushed to the Billing Server "CAR will no longer be used”.

0 Helpful

Go to solution
vinayjaiswal
Level 3
Level 3
In response to ivillegas

‎08-20-2008 10:28 PM

I have run that but no results are displayed.Earlier it was working fine.

0 Helpful

Go to solution
florian.kroessbacher
Level 1
Level 1
In response to vinayjaiswal

‎08-26-2008 10:31 AM

Hy out there!

we have a cluster from 3 CUCM 5.1(2) and there weren't any entries in CAR since 29th July (But there where still entries in the Billing Systems).

So we wanted to manualy purge, but the Purge didn't run.

So we restarted the Cisco CAR Webservice and Purge again, and it again didn't the job.

So i go along in the forum and found this entry

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=Unified%20Communications%20Applications&topicID=.ee835d2&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.2cbe3b3b/1#select...

Than a run the following command from the CLI

run sql select * from car:tbl_system_preferences where param_name='MANUAL_PURGE_STATUS'

The param MANUAL_PURGE_STATUS was 1 so a Purge Job was running for the System (which couldn't run, because of the restart of the CAR Webservice, after that you should run a new Purge if you did one before restarting the Webservice)

so I did this command

run sql update car:tbl_system_preferences set param_value='0' where param_name='MANUAL_PURGE_STATUS'

After that the Purge now runs

And there are CDR's on the CAR

cheers Floh

please rate!!!

0 Helpful
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Customers Also Viewed These Support Documents