Upgrade failed with the logs "Cannot encode value for unsupported column type: "DATE" (91) of column ATTACHMENTS.CREATIONDATE"
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
Upgrading to Confluence 5.7.x failed with the following logs appears in the atlassian-confluence.log interfering with the upgrade process:
2015-07-03 08:20:35,605 WARN [localhost-startStop-1] [confluence.upgrade.impl.DefaultUpgradeManager] beforeUpgrade Pre-upgrade recovery file generation failed: Problem with table "ATTACHMENTS": Cannot encode value for unsupported column type: "DATE" (91) of column ATTACHMENTS.CREATIONDATE
com.atlassian.confluence.upgrade.recovery.DbDumpException: Problem with table "ATTACHMENTS": Cannot encode value for unsupported column type: "DATE" (91) of column ATTACHMENTS.CREATIONDATE
at com.atlassian.confluence.upgrade.recovery.RecoveryErrorService.newImportExportException(RecoveryErrorService.java:18)
at com.atlassian.dbexporter.exporter.DataExporter.exportRow(DataExporter.java:191)
at com.atlassian.dbexporter.exporter.DataExporter.exportTable(DataExporter.java:100)
at com.atlassian.dbexporter.exporter.DataExporter.access$200(DataExporter.java:28)
at com.atlassian.dbexporter.exporter.DataExporter$1$1.call(DataExporter.java:55)
at com.atlassian.dbexporter.exporter.DataExporter$1$1.call(DataExporter.java:51)
at com.atlassian.dbexporter.jdbc.JdbcUtils.withNoAutoCommit(JdbcUtils.java:63)
at com.atlassian.dbexporter.exporter.DataExporter$1.call(DataExporter.java:50)
at com.atlassian.dbexporter.exporter.DataExporter$1.call(DataExporter.java:45)
at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:31)
at com.atlassian.dbexporter.exporter.DataExporter.export(DataExporter.java:44)
at com.atlassian.dbexporter.DbExporter.exportData(DbExporter.java:53)
at com.atlassian.confluence.upgrade.recovery.DefaultRecoveryFileGenerator.generate(DefaultRecoveryFileGenerator.java:76)
at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.beforeUpgrade(DefaultUpgradeManager.java:238)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:134)
at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:51)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5528)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Diagnosis
Diagnostic Steps
- You are using ORACLE database
Cause
Issue is caused by incompatibilities of Oracle database environment.
Resolution
- Make sure you are using supported type of Database as per this documentation: (Supported Platforms of Confluence 5.7.x)
Oracle : 11.1, 11.2, 12c
If you are not using a compatible database version, proceed with migrating your database to a compatible version. Please follow this documentation as a guide (Migrating to Another Database)
- Make sure you are using the compatible version of JDBC with your database version, as per this documentation: (Database JDBC Drivers)
- For Oracle 11.1, use the 11.1.0.7.0 driver (ojdbc6.jar).
- For Oracle 11.2, use the 11.2.0.1.0 driver (ojdbc6.jar).
- For Oracle 12c use the 12.1.0.1 driver (oldjbc7.jar)
If you are not using the compatible drivers, proceed with downloading your JDBC drivers here: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html