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(?)}
Release : 16.x
Component : Clarity Project Management
After looking at DB Logs it was determined that it's an issue with SQL Server 2019 when Change Tracking is enabled.
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.