Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

  1. Create a report.
  2. Apply Filter.
  3. 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.
Suggest Edit

Published March 14, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

100% found this useful

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us