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

RS if a group task was only in draft

    XMLWordPrintable

    Details

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

      Description

      How to reproduce:

      • create a course template with a group task element, configure it.
      • copy the course template
      • delete the copied course without publishing it
      2015-10-06 16:06:57,883 [ajp-nio2-8059-exec-9] ERROR DBRuntimeException - OLAT::ERROR ^%^ N59-E37 ^%^ org.olat.core.logging 
      
      Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:40.0) Gecko/20100101 Firefox/40.0 ^%^ **RedScreen** commit failed, rollback transaction
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_confirm_delete</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.repository.ui.author.ConfirmDeleteController</controllername>
      		<controllername>org.olat.repository.ui.author.AuthorListController</controllername>
      		<controllername>org.olat.repository.ui.author.OverviewAuthoringController</controllername>
      		<controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername>
      	</controllerinfo>
      </dispatchinfo>
      
      >>> stack of 1.cause::org.olat.core.logging.DBRuntimeException: commit failed, rollback transaction
      -> at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:782)
         at org.olat.repository.manager.RepositoryServiceImpl.deleteRepositoryEntryAndBaseGroups(RepositoryServiceImpl.java:357)
         at org.olat.repository.manager.RepositoryServiceImpl.delete(RepositoryServiceImpl.java:335)
         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:408)
         at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:202)
         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)
      >>> stack of 2.cause::javax.persistence.RollbackException: Error while committing the transaction
      -> at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:94)
         at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:736)
         at org.olat.repository.manager.RepositoryServiceImpl.deleteRepositoryEntryAndBaseGroups(RepositoryServiceImpl.java:357)
         at org.olat.repository.manager.RepositoryServiceImpl.delete(RepositoryServiceImpl.java:335)
         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:408)
         at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:202)
         at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240)
         at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
      >>> stack of 3.cause::javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
         at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
         at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:82)
         at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:736)
         at org.olat.repository.manager.RepositoryServiceImpl.deleteRepositoryEntryAndBaseGroups(RepositoryServiceImpl.java:357)
         at org.olat.repository.manager.RepositoryServiceImpl.delete(RepositoryServiceImpl.java:335)
         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:408)
         at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:202)
      >>> stack of 4.cause::org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:72)
         at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
         at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3403)
         at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3630)
         at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:114)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
         at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
      >>> stack of 5.cause::com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`avaloq`.`o_gta_task_list`, CONSTRAINT `gta_list_to_repo_entry_idx` FOREIGN KEY (`fk_entry`) REFERENCES `o_repositoryentry` (`repositoryentry_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:422)
         at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
         at com.mysql.jdbc.Util.getInstance(Util.java:360)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            cfranck Christian Franck
            Tester:
            Kirsten Scherer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

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