Error code 10012

Unanswered Question
Aug 8th, 2007

Dear Networkers,

I am facing a peculiar issue while trying to generate the user / extension based report from CDR. After i select the extension and i say generate report, its throwing me 'error code 10012' Database Error. Contact System Administrator.

Referred the document on the below link and had done the suggested steps. Still i am hitting the same issue.

http://cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a0080874bd4.shtml

I am running CCM 5.1.

thanks in advance for your valuable replies.

...

Karthik

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3.7 (3 ratings)
Loading.
gogasca Wed, 08/08/2007 - 21:34

There are some bugs that are supposed to be fixed already in 5.1 that appear in 5.0 but anyways give me the exact version (My recommendation is go to the latest patch available in CCO).

Check this:

CSCsg01364

CSCse61454

CSCsi65378 -

But if you dont want to upgrade my recommendation will be opening a TAC case for further troubleshooting and analisys.

BTW .That link is for CCM 4.X

islam.irshaid Tue, 03/11/2008 - 06:39

Hi,

i am facing the same problem here.

we have CCM5,5.1.1.3113-1.

Could you please help me in this issue.

Thanks

cuevas Tue, 05/13/2008 - 03:16

Anyone find a solution yet??? I'm running into the same exact error, and this just started happening. A couple of weeks ago, it was fine. The only major change we've done was added 2 more Subscribers to the Cluster. So i have 1 Publisher and 3 Subscribers.

islam.irshaid Tue, 05/13/2008 - 03:18

yes, i faced such problem and solved it

just let me know, which Software version you have ?

islam.irshaid Tue, 05/13/2008 - 03:20

ok ,,, just you have to upgrade to 5.1.3

and for sure the problem will be solved

cuevas Tue, 05/13/2008 - 03:22

Is this a known bug, that after a period of time, you begin to get this error? it was working before.

metalium2007 Wed, 06/04/2008 - 08:10

Hello friends,

Talked with gmorrow, that tried to help me find my similar problem. Anyway i guess that this can be from a lot of parameters and just not CDR_MAX_DATE. I haven't tried yet, but i guess the best hint is to upgrade to 5.1.3

Thanks friends, and greyson morrow particulary.

Best regards,

Met.

cuevas Wed, 06/04/2008 - 08:33

Yeah GMORROW helped me out as well.

TAC had me do this:

Could you please check the following configuration:

Log in to Call Manager Admin page ====> System =====> Enterprise Parameters:

make sure that the value for those are as follow:

CDR File Time Interval = 1

Cluster ID = StandAloneCluster

Go to System =====> Service Parameters (Service: Cisco CallManager):

Configure the following parameters on all the callmanager servers in your

cluster:

CDR Enabled Flag = True

CDR Log Calls with Zero Duration Flag = True

Call Diagnostics Enabled = Enabled Regardless of CDR Enabled Flag

>>>Please verify also the status for the following services:

"Cisco SOAP - CDRonDemand Service" = active on the publisher server

"Cisco CDR Repository Manager" = active on the publisher server

"Cisco CDR Agent" = active on all the callmanager servers in your cluster.

"CAR Schedular" = active on publisher server only.

If still the same then, please try the following:

1. Disable the "CDR Enabled Flag" parameter in all the servers in your cluster.

2. Restart the "Cisco CDR Agent" service in all the servers in your cluster.

3. Restart the "Cisco CDR Repository Manager" service in the publisher server.

4. Restart the "Cisco Database Layer Monitor" service in all the servers in your cluster.

5. Enable again the "CDR Enabled Flag" parameter in all the servers in your cluster.

haouaswajih Thu, 09/25/2008 - 02:43

Dear Networkers,

I have a problem with my Cisco Unified Comm Manager CDR Report and need urgent help.

We are working with Cisco Unified Communications manager 6.0.1 (System version: 6.0.1.2000-3). When I access to Cisco Unified Communications Manager CDR Analysis and Reporting, then go to:

Device Reports --> Gateway --> Detail, I have an error page (Error code 10012, Database Error. Contact System Administrator. )

I have found this error in cisco troubleshooting technotes (cisco site) and the procedure to solve the problem as said in the document was the following:

On Cisco Unified Communications Manager line command system :

1- run sql select param_value from car:tbl_system_preferences where param_name='CDR_MAX_DATE'

2- run sql insert into car:tbl_system_preferences(param_name,param_value) values ('MAX_DATE', '”)

I tried to do this, but unfortunately in step 2, I had an error message (Unique constraint (car:informix.pktbl_system_preferences_01) violated) as you can see in the attached screenshot (Max date.jpg)

I followed the procedure above but unfortunately too, it did not solve my problem.

I was hoping that you could help me about this serious issue, because we are in a production environment, and we need CDR to be working as soon as possible.

Kindly note that some CDR search are working and some are not: For exemple when I go: CDR à Search à By User/ Extension , I can find the records.

But I need to work with Gateway Detail Record search, and it does not work (10012 code, error message)

it's really urgent!!!

Thanks in advance.

haouaswajih Mon, 11/03/2008 - 15:23

Hi keithknowles,

Yes my problem was solved by a TAC engineer.

In fact the probmlem corresponds to the BUG CSCsm34263

Bug Details:

Missing date column entries in tbl_system_preferences fail car scheduler

Symptom:

Reports or CDR Loading fail in CAR, causing missing CAR reports and accumulated CDR/CMR files unprocessed to CAR database.

this is caused due to missing max_date, min_date,cdr_max_date OR cdr_min_date from tbl_system_preferences.

the following line can be seen in car scheduler / car web service trace:

"loadCurrentData(): does not exist in tbl_system_preferences, restore to its default"

Follow steps below to confirm which entry is missing:

1. check MIN_DATE value:

admin: run sql select param_value from car:tbl_system_preferences where param_name='MIN_DATE'

2. check CDR_MIN_DATE value. admin: run sql select param_value from car:tbl_system_preferences where param_name='CDR_MIN_DATE'

3. check MAX_DATE value: admin: run sql select param_value from car:tbl_system_preferences where param_name='MAX_DATE'

4. check CDR_MAX_DATE value. admin: run sql select param_value from car:tbl_system_preferences where param_name='CDR_MAX_DATE'

Conditions:

CAR's 'tbl_system_preferences' table is missing MIN_DATE, MAX_DATE, CDR_MIN_DATE, or CDR_MAX_DATE column, or a combination of the four columns. This usually happens after W1/L2 migration.

Workaround:

Identify which column(s) are missing in tbl_system_preferences table (this can be done either by looking at the CAR scheduler trace and search for ERRORm, or it can simply be done by querying directly on tbl_system_preferences table via CLI to find out which one(s) are missing: "admin: run sql select * from car:tbl_system_preferences")

If any of these four columns is missing, insert it back to the table with the following logic:

- If MIN_DATE is missing, find CDR_MIN_DATE value and insert such value as MIN_DATE to tbl_system_preferences.

- If CDR_MIN_DATE is missing, find MIN_DATE value and insert such value as CDR_MIN_DATE to tbl_system_preferences.

- If both MIN_DATE & CDR_MIN_DATE are missing, insert '01/01/1970' to both columns to to tbl_system_preferences.

- If MAX_DATE is missing, find CDR_MAX_DATE value and insert such value as MAX_DATE to tbl_system_preferences.

- If CDR_MAX_DATE is missing, find MAX_DATE value and insert such value as CDR_MAX_DATE to tbl_system_preferences.

- If both MAX_DATE & CDR_MAX_DATE are missing, insert '01/01/1970' to both columns to to tbl_system_preferences.

In any of the above cases, once Loader starts and load new files, it will populate the correct values for these columns again, based on the records being loaded.

For example, if CDR_MIN_DATE is missing:

1. Get MIN_DATE value.

admin: run sql select param_value from car:tbl_system_preferences where param_name='MIN_DATE'

2. Get the value from above, eg: 01/01/2008, then run:

admin: run sql insert into car:tbl_system_preferences values('CDR_MIN_DATE', '01/01/2008');

For example, if MAX_DATE is missing:

1. Get CDR_MAX_DATE value.

admin: run sql select param_value from car:tbl_system_preferences where param_name='CDR_MAX_DATE'

2. Get the value from above, eg: 02/14/2008, then run:

admin: run sql insert into car:tbl_system_preferences values('MAX_DATE', '02/14/2008');

Hope this would solve your problem. It did solve mine.

Regards.

keithknowles Mon, 11/03/2008 - 15:51

You are a God-send. Thank you sooooo much, mine was related to the MIN_DATE column. Problem solved.

haouaswajih Mon, 11/03/2008 - 16:19

You're welcome my friend.

Glad that it solved your problem!

Regards.

Actions

This Discussion