Upgrade failed with the logs "Cannot encode value for unsupported column type: "DATE" (91) of column ATTACHMENTS.CREATIONDATE"

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

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

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

Last modified on Nov 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.