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. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

CDR Timestamp 1 Hour Behind--DST Issue

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
Hall of Fame Super Red

Re: CDR Timestamp 1 Hour Behind--DST Issue

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

New Member

Re: CDR Timestamp 1 Hour Behind--DST Issue

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.

Re: CDR Timestamp 1 Hour Behind--DST Issue

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

Bronze

Re: CDR Timestamp 1 Hour Behind--DST Issue

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

131
Views
5
Helpful
4
Replies