Alfresco upgrade from 3.2.0 to 4.2.c

[anndrewtr]

Hi;

Is it possible to upgrade Alfresco community edition from 3.2.0 to 4.2.c. If not anyone help me the intermediate steps need to be followed.

Because during upgrade after Database restoration to 4.2.c while I am starting the Alfresco service I am getting the below exception.

2013-08-22 05:41:13,327  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
2013-08-22 05:41:14,075  ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Unable to validate database schema.
java.lang.RuntimeException: Unable to execute export.

Caused by: java.lang.NullPointerException
   at org.alfresco.util.schemacomp.ExportDb.extractSchema(ExportDb.java:333)
   at org.alfresco.util.schemacomp.ExportDb.execute(ExportDb.java:209)
   at org.alfresco.util.schemacomp.ExportDb.execute(ExportDb.java:174)
   … 32 more

2013-08-22 05:41:51,357  ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alf_prop_class' already exists
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

Attached the full stace exception hereby.

[abarisone]

Hi, here you have the general upgrade process http://wiki.alfresco.com/wiki/General_Upgrade_Process
Pay attention to this http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Fconcepts%2Fupgrade-pat..., especially when they say <blockquote>The following diagram shows the upgrade paths for major versions. However, if a direct upgrade to version 4.0 is not successful, an interim step to version 3.3.5 or 3.4.x may be necessary.</blockquote>
To address your needs I think you should fires of all upgrade to 4.0.d and then upgrade to 4.2.c (or 4.2.e)

Rgeards,
Andrea

[anndrewtr]

Hi Andrea;

Thanks for your reply.

I have upgraded Alfresco in the following sequence 3.2.0 -> 3.2r2 -> 3.4.e -> 4.0.e -> 4.2.c.

On upgrading from, 4.0.e to 4.2.c I got an exception: java.lang.ClassCastException: java.util.ArrayList cannot be cast to org.alfresco.service.cmr.repository.ContentData

For that I had ran the query: update alf_node_properties set list_index = -1 where qname_id = (select id from alf_qname where local_name = 'versionEdition');

Does this update query has any impact on upgraded Alfresco server?