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(?)}
After looking at DB Logs it was determined that it's an issue with SQL Server 2019 when Change Tracking is enabled.
Release : 16.0.1
Component : Clarity Project Management
According to Microsoft's KB Article We need to implement Cumulative Update 4 for SQL Server 2019 to overcome this issue.
SQL Server DB's not using Change Tracking might not run into this issue.