Upgrade from 3.4.d to 4.0.a/c/d

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

n002213f

I have a nusty error when i try to upgrade (using the Upgrade steps in http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Ftasks%2Fupgrade-process.html) from alfresco 3.4.d to 4.0.d community.

My Environment is as follows:
Ubuntu 12.04
MySQL 5.5 / 5.1.63 (i have tried both version and setting lower_case_table_names=1 )
Apache Tomcat 6.0.35

I get the error below:

2012-06-30 17:16:21,252  WARN  [alfresco.util.AbstractTriggerBean] [main] Job ehCacheTracerJob is not active/enabled
 2012-06-30 17:16:24,422  INFO  [extensions.webscripts.TemplateProcessorRegistry] [main] Registered template processor Repository Template Processor for extension ftl
 2012-06-30 17:16:24,425  INFO  [extensions.webscripts.ScriptProcessorRegistry] [main] Registered script processor Repository Script Processor for extension js
 2012-06-30 17:16:30,197  INFO  [domain.schema.SchemaBootstrap] [main] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
 2012-06-30 17:16:31,865  INFO  [domain.schema.SchemaBootstrap] [main] Executing database script /opt/software/alfresco/4.0.a/apache-tomcat-6.0.35/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2957393249369399918.sql (Generated).
 2012-06-30 17:16:34,277  ERROR [domain.schema.SchemaBootstrap] [main] Statement execution failed:
   SQL: alter table JBPM_ACTION add index FK_ACTION_REFACT (REFERENCEDACTION_), add constraint FK_ACTION_REFACT foreign key (REFERENCEDACTION_) references JBPM_ACTION (ID_)
   Error: Can't create table 'lrc_dm_34d.#sql-22cf_28' (errno: 121)
   File: /opt/software/alfresco/4.0.a/apache-tomcat-6.0.35/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2957393249369399918.sql
   Line: 29
 2012-06-30 17:16:34,279  ERROR [domain.schema.SchemaBootstrap] [main] Schema auto-update failed
 java.sql.SQLException: Can't create table 'lrc_dm_34d.#sql-22cf_28' (errno: 121)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2562)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2512)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:781)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:624)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Any help or pointers will be greatly appreciated.

EDIT:

if i change the sql to lower case,

alter table jbpm_action add index fk_action_refact (referencedaction_), add constraint fk_action_refact foreign key (referencedaction_) references jbpm_action (id_);‍

i get a different error (ERROR 1061 (42000): Duplicate key name 'fk_action_refact'), and suspect this has to do with the database.

jurica

Did you find solution?

I have same problem and try everything as you and problem is still there.

I will appreciate if you can share solution for this problem.

Thanks and regards,

Jurica