KB 10094 Duplicated backup policies

KB ID: 10094

Product: Storware Backup & Recovery

Version: 5.1.1

Published: 2023-03-29

Last modified: 2023-03-29

When creating a new Schedule, we can see duplicate backup policies in the "Choose Virtual Environment policies" section.

Below you can find fix for multiple rules. (And sql file at the bottom which is needed to fix issue)

  1. SSH login to Storware Backup & Recovery server

  2. Backup DB using script located in opt/vprotect/scripts ; backup is stored in /tmp - please remember to move it to safer location

  3. Stop vprotect-server service:

systemctl stop vprotect-server

4. Execute cat /opt/vprotect/payara.properties ; At the end of the result there will be user (vprotect) and Password for db

5. Execute cat DB_fix.sql | mysql -u vprotect -pPassword vprotect

6. Start service

systemctl start vprotect-server