It's all about the answers!

Ask a question

Saving artifact causes “The transaction log for database "qmsuite" is full." message


Serdar Fener (1866) | asked Apr 28 '14, 9:09 a.m.
edited May 05 '14, 9:37 a.m. by Krzysztof Kaźmierczyk (7.4k34997)
After we try to save any artifact on RQM we get the following error saying: "Error raised in CLMTEST environment saying “The transaction log for database "qmsuite" is full."

We have encountered the issue before and we have cleared the transaction logs from the database and we were able to save artefacts. But after a while we encountered the same issue again. How can we avoid the issue to happen after and after again?

Comments
Krzysztof Kaźmierczyk commented Apr 28 '14, 9:20 a.m.

Hi Serdar,
What is your database vendor/version you use?


Serdar Fener commented Apr 28 '14, 9:34 a.m.

Hi Krzysztof,

Vendor: Microsoft SQL St Edition

Version: 2008 R2

Server: Windows Server 2008 R2


Accepted answer


permanent link
Krzysztof Kaźmierczyk (7.4k34997) | answered Apr 28 '14, 10:08 a.m.
edited May 05 '14, 9:30 a.m.
Try changing row version system for the database. From the command line tool, run this command:

ALTER DATABASE qm SET READ_COMMITTED_SNAPSHOT ON GO

If it does not help, please use following technote to fix the issue: Troubleshoot a Full Transaction Log (SQL Server Error 9002)
Serdar Fener selected this answer as the correct answer

Your answer


Register or to post your answer.