Uploaded image for project: 'Content IO'
  1. Content IO
  2. CONTENTIO-284

SQL export does not work on an ODF application

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 3.14.0, 3.13.2
    • 3.12.0
    • None
    • 4.8.0 M2

      After few minutes since starting the export, it fails with the following error:

      com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'DegreeOrder' at row 1
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping#translateException:104
at com.mysql.cj.jdbc.ClientPreparedStatement#executeInternal:953
at com.mysql.cj.jdbc.ClientPreparedStatement#execute:371
at org.apache.commons.dbcp2.DelegatingPreparedStatement#execute:94
at org.apache.commons.dbcp2.DelegatingPreparedStatement#execute:94
at org.ametys.plugins.contentio.export.sql.FillSqlTableComponent#fillTableForContentType:315
at org.ametys.plugins.contentio.export.sql.FillSqlTableComponent#insertValues:232
at org.ametys.plugins.contentio.export.sql.FillSqlTableComponent#fillTable:158
at org.ametys.plugins.contentio.export.sql.ExportManager#export:294
at org.ametys.plugins.contentio.export.sql.ContentExportSchedulable#execute:60
at org.ametys.core.schedule.AmetysJob#execute:151
at org.quartz.core.JobRunShell#run:202
at org.quartz.simpl.SimpleThreadPool$WorkerThread#run:573

          [CONTENTIO-284] SQL export does not work on an ODF application

          Laurence Perier made changes -
          Status Original: Resolved [ 5 ] New: Closed [ 6 ]
          Loïc Bouchet made changes -
          Resolution New: Fixed [ 1 ]
          Status Original: Ready to merge [ 10208 ] New: Resolved [ 5 ]
          Loïc Bouchet made changes -
          Fix Version/s New: 3.13.2 [ 18078 ]
          Cédric Damioli made changes -
          Status Original: Functional review OK [ 10207 ] New: Ready to merge [ 10208 ]
          Cédric Damioli made changes -
          Assignee New: Loïc Bouchet [ lbouchet ]
          Magali Franchet made changes -
          Status Original: Available for review [ 10005 ] New: Functional review OK [ 10207 ]
          Loïc Bouchet made changes -
          Assignee Original: Loïc Bouchet [ lbouchet ]
          Loïc Bouchet made changes -
          Status Original: In Progress [ 3 ] New: Available for review [ 10005 ]
          Bérénice Maurel made changes -
          Sprint New: 4.8.0 M2 [ 87 ]
          Loïc Bouchet made changes -
          Status Original: Open [ 1 ] New: In Progress [ 3 ]

            lbouchet Loïc Bouchet
            lperier Laurence Perier
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: