Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

  1. Launch the Pega Reporting portal.
  2. 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:
  1. Upgrade to Pega 7.1.8 or later versions.
  2. Implement the steps mentioned in the link: https://community.pega.com/support/support-articles/no-enum-const-class-timestamp
  3. Change the database column type to date in Oracle and check from report browser.

Published August 24, 2018 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us