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

RS delete task element with revision dates

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 12.1.4
    • Component/s: Course
    • Labels:
      None

      Description

      https://olat.xyz.ch/auth/RepositoryEntry/382009344/Editor/0
      Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; MALC; rv:11.0) like Gecko ^%^ **RedScreen** org.hibernate.exception.ConstraintViolationException: could not execute statement
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_stepslayout</compname>
      		<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.control.Event</class&gt;
      			<command>validation finish</command>
      			<tostring>com:validation finish,org.olat.core.gui.control.Event@2f96e239</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.course.editor.PublishStep01AccessForm</controllername>
      		<controllername>org.olat.core.gui.control.generic.wizard.StepsMainRunController</controllername>
      		<controllername>org.olat.course.editor.EditorMainController</controllername>
      		<controllername>org.olat.course.run.CourseRuntimeController</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:289)
         at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:232)
         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.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1514)
         at org.olat.course.nodes.gta.manager.GTAManagerImpl.deleteTaskList(GTAManagerImpl.java:753)
         at org.olat.course.nodes.GTACourseNode.cleanupOnDelete(GTACourseNode.java:696)
         at org.olat.course.editor.PublishProcess.applyPublishSet(PublishProcess.java:451)
         at org.olat.course.editor.EditorMainController$3.execute(EditorMainController.java:1088)
         at org.olat.core.gui.control.generic.wizard.StepsMainRunController.finishWizard(StepsMainRunController.java:391)
         at org.olat.core.gui.control.generic.wizard.StepsMainRunController.event(StepsMainRunController.java:374)
         at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:246)
         at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
      >>> 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.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:437)
         at org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:374)
         at org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1510)
      >>> stack of 4.cause::org.postgresql.util.PSQLException: ERROR: update or delete on table "o_gta_task" violates foreign key constraint "gtaskrev_to_task_idx" on table "o_gta_task_revision_date"
      

        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 - 10 minutes
                10m