Uploaded image for project: 'FishEye'
  1. FishEye
  2. FE-6549

Backup using Oracle Database fails with the message 'Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE'

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Low
    • N/A
    • 4.0.3
    • None
    • None

    Description

      Running FishEye/Crucible 4.0.3 with Oracle Database will encounter the following error, when trying to perform a backup:

      2016-06-01 14:35:08,852 WARN  - Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
      2016-06-01 14:35:08,852 WARN  - Backup failed.
      java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
              at com.atlassian.crucible.migration.item.SQLBackup$SaverImpl.backup(SQLBackup.java:82) [fisheye.jar:?]
              at com.atlassian.crucible.migration.BackupManagerImpl.createBackup(BackupManagerImpl.java:264) [fisheye.jar:?]
              at com.atlassian.crucible.migration.BackupManagerImpl.access$000(BackupManagerImpl.java:55) [fisheye.jar:?]
              at com.atlassian.crucible.migration.BackupManagerImpl$2$1.perform(BackupManagerImpl.java:153) [fisheye.jar:?]
              at com.atlassian.crucible.migration.BackupManagerImpl$2$1.perform(BackupManagerImpl.java:151) [fisheye.jar:?]
              at com.atlassian.crucible.maintenance.MaintenanceManager.doMaintenance(MaintenanceManager.java:111) [fisheye.jar:?]
              at com.atlassian.crucible.migration.BackupManagerImpl$2.run(BackupManagerImpl.java:151) [fisheye.jar:?]
              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_77]
              at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_77]
              at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_77]
              at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_77]
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_77]
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_77]
              at java.lang.Thread.run(Thread.java:745) [?:1.8.0_77]
      Caused by: java.sql.SQLException: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
              at com.atlassian.crucible.migration.item.DBExporter.throwCantEncodeJdbcType(DBExporter.java:343) [fisheye.jar:?]
              at com.atlassian.crucible.migration.item.DBExporter.access$400(DBExporter.java:35) [fisheye.jar:?]
              at com.atlassian.crucible.migration.item.DBExporter$OracleColumnExporter.export(DBExporter.java:297) [fisheye.jar:?]
              at com.atlassian.crucible.migration.item.DBExporter.exportRow(DBExporter.java:355) [fisheye.jar:?]
              at com.atlassian.crucible.migration.item.DBExporter.exportTable(DBExporter.java:164) [fisheye.jar:?]
              at com.atlassian.crucible.migration.item.DBExporter.exportData(DBExporter.java:103) [fisheye.jar:?]
              at com.atlassian.crucible.migration.item.SQLBackup$SaverImpl.backup(SQLBackup.java:69) [fisheye.jar:?]
              ... 13 more
      

      Note, scheduled backups would not finish too, admins may not notice.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              cbdf81bab98b Rolf Lader
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: