topic RE: Database upgrade failed after Blue Prism upgrade in Product Forum

Database upgrade failed after Blue Prism upgrade

Sameer — Mon, 17 Feb 2020 16:23:00 GMT

Hi, I have upgraded Blue prism form 6.4.2 version to 6.6, but while upgrading database in blue prism connection i'm getting below error.

------------------------------
Sameer
Europe
------------------------------

RE: Database upgrade failed after Blue Prism upgrade

ShibuTewar — Tue, 18 Feb 2020 06:48:00 GMT

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
------------------------------

RE: Database upgrade failed after Blue Prism upgrade

Walter.Koller — Wed, 19 Feb 2020 09:20:00 GMT

We ran into the same issue and as far as I know it is a common problem.

We found two solutions:
- have the scripts generated by Blue Prism and run them manually
- elevate permissions of the database user to sysadmin (solution provided by BP support)

------------------------------
Walter Koller
Solution Manager
Erste Group IT International GmbH
Europe/Vienna
------------------------------