Database operation fails for Testrun articles

Tuesday, October 4, 2011
How can I resolve this?


1.  Goto Testrun page
2.  Check 1 to many items
3.  Either click the Delete button or R-click/Delete


The page shows it is endlessly working.  On refresh a message occurs, System Error: The server method 'Retrieve' failed.

Expected Behavior:

Items should successfully delete.


I have coupled SpiraTeam with my method of test automation.  I have built a webservice layer that manages the following operations:
- Get testcases via testsets
- Get data from documents in Spirateam
- Dynamically create a release
- Upload results to Spirateam
- Upload error documents to SpiraTeam
- Update the testset

I create a lot of unwanted data in SpiraTeam and after some time of testing and debugging, I consistently delete:

- Releases
- Testruns
- Attached documents

So there is a chance I have caused a corruption.  Is there a way to resolve the problem?
2 Replies
Tuesday, October 4, 2011
re: mtha Tuesday, October 4, 2011
When I attempted to delete the testruns from the testcase, this error occurs. 

Inflectra.SpiraTest.Business.ArtifactNotExistsException: Test Run 610 doesn't exist in the system.

I reviewed the database and it appears the items are not in the database but displayed in gui.
Tuesday, October 4, 2011
re: mtha Tuesday, October 4, 2011
That means the test runs were deleted. It may be that so many had to be deleted that it timed out during the deletion. To resync up the test case data, go to Administration > Data Tools and click on the option to Refresh the Test Execution Status. That should fix the issue.

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885


  • Started: Tuesday, October 4, 2011
  • Last Reply: Tuesday, October 4, 2011
  • Replies: 2
  • Views: 2700