Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Jubula » Periodic Error: "Cannot delete test result"
Periodic Error: "Cannot delete test result" [message #1405908] Fri, 08 August 2014 13:03
Carsten Neumann is currently offline Carsten NeumannFriend
Messages: 7
Registered: July 2014
Junior Member
Hi,

several times every day we get this error:

"Cleaning Testresults in Database for Project 'myProject' has encountered a problem.
An internal error occurred during: 'Cleaning Testresults in Database for Project 'myProject'".

At the same time this error is shown:
2061: Cannot delete test result.
  org.eclipse.jubula.tools.exception.JBException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
  Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'myproject_jubula_tests.testresult' doesn't exist
  Error Code: 1146
  Call: SELECT t0.INTERNAL_TESTRUN_ID FROM TESTRESULT t0 WHERE t0.INTERNAL_TESTRUN_ID IN (SELECT t1.ID FROM TESTRESULT_SUMMARY t1 WHERE ((((t1.TS_DATE < ?) AND (t1.INTERNAL_PROJECT_GUID = ?)) AND (t1.PROJECT_MAJOR_VERSION = ?)) AND (t1.PROJECT_MINOR_VERSION = ?)))
  	bind => [4 parameters bound]
  Query: ReportQuery(referenceClass=TestResultPO sql="SELECT t0.INTERNAL_TESTRUN_ID FROM TESTRESULT t0 WHERE t0.INTERNAL_TESTRUN_ID IN (SELECT t1.ID FROM TESTRESULT_SUMMARY t1 WHERE ((((t1.TS_DATE < ?) AND (t1.INTERNAL_PROJECT_GUID = ?)) AND (t1.PROJECT_MAJOR_VERSION = ?)) AND (t1.PROJECT_MINOR_VERSION = ?)))")
  	at org.eclipse.jubula.client.core.persistence.TestResultSummaryPM.findTestResultSummariesByDate(TestResultSummaryPM.java:296)
  	at org.eclipse.jubula.client.core.persistence.TestResultPM.cleanTestresultDetails(TestResultPM.java:220)
  	at org.eclipse.jubula.client.ui.rcp.handlers.project.OpenProjectHandler$OpenProjectOperation$2.run(OpenProjectHandler.java:169)
  	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)


The table 'myproject_jubula_tests.testresult' does not exist in my database.

We are using Jubula 8 with a MySQL. Can anyone please help me with this problem?

Thanks!

Regards,
Carsten
Previous Topic:Not allowed to save an unlocked workversion
Next Topic:Event handler does not propagate component name: Workaround wanted
Goto Forum:
  


Current Time: Mon Jul 06 01:12:46 GMT 2015

Powered by FUDForum. Page generated in 0.01715 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software