Support Article
Report Definition filter throwing BadTableMapplingException
SA-33446
Summary
User reported that they are experiencing an error on a report which has a filter on a date property.
Error Messages
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.
Root Cause
A defect or configuration issue in the operating environment:
External table was created and mapped date property to text
Resolution
Perform the following local-change:
Change the property type from text to VARCHAR or CHARACTER VARYING in Postgre.
Published March 14, 2017 - 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.