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

RS if the name of a group too long

    XMLWordPrintable

    Details

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

      Description

      The validity of group names is only checked in batch mode.

      RedScreen on hfu 10.3.7
      2016-04-05 07:43:08,446 [ajp-nio-8009-exec-6] ERROR DBRuntimeException - OLAT::ERROR ^%^ N1-E1 ^%^ org.olat.core.logging
      
      https://felix.xyz.de/auth/BusinessGroup/2205712384/tooladmin/0/tab/0
      Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_2) AppleWebKit/601.3.9 (KHTML, like Gecko) Version/9.0.2 Safari/601.3.9
      **RedScreen** commit failed, rollback transaction
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_default</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.BusinessGroupFormController</controllername>
      		<controllername>org.olat.group.ui.edit.BusinessGroupEditDetailsController</controllername>
      		<controllername>org.olat.group.ui.edit.BusinessGroupEditController</controllername>
      		<controllername>org.olat.group.ui.run.BusinessGroupMainRunController</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:754)
         at org.olat.group.manager.BusinessGroupServiceImpl.updateBusinessGroup(BusinessGroupServiceImpl.java:274)
         at org.olat.group.ui.edit.BusinessGroupEditDetailsController.updateBusinessGroup(BusinessGroupEditDetailsController.java:106)
         at org.olat.group.ui.edit.BusinessGroupEditDetailsController.event(BusinessGroupEditDetailsController.java:85)
         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.BusinessGroupFormController.formOK(BusinessGroupFormController.java:516)
         at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:367)
         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.jpa.internal.TransactionImpl.commit(TransactionImpl.java:94)
         at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:711)
         at org.olat.group.manager.BusinessGroupServiceImpl.updateBusinessGroup(BusinessGroupServiceImpl.java:274)
         at org.olat.group.ui.edit.BusinessGroupEditDetailsController.updateBusinessGroup(BusinessGroupEditDetailsController.java:106)
         at org.olat.group.ui.edit.BusinessGroupEditDetailsController.event(BusinessGroupEditDetailsController.java:85)
         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.BusinessGroupFormController.formOK(BusinessGroupFormController.java:516)
         at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:367)
      >>> stack of 3.cause::javax.persistence.PersistenceException: org.hibernate.exception.DataException: 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:711)
         at org.olat.group.manager.BusinessGroupServiceImpl.updateBusinessGroup(BusinessGroupServiceImpl.java:274)
         at org.olat.group.ui.edit.BusinessGroupEditDetailsController.updateBusinessGroup(BusinessGroupEditDetailsController.java:106)
         at org.olat.group.ui.edit.BusinessGroupEditDetailsController.event(BusinessGroupEditDetailsController.java:85)
         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)
      >>> stack of 4.cause::org.hibernate.exception.DataException: could not execute statement
      -> at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:69)
         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.update(AbstractEntityPersister.java:3285)
         at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3183)
         at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3525)
         at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:159)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
      >>> stack of 5.cause::com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'groupname' at row 1
      -> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3868)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)
         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2550)
         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
         at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
         at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
         at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
         at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Tester:
            Kirsten Scherer
            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 - 40 minutes
                40m