topic upgrade to 2.1 failed in Alfresco Archive

upgrade to 2.1 failed

aatamer — Thu, 29 Nov 2007 15:04:47 GMT

I am trying to upgrade to 2.1 via a database restore and copying alf_data from a 2.0 version, hoping that the schema upgrade scripts that are part of the upgrade will work. They didn't, so I ran them manually through Query Analyzer.Now this is the error that I getrg.alfresco.error.AlfrescoRuntime

Re: upgrade to 2.1 failed

mikeh — Thu, 29 Nov 2007 18:24:34 GMT

Hi

If there's a bootstrap_lock table, you can drop that and try the start-up again.

Thanks,
Mike

Re: upgrade to 2.1 failed

aatamer — Fri, 30 Nov 2007 19:10:50 GMT

Thanks for the tip. We ended up making the upgrade work by
1. installing a working 2.1 Alfresco
2. capturing the upgrade scripts in the tomcat\temp folder
3. overwriting the blank repository with a snapshot of our production database and the alf_data folder
4. manually running the upgrade scripts using Query Analyzer
5. restarting the server

And presto - we have what we want, our intranet in 2.1 completely intact!
Took a week, but it would've taken much longer if it weren't for all those who came before us and left all the valuable posts in this forum. Thanks.

Warning: Do not use the 2.1 upgrade scripts AS is - they are incomplete. Alfresco does something to them during the upgrade process.