CDR error on CUCM 6.1.2

[ayoussef.kamal]

Experts,

I am facing error code 10021 when exporting CDR report from CUCM 6.1.2. AQfter searching on Cisco site, i found the below link

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a0080933fcf.shtml#Problem2

i did that solution, Am i wait till next midnight to let CUCM to collect new reports or that solution will not solve my problem.

any ideas? did anybody face/overcome this problem before?

BR,

[kusatija]

Hello!

Is the loader set to 24*7? if yes and if you restarted the Car schedular service then you should see reports being generated as per the doc you mentioned.

But the 10021 error can come because of other reasons as well, most of the time the car schedular service fails, or is not able to process a bad cdr file.

If the above does not work, please provide the folloing from the CLI of the publisher:

run sql select * from car:tbl_system_preferences
file list activelog /cm/cdr_repository/preserve/
file list activelog /cm/cdr_repository/processed/

HTH

Kunal

[ayoussef.kamal]

Regarding,

Is the loader set to 24*7? if yes and if you restarted the Car schedular service then you should see reports being generated as per the doc you mentioned.

I did 24*7 AND restarted Car schedular

Regarding the Shows you need, as follows:

admin:run sql select * from car:tbl_system_preferences

param_name                param_value                                   

========================= ==============================================

MIN_DATE                  05/14/2011                                    

MAX_DATE                  06/07/2011                                    

CDR_MIN_DATE              05/14/2011                                    

CDR_MAX_DATE              06/07/2011                                    

MAX_CDR_NUMBER            2000000                                       

MAX_ERROR_RECORD_ID       40978637                                      

COMPANY_NAME                                                            

TOLL_FREE                 1800,1855,1866,1877,1888                      

CHARGELIMIT               200.00                                        

GOOD                      20.00                                         

POOR                      30.00                                         

DEFAULT_CAR_USER          _unspecifieduser                              

LOADER_STATUS             1                                             

CONTINUOUS_LOADING_24_7   1                                             

LOAD_CDR_ONLY             1                                             

MANUAL_PURGE_STATUS       0                                             

LOADER_SCHEDULE_BACKUP    DailyCdrLoad,L,1440,-1,00:00:00,0,300,30      

PURGE_LOW_WATER_MARK      80                                            

PURGE_HIGH_WATER_MARK     90                                            

MIN_CAR_DATABASE_AGE      30                                            

MAX_CAR_DATABASE_AGE      60                                            

LAST_PROCESSING_DIRECTORY 20110606                                      

LAST_PROCESSING_FILE      cdr_Barclays-IPT-Cluster_06_201106061316_14866

LAST_PROCESSING_DATA_ROW  96                                            

UPDATE_STATISTICS_DATE    06/12/2011,0                                  

LOADER_BATCH              600,600,2500,3000                             

INSTALLATION_DATE         6/25/2009                                     

admin:file list activelog /cm/cdr_repository/preserve/

   20110513   20110514   20110515   20110516   20110517   20110518   20110519   20110520   20110521   20110522   20110523   20110524   20110525   20110526   20110527   20110528   20110529   20110530   20110531   20110601   20110602   20110603   20110604   20110605   20110606   20110607   20110608   20110609   20110610   20110611   20110612   20110613

dir count = 32, file count = 0

admin:file list activelog /cm/cdr_repository/processed/

   20110513   20110514   20110515   20110516   20110517   20110518   20110519   20110520   20110521   20110522   20110523   20110524   20110525   20110526   20110527   20110528   20110529   20110530   20110531   20110601   20110602   20110603   20110604   20110605   20110606   20110607   20110608   20110609   20110610   20110611   20110612   20110613

dir count = 32, file count = 0

[kusatija]

ok, so the files do seem to be there in the cdr preserve and process  folders, still car schedular is failing...and the last files processed  are :

LAST_PROCESSING_DIRECTORY 20110606   , that is till the 6th.

Can you provide the screenshot of the table information from the path:

CAR tool>>system>>database>>manual purge, plz provide the screen shot of the billing table.

Can you do a manual purge to the database that should fix the issue.

Hit on the manual purge option, a new window would start showing that the process is executing, once done, hit the close tab.

Check the reports the next day, they should be there..

HTH

Kunal

[Vishal Gogia]

MAX_ERROR_RECORD_ID > MAX_CDR_NUMBER

This looks weird.

Along with the info that Kunal provided, can you also send me the output of following queries:

run sql select count(*) from car:tbl_billing_data

run sql select count(*) from car:tbl_billing_error

Looks like the DB is full. Manual Purging of data is needed.

TnR

Vishal