AutoPatch error: The worker should not have status 'Running' or 'Restarted' at this point.

Description of Issue

R12.2 ADOP: AutoPatch error: The worker should not have status 'Running' or 'Restarted' at this point. AutoPatch error: Error running SQL and EXEC commands in parallel

Cause

ADOP Patch Session got terminated abnormally due to network issue or patch hung or Lost connectivity. Error encountered when tried to re-start adop patch.

Solution

1. Start Adctrl and look at the worker status.  Are workers running or started?   Select option: 1. Show Worker Status then 4. Tell manager that a worker failed its job   2. Restart the adop patch from the begining. Use below options: - If you want to restart a failed patch from the very beginning, you need to specify below options with adop restart=no abandon=yes - If you want to restart a failed patch from where it left off, you only need to specify below options with adop restart=yes abandon=no