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

QTI 2.1: coach deleted the result of a running test

    XMLWordPrintable

    Details

      Description

      This red screen is not visible. It is produced by the auto save of an essay question.

      020-07-13 17:14:34.964 [ajp-nio2-8021-exec-19] ERROR OLATRuntimeException ^%^ I1326894-J253738 ^%^ org.olat.core.logging.OLATRuntimeException 
      https://lms.xyz.de/auth/RepositoryEntry/3499982874
      Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.1 Safari/605.1.15
      
      **RedScreen** org.hibernate.exception.ConstraintViolationException: could not execute statement
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_at_run</compname>
      		<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.ims.qti21.ui.QTIWorksAssessmentTestEvent</class&gt;
      			<command>tmpResponse</command>
      			<tostring>com:tmpResponse,org.olat.ims.qti21.ui.QTIWorksAssessmentTestEvent@48683297</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.ims.qti21.ui.AssessmentTestDisplayController$QtiWorksController</controllername>
      		<controllername>org.olat.ims.qti21.ui.AssessmentTestDisplayController</controllername>
      		<controllername>org.olat.ims.qti21.ui.QTI21RuntimeController</controllername>
      		<controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername>
      	</controllerinfo>
      </dispatchinfo>
      
      org.olat.core.logging.OLATRuntimeException: org.hibernate.exception.ConstraintViolationException: could not execute statement
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
       at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
       at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
       at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
       at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:708)
       at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:688)
       at org.olat.ims.qti21.manager.AssessmentItemSessionDAO.createAndPersistAssessmentItemSession(AssessmentItemSessionDAO.java:61)
       at org.olat.ims.qti21.manager.QTI21ServiceImpl.getOrCreateAssessmentItemSession(QTI21ServiceImpl.java:707)
       at org.olat.ims.qti21.ui.AssessmentTestDisplayController.handleTemporaryResponse(AssessmentTestDisplayController.java:1116)
       at org.olat.ims.qti21.ui.AssessmentTestDisplayController.processQTIEvent(AssessmentTestDisplayController.java:797)
       at org.olat.ims.qti21.ui.AssessmentTestDisplayController.event(AssessmentTestDisplayController.java:523)
       at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:250)
       at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
       at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:247)
       at org.olat.core.gui.control.DefaultController.fireEvent(DefaultController.java:194)
       at org.olat.ims.qti21.ui.AssessmentTestDisplayController$QtiWorksController.fireTemporaryResponse(AssessmentTestDisplayController.java:2181)
       at org.olat.ims.qti21.ui.AbstractQtiWorksController.processTemporaryResponse(AbstractQtiWorksController.java:135)
       at org.olat.ims.qti21.ui.AssessmentTestDisplayController$QtiWorksController.formInnerEvent(AssessmentTestDisplayController.java:2143)
       at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:430)
       at org.olat.ims.qti21.ui.AssessmentTestDisplayController$QtiWorksController.event(AssessmentTestDisplayController.java:2112)
       at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:206)
       at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240)
       at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
       at org.olat.core.gui.components.AbstractComponent.fireEvent(AbstractComponent.java:238)
       at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.fireFormEvent(FormWrapperContainer.java:131)
       at org.olat.core.gui.components.form.flexible.impl.Form.fireFormEvent(Form.java:717)
       at org.olat.ims.qti21.ui.components.AssessmentTestFormItem.evalFormRequest(AssessmentTestFormItem.java:244)
       at org.olat.core.gui.components.form.flexible.impl.Form$EvaluatingFormComponentVisitor.visit(Form.java:626)
       at org.olat.core.util.component.FormComponentTraverser.doVisit(FormComponentTraverser.java:65)
       at org.olat.core.util.component.FormComponentTraverser.doVisit(FormComponentTraverser.java:70)
       at org.olat.core.util.component.FormComponentTraverser.visitAll(FormComponentTraverser.java:60)
       at org.olat.core.gui.components.form.flexible.impl.Form.evalFormRequest(Form.java:265)
       at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.doDispatchRequest(FormWrapperContainer.java:100)
       at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
       at org.olat.core.gui.components.Window.doDispatchToComponent(Window.java:1220)
       at org.olat.core.gui.components.Window.dispatchRequest(Window.java:400)
      ... 39 more
      Caused by: 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:113)
       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200)
       at org.hibernate.dialect.identity.GetGeneratedKeysDelegate.executeAndExtract(GetGeneratedKeysDelegate.java:57)
       at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:43)
       at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
       at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3728)
       at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:84)
       at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:645)
       at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:282)
       at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:263)
       at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:317)
       at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:335)
       at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:292)
       at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:198)
       at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:128)
       at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:192)
       at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:135)
       at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:62)
       at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:108)
       at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:702)
      ... 70 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`olat`.`o_qti_assessmentitem_session`, CONSTRAINT `qti_itemsess_to_testsess_idx` FOREIGN KEY (`fk_assessmenttest_session`) REFERENCES `o_qti_assessmenttest_session` (`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:425)
       at com.mysql.jdbc.Util.getInstance(Util.java:408)
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
       at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
       at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
       at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
       at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
       at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:87)
       at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:87)
       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
       ... 88 more
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Tester:
            Mandy Menzel
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: