Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
Serdar Fener
(18●6●6) edited
May 05 '14, 9:37 a.m.
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?

0 votes

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

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

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

Hi Krzysztof,

Vendor: Microsoft SQL St Edition

Version: 2008 R2

Server: Windows Server 2008 R2


1 answer
5,054 views
0 votes

Accepted answer

Permanent link
Krzysztof Kaźmierczyk
(7.5k●4●80●103) 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

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 82

Question asked: Apr 28 '14, 9:09 a.m.

Question was seen: 5,054 times

Last updated: May 05 '14, 9:37 a.m.

Confirmation Cancel Confirm