When running a query rule, users can see a vague error similar to the following:
Expression evaluation error in rule '<rule name>' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [<CDT name>], query: [<rule name>], order by: [], filters:[null])
The error seen above in Appian generated the following error in the application server log:
18:07:45,501 INFO [stdout] (ajp-/0.0.0.0:8009-5) 2015-10-15 18:07:45,501 [ajp-/0.0.0.0:8009-5] ERROR org.hibernate.util.JDBCExceptionReporter - Value '0000-00-00' can not be represented as java.sql.Date
In the database table that this query rule was querying, there was a date column that had the value 0000-00-00 in one of its rows. Such a date is outside the possible range of values for date types, and could not be displayed.
Either delete the invalid data in the table’s row, or modify it so that it is readable by Appian.
This article applies to all versions of Appian.
Last Reviewed: February 2017
© 2019 Appian. All rights reserved.