06-12-2011 01:50 AM - edited 03-16-2019 05:24 AM
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
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,
06-12-2011 02:23 AM
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
06-12-2011 02:58 AM
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/
dir count = 32, file count = 0
admin:file list activelog /cm/cdr_repository/processed/
dir count = 32, file count = 0
06-14-2011 02:32 AM
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
07-07-2011 01:32 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide