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)
SSH login to Storware Backup & Recovery server
Backup DB using script located in opt/vprotect/scripts ; backup is stored in /tmp - please remember to move it to safer location
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