The Transaction Analysis Server reports an exception on IBM DB2 systems if the explore_fields property contains a date field


You can update the explore_fields property to customize the list of fields available on the Explore tab. If explore_fields includes a date field, the Transaction Analysis Server reports an error while processing incoming transactions. This issue occurs only when the Transaction Data Repository (TDR) is an IBM DB2 database.

The error message in the log is as follows: 

2025-05-21T18:09:04,711 [es-indexer] INFO  QueueCallback #Waited(ms):524

java.lang.UnsupportedOperationException

     at java.sql/java.sql.Date.toInstant(Date.java:316)

     at com.sas.finance.fraud.analysis.elasticsearch.ESIndexableMap.toXContent
(ESIndexableMap.java:105)

     at com.sas.finance.fraud.analysis.elasticsearch.ESIndexableMap.toXContent
(ESIndexableMap.java:69)

     at com.sas.finance.fraud.analysis.elasticsearch.ESIndexableMap.toJsonBuilder
(ESIndexableMap.java:64)

     at com.sas.finance.fraud.analysis.elasticsearch.core.BulkProcessorApiImpl.
bulkIndex(BulkProcessorApiImpl.java:90)

     at com.sas.finance.fraud.analysis.elasticsearch.ESWritableIndexDAO.create
(ESWritableIndexDAO.java:44)

     at com.sas.finance.fraud.analysis.elasticsearch.ESWritableIndexDAO.create
(ESWritableIndexDAO.java:52)

     at com.sas.finance.fraud.analysis.elasticsearch.ESIndexCallback.callback
(ESIndexCallback.java:65)

     at com.sas.finance.fraud.analysis.elasticsearch.ESEnrichCallback.callback
(ESEnrichCallback.java:88)

     at com.sas.finance.fraud.analysis.components.callbacks.QueueCallback.get
(QueueCallback.java:89)

     at com.sas.finance.fraud.analysis.elasticsearch.actions.ESIngestAction.run
(ESIngestAction.java:197)

     at com.sas.finance.fraud.analysis.cron.SpringCron.runAction
(SpringCron.java:55)

     at com.sas.finance.fraud.analysis.cron.ESIngestCron.run
(ESIngestCron.java:19)

     at java.base/java.lang.Thread.run
(Thread.java:829)

2025-05-21T18:09:04,712 [es-indexer] ERROR ESIndexCallback unknown object class for value:java.sql.Date 2025-04-30 for key:RQO_TRAN_DATE_ALT=2025-04-30

java.io.IOException: unknown object class for value:java.sql.Date 2025-04-30 for key:RQO_TRAN_DATE_ALT=2025-04-30