ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Clarity PPM: Upgrade Issues Encountered with MSSQL database


Article ID: 106041


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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



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


CA PPM 15.4.1
Microsoft SQL Server


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