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

sunishnair · ‎09-30-2009

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

virverma · ‎09-30-2009

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.