DB Upgrade 6.4.2 -> 6.5 VIEW SERVER STATE permission was denied on object 'sevrer' database 'master' The user does not have permsission to perform this action

[SilvioGerstenbe]

Hello together,

we try to upgrade our BP Dev System and get this error on our BP DB Admin User.
Is it a bug? The user was used in the past for every db update and has done it successfully.

Please help.
Thanks in advance.



------------------------------
Silvio Gerstenberger
RPA Developer
Schneider Electric
Europe/London
------------------------------

[SamanthaShaw]

Hi Silvio

This error occurs because there is an additional permissions requirement to perform the 6.5 upgrade.

Specifically, the error message indicates that the user performing the database upgrade needs the 'VIEW SERVER STATE' database permission in order to allow you to run the sys.dm_db_partition_stats system view, which is used to determine size of the session log table before the ugprade commences. This permission is required in order to allow you to run the sys.dm_db_partition_stats system view.

The following Microsoft article provides further details on this issue:

sys.dm_db_partition_stats (Transact-SQL)

How to resolve your issue

To fix this issue, you will need to ask your Database Administrator to grant this permission to the user.

The following command can be run to grant the permission (where "dbid" is the user to grant the permission to):

 

use master;
grant view server state to "dbid";

Note: It may be simpler to temporarily give your user the sysadmin user role if this would be appropriate in your environment.

This action is only required once and the permission can be revoked again once the upgrade is completed.

Further details can be found in our Knowledge Base article here - http://portal.blueprism.com/customer-support/support-center#/path/1341252052

Hope that helps! 🙂

------------------------------
Samantha Shaw
Head of Customer Support (EMEA)
Blue Prism
Europe/London
------------------------------

[SilvioGerstenbe]

Hi Samantha,

thanks a lot for the helping hints.

We have solved it now.

Wish you a nice week.

BR
Silvio

------------------------------
Silvio Gerstenberger
RPA Developer
Schneider Electric
Europe/London
------------------------------