Would anyone be able to provide a walkthrough on troubleshooting Confluence v6.7 restoration?

[Rehnuma Noor]

Hello,

I attempted to upgrade Confluence from 5.4 to 6.0 and then 6.0 to 6.7 but the latter upgrade had failed. Unfortunately, I can't go back to reinstall from the start because SQL server had to be upgraded to comply with the supported platforms for Jira upgrade at the same time.

Below is the error message I receive:

I have tried going through the logs and following troubleshooting guides but it's gotten a bit overwhelming for me as I've been handling both Confluence and Jira. Any workaround or guidance would be appreciated.

Thank you,

Rehnuma

[Rehnuma Noor]

Hello again,

If there is anything I can provide to speed up the resolution of this issue I'd be happy to do that. I'd like to have this resolved as soon as possible because I'll be migrating to production next weekend.

Thank you.

[AnnWorley]

Hi Rehnuma,

I opened a support request for you so we can take a closer look. Please stand by for an email from our portal.

Thanks,

Ann

[Rehnuma Noor]

Thank you, Ann. Appreciate the help.

[AnnWorley]

My recommendation is to restore the database and home directory to the last working version (6.0?) and then follow Upgrading Confluence. Please note from the doc I linked: 

XML backups should not be used to upgrade Confluence.

[Rehnuma Noor]

Hi Ann,

Thanks for you quick feedback.

I tried that method but when I loaded the database with the backup my admin rights were removed. I attempted the same on 6.7 but I get the same results. Any idea how I can get the rights enabled again?

[AnnWorley]

If I understand correctly, it is your Confluence admin permissions and not your database permissions you are asking about. If so, we are in luck. If you completed the upgrade to Confluence 6.7, you may use recovery mode to gain access as described in Restore Passwords To Recover Admin User Rights

If you are on 6.0 you may regain access by running the SQL queries on this page - same title, different content: Restore Passwords To Recover Admin User Rights

Please check your <confluence_home>/logs/atlassian-confluence.log for entries related to whether the upgrade ran into errors. It's a good practice after upgrading.

I look forward to your next update.

[Rehnuma Noor]

I've tried running the steps for the logging in with the recovery admin but for some reason the bat file to start Confluence doesn't work. The prompt window flashes for a second and disappears.

[Vickey Palzor Lepcha]

Rehnuma - have you installed Confluence as a service ? If so, check if the Service is stopping/starting properly.

[Rehnuma Noor]

Hi Vickey,

The application is installed as a service.

I followed the steps to enable the recovery admin login and restarted the service. Upon attempting to login I am bounced back with this error:

"Log In - Confluence

• Sorry, your username and/or password are incorrect. Please try again."

[Vickey Palzor Lepcha]

Are you sure your credentials are fine ? :p 

[Rehnuma Noor]

Absolutely positive. I have admin rights on our current production version of Confluence. So not sure why this would happen. Unless the process is overwriting my credentials in the database.