Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-2404

RS deleting a course with QTI 2.1 results

    Details

      Description

      Fehlernummer: N26-E34 
      2016-12-05 13:55:50,327 [ajp-nio2-8026-exec-2] WARN ExceptionWindowController - OLAT::WARN ^%^ N26-W4255 ^%^ org.olat.core.gui.exception
       https://xyz.olat.com/auth/RepositorySite/0/My/0
       Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0 ^%^ ExceptionWindowController: Throwable occurred, logging the full stacktrace:
       >>>stack of 1.cause::javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
       -> at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
          at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
          at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1471)
          at org.olat.modules.assessment.manager.AssessmentEntryDAO.deleteEntryForRepositoryEntry(AssessmentEntryDAO.java:310)
          at org.olat.repository.manager.RepositoryServiceImpl.delete(RepositoryServiceImpl.java:368)
          at org.olat.repository.ui.author.ConfirmDeleteController.deleteEntries(ConfirmDeleteController.java:289)
          at org.olat.repository.ui.author.ConfirmDeleteController.doCompleteDelete(ConfirmDeleteController.java:236)
          at org.olat.repository.ui.author.ConfirmDeleteController.formInnerEvent(ConfirmDeleteController.java:207)
          at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:430)
          at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:202)
          at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240)
      >>>stack of 2.cause::org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59)
         at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
         at org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:90)
         at org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:59)
         at org.hibernate.hql.internal.ast.exec.DeleteExecutor.execute(DeleteExecutor.java:110)
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:429)
         at org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:374)
         at org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1472)
      >>>stack of 3.cause::com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
      Cannot delete or update a parent row: a foreign key constraint fails (`bfgs`.`o_qti_assessmenttest_session`, CONSTRAINT `qti_sess_to_as_entry_idx` FOREIGN KEY (`fk_assessment_entry`) REFERENCES `o_as_entry` (`id`))
      -> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
         at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
         at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
         at com.mysql.jdbc.Util.getInstance(Util.java:387)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:932)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
      

        Attachments

          Activity

            People

            • Assignee:
              srosse Stéphane Rossé
              Reporter:
              sscheiwiler Sabrina Scheiwiler
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 5 minutes
                1h 5m