I am seeing this error message in the errors.txt log file of Workload Automation DE r12. What is the cause of this exception?
20xx0908 14:20:40.840 [ss:trigger] [ERROR] SS.tdr-executer: [20xx-09-08_14:20:40.839] Exception: The record for query UPDATE ESP_TDR_DATA SET FIRING='Y' WHERE FIRING='P' was not updated: the table key is null
com.cybermation.espresso.rdbms.DatabaseUpdateException: The record for query UPDATE ESP_TDR_DATA SET FIRING='Y' WHERE FIRING='P' was not updated: the table key is null
at com.cybermation.espresso.rdbms.RelationalDatabaseManager.doGenericUpdate(RelationalDatabaseManager.java:870)
at ...
Release: 12.x
Component: Workload Automation DE
At startup, Workload Automation DE is seeking for all TDRs (records) which were in progress before the server went down (set with 'P' in the FIRING field). These TDRs should be processed again so DE is trying to mark them as ‘Ready to Progress’ (‘Y’).
Note: The initial value of the 'FIRING' field is ‘N’, which means not yet eligible to process.
Hence, the exception in question is getting logged when there are no TDRs (records) to set with ‘Y’; an empty table here would be an occasion of it.