Problem Note 64527: You receive the message "IllegalFieldValueException..." when calculating the start date of a time period in SAS® Risk and Finance Workbench
When calculating the start date of a time period (which can happen when creating a time hierarchy or load data) in SAS Risk and Finance Workbench, you might encounter the following exception:
2019-02-27 10:03:05,999 [tomcat-http--4] [rgfadmin] rgfadmin/1651 ERROR com.sas.stress.rest.controller.ControllerExceptionHandler - Generic exception
handling for request: http://cbrhmaprlx004.extra.caixa.gov.br:7980/SASRiskandFinanceWorkbench/rest/config/hierarchies/49/items
org.joda.time.IllegalFieldValueException: Value 0 for hourOfDay is not supported: Illegal instant due to time zone offset transition (daylight savings
time 'gap'): 2014-10-19T 00:00:00.000 (America/Sao_Paulo)
The issue occurs when you calculate the start date of a time period on a date that contains a time change because of daylight saving time. You encounter this issue when you use a date within a time period determined by a period type like MONTH. Note that the issue occurs only in time zones in which the time change occurs at midnight.
Here are the time zones that experience this problem:
- America/Araguaina
- America/Asuncion
- America/Campo_Grande
- America/Cuiaba
- America/Havana
- America/Santiago
- America/Sao_Paulo
- America/Scoresbysund
- Antarctica/Palmer
- Asia/Beirut
- Asia/Tehran
- Atlantic/Azores
- Brazil/East
- Chile/Continental
- Cuba
- Iran
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Risk and Finance Workbench | Microsoft® Windows® for x64 | 3.1 | | 9.4 TS1M5 | |
Linux for x64 | 3.1 | | 9.4 TS1M5 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
When calculating the start date of a time period, you encounter an issue when the specific date contains a time change because of daylight saving time.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2019-08-05 10:36:56 |
Date Created: | 2019-07-29 07:08:04 |