Invalid datetime format/datetime "Today" in reports
SummaryErrors 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 Messages2016-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"
Steps to Reproduce
- Open RD under Data class and have datetime property as filter condition.
- Run this RD and change relationship on filter condition of .DTProp(Datetime) to "Is not null"
- Apply and display the report to replicate this exception.
Root CauseA defect in Pegasystems’ code or rules due to a missing check for datetime property.
Published November 9, 2016 - Updated November 11, 2016