Clarity PPM: Upgrade Issues Encountered with MSSQL database

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The following are possible issue and resolutions that have been reported by customers on MSSQL:

Issues:

1. The upgrade gets stuck at the following line in the install.log: "Loading registered objects for building blocks bootstrap..."

2. Performance issues navigating the application and portlets

 

Cause

Each case is unique, however each reported solution can help in determining a resolution plan.

Environment

CA PPM 15.4.1
Microsoft SQL Server

Resolution

One or more of the resolutions will need to be performed by the DBA team:

1. Check the database transaction logs to see if there is a specific error.

2. Set the max degree of parallelism:

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-2014

3. Set the compatibility mode:

https://docs.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database?view=sql-server-2014

4. Database analysis and maintenance

Additional Information

https://comm.support.ca.com/kb/mssql-performance-with-ca-ppm-on-mssql-2014-with-compatibility-mode-120/kb000111084