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
    • 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)
      

        Figma for Jira By 42nd

          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