Did you verify if you have the DB owner rights, please check that, other option is generate the upgrade script and run it, please see below.
Upgrade Script
AutomateC.exe can be used to generate a script and save it on a local device which, when run against an existing Blue Prism database, updates the schema and configuration to be appropriate for the version of Blue Prism.
C:\Program Files\Blue Prism Limited\Blue Prism Automate>Automatec.exe /getdbscript /fromrev 10 > "c:\temp\UpgradeScript.sql"
Snapshot Isolation Enablement Required
Since version 6.4.2, it is required that "Allow Snapshot Isolation setting" in the database is turned on. By default, SQL server does not enable this feature. However, it is done through the upgrade script when BP is installed. Please see release notes for more information.
alter database CURRENT set ALLOW_SNAPSHOT_ISOLATION on
------------------------------
Shibu Tewar
VP
Credit Suisse
Asia/Kolkata
------------------------------
