search cancel

Unable to Open Project In Clarity Classic UI after upgrade to 16.0.1 and SQL Server 2019

book

Article ID: 239279

calendar_today

Updated On:

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(?)}

Cause

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

Environment

Release : 16.0.1

Component : Clarity Project Management

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.