java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE

Atlassian JIRA | Kamil Cichy [Atlassian] | 7 months ago
  1. 0

    h2.DB backup When we try to backup FishEye with an Oracle DB, we fail on unsupported {{TIMESTAMP (93)}} type: {noformat}2016-04-08 15:30:33,220 INFO [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - 245 rows written, 41 of 76 tables completed. 2016-04-08 15:30:33,223 INFO [ThreadPool2 ] fisheye HibernateUtil-makeWritable - DB going writable. 2016-04-08 15:30:33,224 WARN [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE 2016-04-08 15:30:33,224 INFO [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - Backup failed 2016-04-08 15:30:33,224 WARN [ThreadPool2 ] fisheye BackupManagerImpl$2-run - 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_60] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_60] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_60] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_60] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_60] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_60] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_60] 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{noformat} h2.DB migration Broken backup means also broken DB migration. When current DB type is Oracle and I try to move to Postgres, the migration fails: {noformat}Started Starting ActiveObjects backup... * Backing up Database Information * Backing up Table Definitions ** Table count: 5 * Backing up Tables ** Backing up 'AO_2913F5_COMMENT_ISSUE' ** Backing up 'AO_38321B_CUSTOM_CONTENT_LINK' ** Backing up 'AO_8219D4_COMMIT_HOOK_CONFIG' ** Backing up 'AO_A0B856_WEB_HOOK_LISTENER_AO' ** Backing up 'AO_B434B9_WEB_HOOK' ActiveObjects backup completed! Dropping existing tables... Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE Database migration failed: java.sql.SQLException: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE Problem running drop script (you may have to manually drop the DB) /Users/kcichy/src/fecru_a/output/dist/sql/POSTGRESQL/schema/drop_95.sql Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem running drop script (you may have to manually drop the DB) /Users/kcichy/src/fecru_a/output/dist/sql/POSTGRESQL/schema/drop_95.sql{noformat} FishEye instance correctly carries on using the old DB.

    Atlassian JIRA | 8 months ago | Kamil Cichy [Atlassian]
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
  2. 0

    h2.DB backup When we try to backup FishEye with an Oracle DB, we fail on unsupported {{TIMESTAMP (93)}} type: {noformat}2016-04-08 15:30:33,220 INFO [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - 245 rows written, 41 of 76 tables completed. 2016-04-08 15:30:33,223 INFO [ThreadPool2 ] fisheye HibernateUtil-makeWritable - DB going writable. 2016-04-08 15:30:33,224 WARN [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE 2016-04-08 15:30:33,224 INFO [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - Backup failed 2016-04-08 15:30:33,224 WARN [ThreadPool2 ] fisheye BackupManagerImpl$2-run - 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_60] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_60] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_60] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_60] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_60] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_60] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_60] 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{noformat} h2.DB migration Broken backup means also broken DB migration. When current DB type is Oracle and I try to move to Postgres, the migration fails: {noformat}Started Starting ActiveObjects backup... * Backing up Database Information * Backing up Table Definitions ** Table count: 5 * Backing up Tables ** Backing up 'AO_2913F5_COMMENT_ISSUE' ** Backing up 'AO_38321B_CUSTOM_CONTENT_LINK' ** Backing up 'AO_8219D4_COMMIT_HOOK_CONFIG' ** Backing up 'AO_A0B856_WEB_HOOK_LISTENER_AO' ** Backing up 'AO_B434B9_WEB_HOOK' ActiveObjects backup completed! Dropping existing tables... Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE Database migration failed: java.sql.SQLException: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE Problem running drop script (you may have to manually drop the DB) /Users/kcichy/src/fecru_a/output/dist/sql/POSTGRESQL/schema/drop_95.sql Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem running drop script (you may have to manually drop the DB) /Users/kcichy/src/fecru_a/output/dist/sql/POSTGRESQL/schema/drop_95.sql{noformat} FishEye instance correctly carries on using the old DB.

    Atlassian JIRA | 7 months ago | Kamil Cichy [Atlassian]
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
  3. 0

    h2.DB backup When we try to backup FishEye with an Oracle DB, we fail on unsupported {{TIMESTAMP (93)}} type: {noformat}2016-04-08 15:30:33,220 INFO [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - 245 rows written, 41 of 76 tables completed. 2016-04-08 15:30:33,223 INFO [ThreadPool2 ] fisheye HibernateUtil-makeWritable - DB going writable. 2016-04-08 15:30:33,224 WARN [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE 2016-04-08 15:30:33,224 INFO [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - Backup failed 2016-04-08 15:30:33,224 WARN [ThreadPool2 ] fisheye BackupManagerImpl$2-run - 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_60] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_60] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_60] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_60] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_60] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_60] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_60] 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{noformat} h2.DB migration Broken backup means also broken DB migration. When current DB type is Oracle and I try to move to Postgres, the migration fails: {noformat}Started Starting ActiveObjects backup... * Backing up Database Information * Backing up Table Definitions ** Table count: 5 * Backing up Tables ** Backing up 'AO_2913F5_COMMENT_ISSUE' ** Backing up 'AO_38321B_CUSTOM_CONTENT_LINK' ** Backing up 'AO_8219D4_COMMIT_HOOK_CONFIG' ** Backing up 'AO_A0B856_WEB_HOOK_LISTENER_AO' ** Backing up 'AO_B434B9_WEB_HOOK' ActiveObjects backup completed! Dropping existing tables... Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE Database migration failed: java.sql.SQLException: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE Problem running drop script (you may have to manually drop the DB) /Users/kcichy/src/fecru_a/output/dist/sql/POSTGRESQL/schema/drop_95.sql Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem running drop script (you may have to manually drop the DB) /Users/kcichy/src/fecru_a/output/dist/sql/POSTGRESQL/schema/drop_95.sql{noformat} FishEye instance correctly carries on using the old DB.

    Atlassian JIRA | 7 months ago | Kamil Cichy [Atlassian]
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    h2.DB backup When we try to backup FishEye with an Oracle DB, we fail on unsupported {{TIMESTAMP (93)}} type: {noformat}2016-04-08 15:30:33,220 INFO [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - 245 rows written, 41 of 76 tables completed. 2016-04-08 15:30:33,223 INFO [ThreadPool2 ] fisheye HibernateUtil-makeWritable - DB going writable. 2016-04-08 15:30:33,224 WARN [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE 2016-04-08 15:30:33,224 INFO [ThreadPool2 ] fisheye MessageLoggingProgressMonitor-update - Backup failed 2016-04-08 15:30:33,224 WARN [ThreadPool2 ] fisheye BackupManagerImpl$2-run - 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_60] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_60] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_60] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_60] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_60] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_60] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_60] 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{noformat} h2.DB migration Broken backup means also broken DB migration. When current DB type is Oracle and I try to move to Postgres, the migration fails: {noformat}Started Starting ActiveObjects backup... * Backing up Database Information * Backing up Table Definitions ** Table count: 5 * Backing up Tables ** Backing up 'AO_2913F5_COMMENT_ISSUE' ** Backing up 'AO_38321B_CUSTOM_CONTENT_LINK' ** Backing up 'AO_8219D4_COMMIT_HOOK_CONFIG' ** Backing up 'AO_A0B856_WEB_HOOK_LISTENER_AO' ** Backing up 'AO_B434B9_WEB_HOOK' ActiveObjects backup completed! Dropping existing tables... Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE Database migration failed: java.sql.SQLException: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE Problem running drop script (you may have to manually drop the DB) /Users/kcichy/src/fecru_a/output/dist/sql/POSTGRESQL/schema/drop_95.sql Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem running drop script (you may have to manually drop the DB) /Users/kcichy/src/fecru_a/output/dist/sql/POSTGRESQL/schema/drop_95.sql{noformat} FishEye instance correctly carries on using the old DB.

    Atlassian JIRA | 8 months ago | Kamil Cichy [Atlassian]
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE
  6. 0

    Running FishEye/Crucible 4.0.3 with Oracle Database will encounter the following error, when trying to perform a backup: {code} 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 {code} Note, scheduled backups would not finish too, admins may not notice.

    Atlassian JIRA | 6 months ago | Rolf Lader
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE

      at com.atlassian.crucible.migration.item.DBExporter.throwCantEncodeJdbcType()
    2. com.atlassian.crucible
      SQLBackup$SaverImpl.backup
      1. com.atlassian.crucible.migration.item.DBExporter.throwCantEncodeJdbcType(DBExporter.java:343)[fisheye.jar:?]
      2. com.atlassian.crucible.migration.item.DBExporter.access$400(DBExporter.java:35)[fisheye.jar:?]
      3. com.atlassian.crucible.migration.item.DBExporter$OracleColumnExporter.export(DBExporter.java:297)[fisheye.jar:?]
      4. com.atlassian.crucible.migration.item.DBExporter.exportRow(DBExporter.java:355)[fisheye.jar:?]
      5. com.atlassian.crucible.migration.item.DBExporter.exportTable(DBExporter.java:164)[fisheye.jar:?]
      6. com.atlassian.crucible.migration.item.DBExporter.exportData(DBExporter.java:103)[fisheye.jar:?]
      7. com.atlassian.crucible.migration.item.SQLBackup$SaverImpl.backup(SQLBackup.java:69)[fisheye.jar:?]
      7 frames