KB-1242 "Unable to convert to expected Date/Time Java types" error repeated in application server log


The following error is repeated in the application server log:

ERROR com.appiancorp.process.runtime.activities.QueryRdbmsActivity - Unable to convert to expected Date/Time Java types

There is no error on the front end.


This will happen if Appian pulls back a date/datetime column from a database and one of the values in that column is null.


This error can be ignored. This has been reported to the Appian product team as AN-45088 to improve the exception handling.

To determine what table is causing the problem, follow the steps below:

  1. Navigate to <APPIAN_HOME>/ear/suite.ear/resources
  2. Search for the following line in the appian_log4j.properties and change the logging level to DEBUG as follows:


This will print DEBUG lines in the application server log and the output will show what query is causing this problem. You can then decide from there whether you should add a default value to that field which is null.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: March 2017