CDR error "10012.Database Error. Contact system administrator"

Unanswered Question
Sep 30th, 2009
User Badges:

Hi,


I enabled CDR in the CCM 7. But i m not able to pull the information through CAR. I m getting this "error 10012.Database Error" If any body faced this same error befor pls try to help me to resolve this issue.


and i try to do complete some trouble shooting steps also.


Regards,

Sunish

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
virverma Wed, 09/30/2009 - 10:19
User Badges:
  • Silver, 250 points or more


1. With root access, backup the existing file of /usr/local/cm/conf/dbl/prefs.xml on CUCM server. (i.e. cp /usr/local/cm/conf/dbl/prefs.xml /usr/local/cm/conf/dbl/prefs.xml.BAK)


2. Manually update/modify /usr/local/cm/conf/dbl/prefs.xml. Change the hostname & informixserver values for the 'jdbcurl_car' entry to match that of the hostname & informixserver values listed in 'jdbcurl' entry. Save the changes and exit.

For example, if you see prefs.xml with something like:




Change jdbcurl_car line to:



This can be done by:

/usr/local/cm/bin/pryftool --system cm --hive dbl --set jdbcurl_car="jdbc:informix-sqli://NEWHOST:1500/car:informixserver=newhost_ccm6_1_2_1000_13;user=dbcarsch;IFX_LOCK_MODE_WAIT=20"


3. Afterwards, restart 'Cisco CAR Web Service' & 'Cisco CAR Scheduler' services.

Actions

This Discussion