cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
528
Views
5
Helpful
4
Replies

CDR Timestamp 1 Hour Behind--DST Issue

wrkemmer
Level 1
Level 1

When going through CDR Analysis and Reporting, timestamps are still 1 hour behind when searching by extension.

By doing SQL searches on the CDR database, it looks like the CDR data is timestamped correctly. The server time, and times on all the phones are correct. I assume something in the actual CAR interface. Perhaps java related??

Any insight is appreciated.

4 Replies 4

Rob Huffman
Hall of Fame
Hall of Fame

Hi William,

Maybe this patch is what you need;

JRE Patch: (ciscocm-2007-JRE-DST-Update.1-0-1.exe)

This patch is only applicable to 3.3(5), 4.0(2a), 4.1(x), and 4.2(x). This patch enables CAR and AST to use the new Daylight Saving Time Zone.

From this doc;

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

Hope this helps!

Rob

I am having the same problem with CDR records. I have installed the DST updates and everything else is correct. We are running 4.1(3)sr4d.

jbarcena
Level 9
Level 9

We have a bug opened for that issue:

CSCsh81417: CDR Analysis and Reporting does not reflect new DST changes

Symptom:

CallManager servers updated with all of the correct DST patches will report

calls in CDR Analysis and Reporting as one hour behind the actual time of the

call between March 11th and April 1st 2007 as well as between October 28th

and November 4th 2007.

The time stamp on the CDR record in the CDR table is correct but reports

generated with CDR Analysis and Reporting will be off by one hour.

Workaround:

Update the JRE component on your Publisher, from the following location:

http://www.cisco.com/cgi-bin/tablebuild.pl/callmgr-utilpage

Reboot all the servers in the cluster to replicate the changes.

HTH

//Jorge

Does this also fix RTMT (Real Time Monitoring Tool)?

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: