Support Article

Filter on report generates an error due to timestamp column



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.


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 16, 2016 - Updated September 27, 2016

Have a question? Get answers now.

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