During the Vault install/upgrade, PreInstallCheck.bat does not check for missing grants for the Vault and RAS schemas. Vault installer fails if symyxdb schema does not have 'Create any trigger' grant.
ERROR:
Failed to load file AllChemStruc_Group.red. Server save operation returned error: -1
Problem: Database error: (Caused by: Database error: Failed to activate MetadataObjectGroup (Caused by: Failed to execute SQL: create or replace trigger CHEMSTRUCS_TRG Before Insert or Update on ALLCHEMSTRUCS For Each Row BEGIN :new.MOLFORM := mdlaux.molfmla(null, :new.Structure); if :new.CONCHECK is null then :new.CONCHECK := 1; end if; if :new.STATUS is null then :new.STATUS := 0; end if; END; (Caused by: ORA-01031: insufficient privileges )))
A new feature request NBK-33884: 'Vault installer should grant all necessary permissions to vault schemas required for successful deployment' was entered in BIOVIA Jira and it is fixed in BIOVIA Workbook 2023 release.