Database operation fails for Testrun articles

Tuesday, October 4, 2011 7:36:24 AM
How can I resolve this?

ACTION:

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

Results:

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.

ADDITIONAL INFORMATION:

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 7:43:26 AM
Avatar
re: mtha on Tuesday, October 4, 2011 7:36:24 AM
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 3:47:38 PM
Avatar
re: mtha on 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.
Statistics
  • Started: Tuesday, October 4, 2011 7:36:24 AM
  • Last Reply: Tuesday, October 4, 2011 3:47:38 PM
  • Replies: 2
  • Views: 1150