Clarity PPM: Upgrade Issues Encountered with MSSQL database

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

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


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



CA PPM 15.4.1
Microsoft SQL Server

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

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:

3. Set the compatibility mode:

4. Database analysis and maintenance

Additional Information: