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 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.