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

Cannot delete a business group associate with a lecture

    XMLWordPrintable

    Details

      Description

      2017-09-27 17:17:20,403 [ajp-nio2-8021-exec-33] ERROR DBRuntimeException - OLAT::ERROR ^%^ N1-E48 ^%^ org.olat.core.logging
      https://lms.xyz.de/auth/GroupsSite/0/AllGroups/0 ^%^ Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2486.0 Safari/537.36 Edge/13.10586
      **RedScreen** commit failed, rollback transaction
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_group_delete_confirmation</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 ok</command>
      			<tostring>com:validation ok,org.olat.core.gui.control.Event@d62b3f02</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.group.ui.main.BusinessGroupDeleteDialogBoxController</controllername>
      		<controllername>org.olat.group.ui.main.BusinessGroupListController</controllername>
      		<controllername>org.olat.group.ui.main.OverviewBusinessGroupListController</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:756)
         at org.olat.group.manager.BusinessGroupServiceImpl.deleteBusinessGroup(BusinessGroupServiceImpl.java:785)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.doDelete(AbstractBusinessGroupListController.java:1111)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.event(AbstractBusinessGroupListController.java:426)
         at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:246)
         at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
         at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:243)
         at org.olat.core.gui.control.DefaultController.fireEvent(DefaultController.java:190)
         at org.olat.group.ui.main.BusinessGroupDeleteDialogBoxController.formOK(BusinessGroupDeleteDialogBoxController.java:97)
         at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:380)
         at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:202)
      >>> stack of 2.cause::javax.persistence.RollbackException: Error while committing the transaction
      -> at org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:75)
         at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:71)
         at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:713)
         at org.olat.group.manager.BusinessGroupServiceImpl.deleteBusinessGroup(BusinessGroupServiceImpl.java:785)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.doDelete(AbstractBusinessGroupListController.java:1111)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.event(AbstractBusinessGroupListController.java:426)
         at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:246)
         at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
         at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:243)
         at org.olat.core.gui.control.DefaultController.fireEvent(DefaultController.java:190)
         at org.olat.group.ui.main.BusinessGroupDeleteDialogBoxController.formOK(BusinessGroupDeleteDialogBoxController.java:97)
      >>> stack of 3.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.convertCommitException(ExceptionConverterImpl.java:56)
         at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:71)
         at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:713)
         at org.olat.group.manager.BusinessGroupServiceImpl.deleteBusinessGroup(BusinessGroupServiceImpl.java:785)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.doDelete(AbstractBusinessGroupListController.java:1111)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.event(AbstractBusinessGroupListController.java:426)
         at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:246)
         at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
         at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:243)
      >>> stack of 4.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:208)
         at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
         at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3315)
         at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3552)
         at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:99)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
      >>> stack of 5.cause::com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`olat`.`o_lecture_block_to_group`, CONSTRAINT `lec_block_to_block_idx` FOREIGN KEY (`fk_group`) REFERENCES `o_bs_group` (`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:935)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
      

        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 - 1 hour, 5 minutes
                1h 5m