Scheduler log reported: [05/07/2019 16:22:57] CAUAJM_E_10163 Exhausted maximum number of query retries.
[05/07/2019 16:22:57] CAUAJM_E_10160 The execution of the below query experienced an unrecoverable error and will not be retried:
[05/07/2019 16:22:57] CAUAJM_E_10067 Failed to get an event identifier. Scheduler cannot recover and must shutdown.
What is the maximum number of query retries? Where is this set?
Component : CA Workload Automation AE (AutoSys)
The maximum number of retries after a query failure is hardcoded at 10. The thought behind this is that a typical query execution failure is expected to be repeated after the database monitoring system recovers from the loss of connection from the database server. If a query is not recovering, then there is an underlying issue at the database monitoring system that needs to be addressed. The database monitoring system is not supposed to let a query reach 10 failures. We consider that a catastrophic database error would be caught and proactively handled by the database monitoring system. If that is not happening, we need to understand why.
If the scheduler cannot generate an event identifier from the database, it cannot write an event. If the scheduler cannot write events, then it cannot continue. That is a terminating condition that triggers a graceful shutdown.