Unable to Open Project In Clarity Classic UI with SQL Server 2019

Products

• Clarity PPM On Premise

Issue/Introduction

We are getting the below error when we open a Project in after we upgraded to 16.0.1.

ERROR 2022-04-08 11:29:31,441 [https-jsse-nio2-443-exec-141] niku.odf (clarity:admin:projmgr.projectProperties) Error in fetching obs unit : SQL error code: 596 Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot continue the execution because the session is in the kill state. Executed: {? = call OBS_UNIT_FULL_PATH(?)}

Environment

Release : 16.x

Component : Clarity Project Management

Cause

After looking at DB Logs it was determined that it's an issue with SQL Server 2019 when Change Tracking is enabled.

Resolution

According to Microsoft's KB Article  We need to implement Cumulative Update 4 for SQL Server 2019 to overcome this issue. 

Additional Information

SQL Server DB's not using Change Tracking might not run into this issue.