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

RS: use a deleted assessment test session

    XMLWordPrintable

    Details

      Description

      2017-10-03 13:14:49,956 [ajp-nio2-8010-exec-359] ERROR OLATRuntimeException - OLAT::ERROR ^%^ N10-E427 ^%^ org.olat.core.logging
      https://xyz.openolat.com/auth/RepositoryEntry/96403547
      
      Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Safari/604.1.38 ^%^ **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.core.gui.components.form.flexible.impl.FormEvent</class&gt;
       			<command>done</command>
       			<tostring>com:done,org.olat.core.gui.components.form.flexible.impl.FormEvent@2f23a1</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>
        
      >>> stack of 1.cause::org.olat.core.logging.OLATRuntimeException: org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.olat.core.gui.exception.ExceptionWindowController.<init>(ExceptionWindowController.java:116)
         at org.olat.core.gui.exception.MsgFactory.createMessageChiefController(MsgFactory.java:57)
         at org.olat.core.gui.exception.MsgFactory.createMessageChiefController(MsgFactory.java:46)
         at org.olat.core.gui.components.Window.dispatchRequest(Window.java:549)
         at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:242)
         at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
         at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:273)
         at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:190)
         at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:292)
         at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:235)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
      >>> stack of 2.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.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162)
         at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:787)
         at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:765)
         at org.olat.ims.qti21.manager.AssessmentItemSessionDAO.createAndPersistAssessmentItemSession(AssessmentItemSessionDAO.java:60)
         at org.olat.ims.qti21.manager.QTI21ServiceImpl.getOrCreateAssessmentItemSession(QTI21ServiceImpl.java:585)
         at org.olat.ims.qti21.ui.AssessmentTestDisplayController.handleResponse(AssessmentTestDisplayController.java:1012)
         at org.olat.ims.qti21.ui.AssessmentTestDisplayController.processQTIEvent(AssessmentTestDisplayController.java:625)
         at org.olat.ims.qti21.ui.AssessmentTestDisplayController.event(AssessmentTestDisplayController.java:459)
         at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:246)
      >>> stack of 3.cause::org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
         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:208)
         at org.hibernate.dialect.identity.GetGeneratedKeysDelegate.executeAndExtract(GetGeneratedKeysDelegate.java:57)
         at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:42)
         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2909)
         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3480)
         at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
         at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:626)
      >>> stack of 4.cause::org.postgresql.util.PSQLException: ERROR: insert or update on table "o_qti_assessmentitem_session" violates foreign key constraint "qti_itemsess_to_testsess_idx"
      
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            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 - 2 hours, 5 minutes
                2h 5m