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

RS when a large number is inserted in a numeric survey field

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 14.1.6
    • Component/s: Course, QM
    • Labels:
      None

      Description

      Large number = more than 10 digits.

      Affects only MySQL.

      <dispatchinfo><componentinfo><compname>ffo_main_execute</compname><compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass><extendedinfo>n/a</extendedinfo><event><class&amp;gt;org.olat.core.gui.components.form.flexible.impl.FormEvent</class&amp;gt;<command>done</command><tostring>com:done,org.olat.core.gui.components.form.flexible.impl.FormEvent@2f23a1</tostring></event></componentinfo><controllerinfo><controllername>org.olat.modules.forms.ui.EvaluationFormExecutionController</controllername><controllername>org.olat.course.nodes.survey.SurveyRunController</controllername><controllername>org.olat.course.run.RunMainController</controllername><controllername>org.olat.course.run.CourseRuntimeController</controllername><controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername></controllerinfo></dispatchinfo>Throwable: org.olat.core.logging.DBRuntimeExceptionlogmsg:commit failed, rollback transactionmessage:commit failed, rollback transaction,org.olat.core.logging.DBRuntimeExceptionat org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:573)at org.olat.modules.forms.ui.EvaluationFormExecutionController.doSaveResponses(EvaluationFormExecutionController.java:333)at org.olat.modules.forms.ui.EvaluationFormExecutionController.formInnerEvent(EvaluationFormExecutionController.java:274)at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:430)at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:206)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)at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.fireFormEvent(FormWrapperContainer.java:131)at org.olat.core.gui.components.form.flexible.impl.Form.fireFormEvent(Form.java:717)1. cause:message:Error while committing the transaction,javax.persistence.RollbackExceptionat org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:81)at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:107)at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:530)at org.olat.modules.forms.ui.EvaluationFormExecutionController.doSaveResponses(EvaluationFormExecutionController.java:333)at org.olat.modules.forms.ui.EvaluationFormExecutionController.formInnerEvent(EvaluationFormExecutionController.java:274)at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:430)at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:206)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)2. cause:message:org.hibernate.exception.DataException: could not execute statement,javax.persistence.PersistenceExceptionat org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)at org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:65)at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:107)at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:530)at org.olat.modules.forms.ui.EvaluationFormExecutionController.doSaveResponses(EvaluationFormExecutionController.java:333)at org.olat.modules.forms.ui.EvaluationFormExecutionController.formInnerEvent(EvaluationFormExecutionController.java:274)at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:430)at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:206)at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240)3. cause:message:could not execute statement,org.hibernate.exception.DataExceptionat org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52)at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3398)at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3271)at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3672)at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:149)at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)4. cause:message:Data truncation: Out of range value for column 'e_numericalresponse' at row 1,com.mysql.jdbc.MysqlDataTruncationat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3974)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
      

        Attachments

          Activity

            People

            Assignee:
            uhensler Urs Hensler
            Reporter:
            uhensler Urs Hensler
            Tester:
            Mandy Menzel
            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 - 30 minutes
                30m