Report Definition filter throwing BadTableMapplingException
User reported that they are experiencing an error on a report which has a filter on a date property.
An error occured on executing the query for the report definition - Database column <unknown> in database pegadata, table <unknown> has an unknown type: JDBC Type: Date
com.pega.pegarules.pub.database.BadTableMappingException: Database column <unknown> in database pegadata, table <unknown> has an unknown type: JDBC Type: Date
Steps to Reproduce
- Create a report.
- Apply Filter.
- Run the report.
A defect or configuration issue in the operating environment:
External table was created and mapped date property to text
Perform the following local-change:
Change the property type from text to VARCHAR or CHARACTER VARYING in Postgre.