Clarity upgrade fails on MSSQL VIEW SERVER STATE permission

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Clarity with SQL Server upgrade fails, error in logs or xml out files: 

<Exception><![CDATA[SQL Exception with error code : 300 message: [CA Clarity][SQLServer JDBC Driver][SQLServer]VIEW SERVER STATE permission was denied on object 'server', database 'master'.]]></Exception>

Environment

Release : All supported Clarity releases

Resolution

• VIEW SERVER STATE permission is required for the MSSQL databases with Clarity
• Rollback, grant the permission and start the upgrade again