Control Room & Scheduler

Expand all | Collapse all

Database upgrade failed after Blue Prism upgrade

  • 1.  Database upgrade failed after Blue Prism upgrade

    Posted 02-17-2020 16:23
    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
    ------------------------------


  • 2.  RE: Database upgrade failed after Blue Prism upgrade

    Posted 02-18-2020 06:48
    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
    ------------------------------



  • 3.  RE: Database upgrade failed after Blue Prism upgrade

    Posted 02-19-2020 09:20
    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
    ------------------------------