Support Article
Error when creating report for table containing DateTime values
SA-60975
Summary
Pega Reporting portal generates an error while creating a report for tables which contains DateTimeStamp values. This occurs after converting the database from DB2 to Oracle.
Error Messages
No enum constant ...CoulmnType.TIMESTAMP(6)
Steps to Reproduce
- Launch the Pega Reporting portal.
- Access the table which has DateTimeStamp values
Root Cause
Pega 7.1.6 does not support TimeStamp for Oracle.
Resolution
Perform either of the following local-changes:
- Upgrade to Pega 7.1.8 or later versions.
- Implement the steps mentioned in the link: https://community.pega.com/support/support-articles/no-enum-const-class-timestamp
- Change the database column type to date in Oracle and check from report browser.
Published August 24, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.