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

Atlassian JIRA | Kamil Cichy [Atlassian] | 1 year ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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 | 1 year 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 | 11 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 | 11 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 | 1 year ago | Kamil Cichy [Atlassian]
    java.io.IOException: Error reading database: Cannot encode value for unsupported column type: "TIMESTAMP" (93) of column .CREATED_DATE

    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