SAP Knowledge Base Article - Preview

1202832 - Extended Daylight Saving Time (EDST) impacts to Crystal Enterprise 9

Symptom

Crystal Enterprise (CE) 9 will be affected by the Extended Daylight Savings Time changes being put in place starting 2007. Patch support has ended for version 9 of Crystal products so no fix will be provided to customers; however, there is a workaround that can be used to keep scheduled reports processing on time.
 
CE 9 relies on the system clock to keep schedules processing on time, so why won't the Crystal Reports continue to run on schedule. CE uses calls to the Operating System to determine the current time and this is done at regular intervals so that CE is always kept in synch with the system time.
 
When a scheduled job is created within the Enterprise environment, the time it's set to run is stored within the CMS database; however, this is stored in a timezone independent format. Crystal uses UTC time (Coordinated Universal Time) format to store time settings for schedules. We then apply timezone rules based on internal strings, if these strings do not coordinate with the system timezone settings, the schedules will be off.
 
How will this affect your schedules? If the operating system is patched for DST then it will cause Crystal timezone strings to be mismatched with the timezone settings on the operating system. This will cause all scheduled reports to run one hour late for the 3 week interval between when the operating system (OS) will apply DST and when CE 9 will apply DST. In this scenario, the OS will apply DST on March 11th 2007 and CE 9 will catchup on April 1st 2007 when DST would have originally been applied. When CE 9 applies its DST settings, all schedules will return to normal and will complete on time. The same thing will happen on October 28th 2007 when CE 9 will fall back an hour because of its internal DST strings which will cause all reports to run an hour early until November 4th when the OS will catch up after applying the new DST settings causing all schedules to return to normal.


Read more...

Product

Crystal Enterprise 9

Keywords

DST, Crystal Enterprise 9, CE9, Daylight Savings Time, bo_xi_r2_daylight_savings_windows , 6375979 , KBA , BI-BIP , Business intelligence platform , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.