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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Error code 10012

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

22 REPLIES
Green

Re: Error code 10012

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

New Member

Re: Error code 10012

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

New Member

Re: Error code 10012

I am having the same issue. Running 5.1.2.3000. I just opened a TAC case. I will let you know what fixed us when we get it fixed.

New Member

Re: Error code 10012

I'm having exaclty the same problem with the version 5.1.2.3000-2

New Member

Re: Error code 10012

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.

New Member

Re: Error code 10012

yes, i faced such problem and solved it

just let me know, which Software version you have ?

New Member

Re: Error code 10012

Running UCM version 5.1.2

New Member

Re: Error code 10012

ok ,,, just you have to upgrade to 5.1.3

and for sure the problem will be solved

New Member

Re: Error code 10012

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

New Member

Re: Error code 10012

TAC told me that it has something to do with the flat files. and the CDR_MAX_DATE missing from the parameter

New Member

Re: Error code 10012

So upgrading is the only solution?

New Member

Re: Error code 10012

yes

the Bug is CSCsi65378

plz rate if help

New Member

Re: Error code 10012

NO, I fixed it and im running 5.1.2. E-mail me for further information if you want a fix.

gmorrow@emp.com

New Member

Re: Error code 10012

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.

New Member

Re: Error code 10012

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.

New Member

Re: Error code 10012

and...did it worked out, friend?

tnx

New Member

Re: Error code 10012

yes , its working now

New Member

Re: Error code 10012

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.

New Member

Re: Error code 10012

Did you ever get this solved? I am running into the exact same issue.

New Member

Re: Error code 10012

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.

New Member

Re: Error code 10012

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

New Member

Re: Error code 10012

You're welcome my friend.

Glad that it solved your problem!

Regards.

3203
Views
11
Helpful
22
Replies
CreatePlease login to create content