ORA-00904:"JOURNALENT0_"."TRIEDTIMES" invalid- Fail to upgrade confluence data center 7.3.3 to 8.5.5

giovanna.geraldo
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 29, 2024

Hello, I'm getting error when I try to upgrade confluence data center 7.3.3 to 8.5.5.

 

First, I get error with team calendar plugin:

 

[Catalina-utility-1] ERROR com.atlassian.plugin.parsers.XmlDescriptorParser - There were problems loading the module 'job'. The module and its plugin have been disabled.
12:28:43.879 [Catalina-utility-1] ERROR com.atlassian.plugin.parsers.XmlDescriptorParser - There was a problem loading the descriptor for module 'job' in plugin 'Team Calendars'.
Job/trigger module descriptors are no longer supported. Use JobConfig modules instead. If this is an Atlassian plugin, please update to the latest version. You are currently running version 7.0.16.
com.atlassian.plugin.PluginParseException: Job/trigger module descriptors are no longer supported. Use JobConfig modules instead. If this is an Atlassian plugin, please update to the latest version. You are currently running version 7.0.16.



When I initialize confluence with 
 "8.5.5/bin/start-confluence.sh --disable-all-addons", I get another error:

 

 

12:29:03.840 [Catalina-utility-1] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ORA-00904: "JOURNALENT0_"."TRIEDTIMES": invalid identifier




https://docs.oracle.com/error-help/db/ora-00904/
12:29:03.865 [Catalina-utility-1] ERROR com.atlassian.confluence.plugin.PluginFrameworkContextListener - Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.SplitIndexUpgradeTask@2760d442 failed during the VALIDATION phase due to: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
com.atlassian.confluence.upgrade.UpgradeException: Upgrade task com.atlassian.confluence.upgrade.upgradetask.SplitIndexUpgradeTask@2760d442 failed during the VALIDATION phase due to: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet


Can you help me, please?

1 answer

0 votes
Samuel Gatica _ServiceRocket_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 29, 2024

Hi @giovanna.geraldo 

It appears that there was an issue during the database upgrade process.

Please review the following ticket for more details: https://jira.atlassian.com/browse/CONFSERVER-65134.

There are several workaround options available.

I hope this information is helpful.

 

Best regards

Sam

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events