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

RS: could not upload document

    XMLWordPrintable

    Details

      Description

      For a file, the language metadata field is limited to 16 characters but there is no validation.

      2019-11-29 11:30:53.435 [ajp-nio2-8063-exec-7] ERROR OLATRuntimeException ^%^ I39349-J3754 ^%^ org.olat.core.logging.OLATRuntimeException
      https://oszj.openolat.com/auth/RepositoryEntry/60948487/CourseNode/95578893647523
      Mozilla/5.0 (Windows NT 6.1; rv:56.0) Gecko/20100101 Firefox/56.0
      
      **RedScreen** org.hibernate.exception.DataException: could not execute statement
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_file_upload</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.core.commons.modules.bc.FileUploadController</controllername>
      	<controllername>org.olat.core.commons.modules.bc.commands.CmdUpload</controllername>
      	<controllername>org.olat.core.commons.modules.bc.FolderRunController</controllername>
      	<controllername>org.olat.course.nodes.bc.BCCourseNodeRunController</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>
      
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not execute statement
       at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
       at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1534)
       at org.hibernate.query.Query.getResultList(Query.java:165)
       at org.olat.core.commons.services.vfs.manager.VFSThumbnailDAO.findThumbnails(VFSThumbnailDAO.java:110)
       at org.olat.core.commons.services.vfs.manager.VFSRepositoryServiceImpl.resetThumbnails(VFSRepositoryServiceImpl.java:646)
       at org.olat.core.commons.modules.bc.FileUploadController.finishSuccessfullUpload(FileUploadController.java:745)
       at org.olat.core.commons.modules.bc.FileUploadController.uploadNewFile(FileUploadController.java:711)
       at org.olat.core.commons.modules.bc.FileUploadController.doUpload(FileUploadController.java:602)
       at org.olat.core.commons.modules.bc.FileUploadController.formOK(FileUploadController.java:355)
       at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:389)
       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.fireValidation(FormWrapperContainer.java:119)
       at org.olat.core.gui.components.form.flexible.impl.Form.submit(Form.java:441)
       at org.olat.core.gui.components.form.flexible.impl.Form.submit(Form.java:428)
       at org.olat.core.gui.components.form.flexible.impl.elements.FormSubmit.dispatchFormRequest(FormSubmit.java:72)
       at org.olat.core.gui.components.form.flexible.impl.FormItemImpl.doDispatchFormRequest(FormItemImpl.java:561)
       at org.olat.core.gui.components.form.flexible.impl.Form.evalFormRequest(Form.java:296)
       at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.doDispatchRequest(FormWrapperContainer.java:100)
       at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
       at org.olat.core.gui.components.Window.doDispatchToComponent(Window.java:1201)
       at org.olat.core.gui.components.Window.dispatchRequest(Window.java:398) ... 39 more
      Caused by: org.hibernate.exception.DataException: could not execute statement
       at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)
       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)
       at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478)
       at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:361)
       at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:56)
       at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1454)
       at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1540)
       at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1557)
       at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1525) ... 61 more
      Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(16)
       at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
       at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
       at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
       at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
       at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
       at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:150)
       at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:127)
       at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:87)
       at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:87)
       at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175) ... 73 more
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Tester:
            Mandy Menzel
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: