Symptoms
vProtect GUI returns 'runtime' error when click Dashboard/HYPERVISORS/VIRTUAL ENVIRONMENTS
From the logs, we could see below repeated key error from server.log:
javax.ejb.EJBTransactionRolledbackException: Exception thrown from bean: javax.persistence.EntityNotFoundException: Unable to find com.dell.vprotect.api.entity.restorejob.RestoreJob with id 6026587f-15bc-45b4-a4f2-dd75980e1e82
Below key error from vprotect-daemon.log:
[] APIErrorException: ERROR: RUNTIME_ERROR
Server has encountered the runtime error
com.dell.vprotect.engine.api.controller.VirtualMachineController.listDetailed(VirtualMachineController.java:67)
.....
Cause
User has 2 VM’s with the same name, and one was removed from inventory, and reference from that restore job was not removed after that. That reference will be removed on upgrade, or just only restart vprotect-server service.
Resolution
Solution: Upgrade to 19.6 would resolve this issue.
Workaround:
1. Log into vProtect.
2. Get the restorejob id (6026587f-15bc-45b4-a4f2-dd75980e1e82) from server.log:
javax.ejb.EJBTransactionRolledbackException: Exception thrown from bean: javax.persistence.EntityNotFoundException: Unable to find com.dell.vprotect.api.entity.restorejob.RestoreJob with id 6026587f-15bc-45b4-a4f2-dd75980e1e82
3. Run cat or more command to get the MariaDB password from /opt/vprotect/payara.properties file in line com.dell.vprotect.db.password=.
4. Log into Maria DB: mysql -u vprotect -pPASSWORD //replace PASSWORD by the real password from step 3 and notice there’s no space between -p and PASSWORD.
5. Switch to “vprotect” if it’s showing “none”: use vprotect;
6. Update the database: UPDATE protectedentity SET LASTRESTOREJOB=NULL WHERE LASTRESTOREJOB='6026587f-15bc-45b4-a4f2-dd75980e1e82';
7. No more action required, you can re-login vProtect GUI and the error is gone.
refer to DEVS-46 and DEVS-91
Affected Products
vProtect