Error evaluating function 'queryruleexec'

Question

When trying to view a Tempo Report I get error in Tempo. Error Evaluating UI Expression Expression evaluation error in rule 'getall_workloadanalysisreport_data_filtered' (called by rule 'workloadanalysisreport') at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [WorkloadAnalysisVWDT1968], query: [getAll_WorkLoadAnalysisReport_Data_Filtered], order by: [[]], filters:[((contractingOfficer includes TypedValue[it=3,v=]) AND (contractingOfficeCD includes TypedValue[it=3,v=]) AND (regionCD includes TypedValue[it=3,v=]) AND (status includes TypedValue[it=3,v=]) AND (endDate >= TypedValue[it=7,v=1991-01-11]) AND (endDate <= TypedValue[it=7,v=2040-04-23]) AND (teamMemberUsernames includes TypedValue[it=3,v=test.1@blank.com]))]) The log is as follows: 2015-09-01 11:56:05,113 [ajp-/0.0.0.0:8009-11] ERROR com.appiancorp.rest.shared.AppianExceptionMapper - Internal Server Error on REST API invocation... 
 OriginalPostID-165214 
 OriginalPostID-165214

Amitkumar · Accepted Answer

This is related to your database date / datetime columns having a bad data as "'0000-00-00 00:00:00'". Please check, if you have this bad data for any of the date / datetime columns, if yes correct it and see if you still get that error.