Hello.
I want to migrate Confluence to Cloud but I get an error during the migration.
I searched the internet, there is one solution but unfortunately it didn't help.
what have i tried?
Reconfigure MySQL (Point 2 of https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html)
Solution from post where was my problem (https://community.atlassian.com/t5/Confluence-questions/Can-t-edit-my-pages-or-edit-any-thing-Emergency-help/qaq-p/1613024) - not working for me
What error am I getting?
Failed to export [cloudId=6fa4179d-06fd-4714-b8e8-a1ae956b51ed,fileId=4208cd96-996f-4984-b635-db0f7109cf92,spaceKey=KOM]. Error: Hibernate operation: could not execute statement; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: PROCEDURE wikidb.content_procedure_for_denormalised_permissions does not exist
Please, can u help me?
I can't create a support request because the license for the server version has expired, so I want to switch to the cloud
Why have you reconfigured the database? If it was working before, there was no need to touch it. Migration to Cloud doesn't need you to mess with the database, it just needs a working Confluence that you can export from, or use the CCMA to read.
OK, only that Confluence works normally and I can't migrate anyway
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So how are you doing the migration?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
System admin -> Migration Tool -> Create new migration
And im choose what i'm want to migrate. Im getting info I can reach user limit but I can run migration.
After 1-2 minutes I'm getting:
Users migration successfull
Spaces: Failed
screenshoot of my errors: https://ibb.co/w4XRCSc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, this is a known bug in Confluence, and it can be fixed by following https://confluence.atlassian.com/confkb/confluence-mysql-database-migration-causes-content_procedure_for_denormalised_permissions-does-not-exist-error-1072474724.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your answer, but even after doing this solution, it still didn't help me.
But it led me to what could be wrong.
When I imported a database dump into a database called 'wikidb', procedures were not imported.
After importing to the newly created database: 'wiki', the procedures were imported and successfully migrated to the cloud
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.