Author: Jonathan Rivera
Date: July 23, 2024
Audience: Jama Connect® Administrators
Environmental details: Self-hosted, Replicated - Native/Traditional, Replicated - KOTS, Microsoft SQL Server (not MySQL)
Summary
When trying to unarchive a project, it does not work. This causes the entire Jama Connect application to freeze/hang and requires a restart.
You may see that the Activating Project window does not show progress.
Solution
Run the following statement in SQL Server, replacing <DATABASE NAME> with your database name:
SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name= '<DATABASE NAME>';
If the return value of the above value is 0, then you need to turn on "READ_COMMITTED_SNAPSHOT." To do so, run the following statement:
ALTER DATABASE <DATABASE NAME> SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE;
Cause
READ_COMMITED_SNAPSHOT is turned off in the SQL Server database.
Prevention
This is a critical step during the installation process when configuring SQL Server. It does not affect MySQL. Our user Guides mention it.
Related Articles, Work orders, Zendesk tickets, Defects, etc.
Additional Information/Metadata
- Installation
- Migration
Please feel free to leave feedback in the comments below.
Related to
Comments
0 comments
Please sign in to leave a comment.