Support Article
Filter on report generates an error due to timestamp column
SA-28080
Summary
When the user tries to perform filter on the column which has the column type as "TimeStamp(7)" in Oracle database, it gives an error.
Error Messages
An error occurred during resolving the report definition - Name: Property Type: DATETIME, Column Type: DATE, Literal Value: "20160826T074053.000 GMT" - are not of the same type.
Steps to Reproduce
1. Create a Report definition with a column which has coulmn type in Database as "TimeStamp".
2. Run the report.
3. Perform filter on that column which has "TimeStamp" as column type in Database.
4. Observe the error on the screen.
Root Cause
Report definition code supports TIMESTAMP(6) and the column data type user is using is of TIMESTAMP(7). Hence is the error.
Resolution
Alter the table column type to use TIMESTAMP(6) instead of TIMESTAMP(7). Else use joins in the report definition instead of mapping a view to the class.
Published September 27, 2016 - 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.