Support Article

Invalid datetime format/datetime "Today" in reports

SA-30177

Summary



Errors occur when the user runs the RD by choosing the relationship for a datetime property as "Is not null" in filter conditions before displaying the data. 
This datetime property should be a filter condition with value as "Today" chosen from Select Values. 

There is no functionality impact while executing reports and filters are getting applied. However useris looking for an explanation for this exception as it is being logged on daily basis whenever they run report definition containing filter as "Today"


Error Messages



2016-10-12 09:16:19,777 [ WebContainer : 15] [TABTHREAD0] [ ] [ABC:02.05.01] (ternal.mgmt.StreamBuilderTools) ERROR |10.10.10.10  ABCUser - Problem appending stream null
com.pega.pegarules.pub.PRRuntimeException: Section 'RRFilters_Logic' execution error on page 'pyReportContentPage' of class 'Code-Pega-List'. : Invalid datetime format/Invalid datetime "Today"

Caused by: com.pega.pegarules.pub.clipboard.InvalidValueException: Invalid datetime format/Invalid datetime "Today" 
at com.pega.pegarules.pub.util.PRDateFormat.parseAsDateTime(PRDateFormat.java:1310) 
at com.pegarules.generated.pzConvertStandardToLocalizedFormat_071017_oIivWonjRMjaT1tWUhARLA.pzConvertStandardToLocalizedFormat07_10_17(pzConvertStandardToLocalizedFormat_071017_oIivWonjRMjaT1tWUhARLA.java:132)
at com.pegarules.generated.pzConvertStandardToLocalizedFormat_071017_oIivWonjRMjaT1tWUhARLA.invoke(pzConvertStandardToLocalizedFormat_071017_oIivWonjRMjaT1tWUhARLA.java:75) 



Steps to Reproduce

  1. Open RD under Data class and have datetime property as filter condition.
  2. Run this RD and change relationship on filter condition of .DTProp(Datetime) to "Is not null" 
  3. Apply and display the report to replicate this exception.

Root Cause



A defect in Pegasystems’ code or rules due to a missing check for datetime property.

Resolution



Apply HFix-30427

 

Published November 9, 2016 - Updated November 11, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.