CDR Analysis and Reporting Fails to Query by Dates

[thoraya_fayez]

Hi! we're facing a problem that when generating reports using CDR analysis a message stating "30025: Data is available only up to Dec 1,2010. Do you want to generate the report?"

Note: when the call manager Publisher was restarted the date appearing in the error messsage changed to Dec 4,2010!!!!!!

The call manager is 6.1.1.2000-3.

the notes and solution found for a similar problem that i found was for an earlier call manager that i guess it was windows based.

is there anyone who can help with troubleshooting steps:)

Thanks,

[Rob Huffman]

Hi Thoraya,

Here is the newer 6.x version of that doc

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

Cheers!

Rob

[kusatija]

Hi Thoraya,

Just in case the above does not fix the issue, please post the output of the following from the CLI of the pub:

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

It lloks like the system preference table does not hv the right values for the dates.

Regards
Kunal

[thoraya_fayez]

Hi! Guys,thanks for your support

Rob   thanks for the link, but unfortunately it didn't fix the problem

so Kunal here are the output of the Commands

for the firt one:

param_name                param_value
========================= ===========
MIN_DATE                  01/01/1970
MAX_DATE                  01/01/1970
CDR_MIN_DATE              01/01/1970
LAST_PROCESSING_DIRECTORY 0
MAX_CDR_NUMBER            2000000
MAX_ERROR_RECORD_ID       0
COMPANY_NAME              0
TOLL_FREE                 0
CHARGELIMIT               0
GOOD                      0
POOR                      0
DEFAULT_CAR_USER          0
LOADER_STATUS             1
CONTINUOUS_LOADING_24_7   1
LOAD_CDR_ONLY             1
MANUAL_PURGE_STATUS       0
LOADER_SCHEDULE_BACKUP    0
PURGE_LOW_WATER_MARK      0
PURGE_HIGH_WATER_MARK     0
MIN_CAR_DATABASE_AGE      0
MAX_CAR_DATABASE_AGE      0
LAST_PROCESSING_FILE      0
LAST_PROCESSING_DATA_ROW  0
UPDATE_STATISTICS_DATE    0,0
CDR_MAX_DATE              01/01/1970
LOADER_BATCH              0
INSTALLATION_DATE         0

as for the second and third commands they displayed the same output

   20101205  till      20110105

please note that yesterday before following the troubleshooting steps mentioned in Rob's link the CDR_MAX_DATE, CDR_MIN_DATE, MAX_DATE and  MIN_DATE values were different values for the year 2010 (the min was 5/11 & the max was 4/12), the 1/11970 was displayed after the manual purge.

i guess it seems like the data starting from 5/12/2010 are stuck the loader fails to load them or something like that.

also the CDR event log showed CDR load unsuccessful when generating the reports (that of course fails to be generated)

[kusatija]

Hi Thoraya,

Yup, seems to be an issue with the CAR schedular. also the system preferences table is screwed up.

Please restart the Car schedular services again, and post the following outputs again:

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

Also post the screen shot of the following GUI page:

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

Restarting the car schedular should fix the system preference table, and then the files should start showing up.

also is the continues loading set to continues?

Regards
Kunal