topic Re: Migration from 3.2.0 to 4.0.d - hit dead end at DB updates in Alfresco Archive

Migration from 3.2.0 to 4.0.d - hit dead end at DB updates

recurring — Tue, 03 Jul 2012 10:53:42 GMT

Hello helpful Alfresco community 😎 At Medway Council, we've been running the Community edition at version 3.2.0 for quite a while. It needs migrating to the latest version so we can get it on a better platform, configured from day one for a production environment, etc. The current live system is

Re: Migration from 3.2.0 to 4.0.d - hit dead end at DB updates

janv — Thu, 05 Jul 2012 10:13:20 GMT

Thanks for the feedback and detailed report.

Since you are using MySQL and have narrowed down (at least) one of your issues to a specific SQL statement, you could try comparing that specific snippet to the latest HEAD file (in SVN and/or nightly build) to see if it has been fixed and/or changed in a relevant way. Obviously, manually patching is completely unsupported and at your own risk. You will need to manually resolve any conflict … do not take the complete file and/or snippet "as-is" since this could likely introduce other issues.

An alternative option might be to consider Alfresco Enterprise (with dedicated support) to help with this and/or future upgrades.

Regards,
Jan

Re: Migration from 3.2.0 to 4.0.d - hit dead end at DB updates

luca — Mon, 09 Jul 2012 13:30:19 GMT

Hi recurring,
I tried to do the upgrade process and I run into the same error as you.

I also find the correct query from the svn HEAD in patch-common-SqlMap.xml:

        select
            id
        from
            avm_nodes
        where
            id &gt;= #{idOne}
            and id &lt; #{idTwo}
            and class_type = 'plainfile'
            and content_url is not null
            and content_url not like 'id:%' <include refid="alfresco.util.escape"/>
        order by
            id ASC‍‍‍‍‍‍‍‍‍‍‍‍

This file could be found in this path:

[ALFRESCO-WEBAPPS]\WEB-INF\classes\alfresco\ibatis\org.hibernate.dialect.Dialect\patch-common-SqlMap.xml ‍

Or in this path in the source tree:

repository\config\alfresco\ibatis\org.hibernate.dialect.Dialect‍

Is there a way to apply only this patch or should I redo all the upgrade process from the beginning??