Exception: The record for query UPDATE ESP_TDR_DATA SET FIRING='Y' WHERE FIRING='P' was not updated: the table key is null

Document ID : KB000046489
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction: 

I am seeing this error message in the errors.txt log file of CAWA DE r12: 

20160908 14:20:40.840 [ss:trigger] [ERROR] SS.tdr-executer: [2016-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 ...

Question: 

What is the cause of this exception?

Answer: 

 

At the startup the DE is seeking for all TDRs (the records) which were in progress before the server went down (set with 'P' in the FIRING field). These TDRs should be processed again and so DE is trying to mark them as ‘Ready to Progress’ (‘Y’). 
NB. The initial value of the 'FIRING' field is ‘N’, means not yet eligible to process. 

Hence, the exception in question is getting logged when there are no TDRs to set with ‘Y’; an empty table here would be an occasion of it.