Support Article
BadTableMappingException when exposing property of Date type
SA-72459
Summary
BadTableMappingException occurs when exposing Date type property.
Error Messages
An error occurred 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 property (MyDate) of type Date that is mapped to an ORACLE datatype of DATE type.
Root Cause
A software use or operation error.
A property of DATE type was mapped to a datatype of DATE type in ORACLE.
The Pega property of DATE type does not have a time component. The ORACLE datatype DATE has a time component and is not a supported type to map to from Pega. ORACLE does not have a Date type without a time component.
Resolution
Perform the following local-change:
For Date type properties, map to ORACLE datatype of type VARCHAR2 (8).
Published March 20, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.