CA PPM: Upgrade Issues Encountered (MSSQL)

Document ID : KB000106041
Last Modified Date : 11/07/2018
Show Technical Document Details
Issue:

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. Intermittent slowness navigating the application and portlets

 

Environment:

CA PPM 15.4.1
Microsoft SQL Server

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

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

1. 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

2. 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

3. Database analysis and maintenance