HPOO 10.50 The selected workers cannot be deleted
I have read the central user guide and installation & confi guides but there is no information on how to delete an old JRAS worker. When I disable it, it never goes into stopped status,. I tried deleting but it says the worker should be in a stopped status ebefoer deleting.
I uninstalled and re-installed HPOO 10.50 in preparation for 10.80 upgrade but the old JRAS worked are stuck in Running / Idle status. How can I delete these JRAS workers? I heard someone say that this may have to be done with an SQL update against an HPOO table but I have never done that. I am running RHEL 7.2
Any help would be greatly appreciated.
Please, perform a selection query againts the OO_WORKER_NODES table, pay attention to the ACK_VERSION field of the table, write down the number you see. Afterwards, try to disable the old RAS, then perform the same query again and write down the number. Is it the same number?
If so, run the query below, verify if the recoveryVersionJob is in a BLOCKED status.
select * from OO_TRIGGERS;
If indeed, the trigger was in a BLOCKED status, use the command below to change its status to WAITING.
update OO_TRIGGERS set TRIGGER_STATE = 'WAITING' where TRIGGER_NAME like '%recoveryVersionTrigger%';
Observe the behavior and let me know if their ACKVERSION from the OO_WORKER_NODES is still the same as before.
Customer Support Engineer
If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.