Process steps to handle the database-upgrade-error-column-to-be-renamed-is-used-in-a-virtual-column-expression

Depended  on this article:

https://confluence.atlassian.com/bitbucketserverkb/database-upgrade-error-column-to-be-renamed-is-used-in-a-virtual-column-expression-827098665.html

As I understand correct, that I must do the following steps:

  1. shut down all Bitbucket DC applications (4.0.4)
  2. Disable the Extended Statistics feature of Oracle 12 DB by my Oracle Admin
  3. Removing columns created by Extended Statistics feature  by my Oracle Admin
  4. Start again my Bitbucket DC applications (4.0.4)
  5. Check that all is working fine
  6. Again shut down all Bitbucket DC applications (4.0.4)
  7. Update to Bitbucket DC applications (4.8.6) (DB will be renamed)
  8. shut down my new Bitbucket DC applications (4.8.6)
  9. Enable the Extended Statistics feature of Oracle 12 DB by my Oracle Admin
  10. Start all new Bitbucket DC applications (4.8.6)
    --Finish--

1 answer

0 vote

H iThomas,

Yes the procedure is correct as you mentioned.

The only thing I would like to add are:

  • Be sure to perform a full backup of your existing instance, including the db before proceeding with the change.
  • Is not mandatory to re-enable the Extended statistics after the upgrade but if you wish to do so please be sure you keep track of this in your internal upgrade procedure so to avoid getting the same issue at your next upgrade.

Aside from that I would suggest you to continue the conversation back in the ticket you have open with us so to receive a better support experience.

 

Please let me know if you have any question.

Best Regards,
Daniele Carcasole

 

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jun 12, 2018 in Bitbucket

Do you use any Atlassian products for your personal projects?

After spinning my wheels trying to get organized enough to write a book for National Novel Writing Month (NaNoWriMo) I took my affinity for Atlassian products from my work life and decided to tr...

30,479 views 26 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you