Clarity PPM: Upgrade Issues Encountered with MSSQL database

Article Id: 106041

Status: Published

Updated On: 23-01-2019 22:41

Products:

CLARITY PPM FOR ITG CA Project & Portfolio Management CLARITY PPM FEDERAL CA Project & Portfolio Management SAAS STARTER PACK-CLARITY PPM

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