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

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。

問題

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)

診断

診断ステップ

  • You are using ORACLE database

原因

Issue is caused by incompatibilities of Oracle database environment.

ソリューション

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

最終更新日 2018 年 11 月 2 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.