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

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

book

Article ID: 46489

calendar_today

Updated On:

Products

DSERIES- SERVER CA Workload Automation DE - System Agent (dSeries) CA Workload Automation DE CA Workload Automation DE - Scheduler (dSeries)

Issue/Introduction

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 ...

 

Environment

Release: 12.x
Component: Workload Automation DE 

Resolution

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.