Support Article
Report definition and List view do not display timestamp values
SA-12720
Summary
Report definition and List view do not display timestamp values when Oracle column type is TimeStamp and Pega property type is DateTime.
Error encountered as below, on executing the report definition.
Error Messages
Encountered a result set that has a column of an unrecognized type
Steps to Reproduce
1. Map a DateTime PRPC property to Oracle TimeStamp column type.
2. Run the report.
Root Cause
The root cause of this problem is software use/operation error.
Resolution
Oracle TimeStamp column type is only supported from Pega 7.1.8 onwards.
http://pdn.pega.com/node/139666
http://pdn.pega.com/node/140316
Published August 12, 2015 - 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.