EasyProjects
Easy Projects is Work and Project Management Software that is designed to help teams of all sizes collaborate more effectively, stay on budget and deliver projects faster.
Birdview
Birdview PSA is a professional services automation platform built for organizations that want to better manage their entire delivery lifecycle. It includes all of the features and functionality of Easy Projects, plus an added layer of advanced functionality and financial tools for billing clients and tracking revenue and profit.
Submit a Ticket Login Sign Up

How can we help?

Articles in this section

See more

Error: The transaction has aborted

Avatar
Niha
  • Updated
Follow

Q. In my inhouse EP instance I'm getting the following error when saving a project or an activity. I'm using SQL Server Express. 

The transaction has aborted
 

A. The important thing which helps to reduce lock contention in addition to upgrading to full SQL server version is the following script. It should be run on your SQL server where EP database is located. Before running the script the SQL server service should be restarted. Note that the text "MyDatabase" (two occurrences) should be replaced with a real database name of EP.

 

ALTER DATABASE MyDatabase

SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE MyDatabase

SET READ_COMMITTED_SNAPSHOT ON

Related articles