topic Upgrade from 3.4.d to 4.0.a/c/d in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/upgrade-from-3-4-d-to-4-0-a-c-d/m-p/261511#M214641 <HTML><HEAD></HEAD><BODY><SPAN>I have a nusty error when i try to upgrade (using the Upgrade steps in </SPAN><A href="http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Ftasks%2Fupgrade-process.html" rel="nofollow noopener noreferrer">http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Ftasks%2Fupgrade-process.html</A><SPAN>) from alfresco 3.4.d to 4.0.d community.</SPAN><BR /><BR /><SPAN>My Environment is as follows:</SPAN><BR /><SPAN>Ubuntu 12.04</SPAN><BR /><SPAN>MySQL 5.5 / 5.1.63 (i have tried both version and setting lower_case_table_names=1 )</SPAN><BR /><SPAN>Apache Tomcat 6.0.35</SPAN><BR /><BR /><SPAN>I get the error below:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>2012-06-30 17:16:21,252&nbsp; WARN&nbsp; [alfresco.util.AbstractTriggerBean] [main] Job ehCacheTracerJob is not active/enabled<BR /> 2012-06-30 17:16:24,422&nbsp; INFO&nbsp; [extensions.webscripts.TemplateProcessorRegistry] [main] Registered template processor Repository Template Processor for extension ftl<BR /> 2012-06-30 17:16:24,425&nbsp; INFO&nbsp; [extensions.webscripts.ScriptProcessorRegistry] [main] Registered script processor Repository Script Processor for extension js<BR /> 2012-06-30 17:16:30,197&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [main] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.<BR /> 2012-06-30 17:16:31,865&nbsp; INFO&nbsp; [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).<BR /> 2012-06-30 17:16:34,277&nbsp; ERROR [domain.schema.SchemaBootstrap] [main] Statement execution failed:<BR />&nbsp;&nbsp; SQL: alter table JBPM_ACTION add index FK_ACTION_REFACT (REFERENCEDACTION_), add constraint FK_ACTION_REFACT foreign key (REFERENCEDACTION_) references JBPM_ACTION (ID_)<BR />&nbsp;&nbsp; Error: Can't create table 'lrc_dm_34d.#sql-22cf_28' (errno: 121)<BR />&nbsp;&nbsp; File: /opt/software/alfresco/4.0.a/apache-tomcat-6.0.35/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2957393249369399918.sql<BR />&nbsp;&nbsp; Line: 29<BR /> 2012-06-30 17:16:34,279&nbsp; ERROR [domain.schema.SchemaBootstrap] [main] Schema auto-update failed<BR /> java.sql.SQLException: Can't create table 'lrc_dm_34d.#sql-22cf_28' (errno: 121)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2562)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2512)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:781)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:624)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Any help or pointers will be greatly appreciated.</SPAN><BR /><BR /><SPAN>EDIT:</SPAN><BR /><BR /><SPAN>if i change the sql to lower case, </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>alter table jbpm_action add index fk_action_refact (referencedaction_), add constraint fk_action_refact foreign key (referencedaction_) references jbpm_action (id_);<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>i get a different error (ERROR 1061 (42000): Duplicate key name 'fk_action_refact'), and suspect this has to do with the database.</SPAN></BODY></HTML> Sat, 30 Jun 2012 16:24:27 GMT n002213f 2012-06-30T16:24:27Z Upgrade from 3.4.d to 4.0.a/c/d https://connect.hyland.com/t5/alfresco-archive/upgrade-from-3-4-d-to-4-0-a-c-d/m-p/261511#M214641 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.04MySQL 5.5 / 5.1.63 (i have tried both ver Sat, 30 Jun 2012 16:24:27 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-from-3-4-d-to-4-0-a-c-d/m-p/261511#M214641 n002213f 2012-06-30T16:24:27Z Re: Upgrade from 3.4.d to 4.0.a/c/d https://connect.hyland.com/t5/alfresco-archive/upgrade-from-3-4-d-to-4-0-a-c-d/m-p/261512#M214642 <HTML><HEAD></HEAD><BODY><SPAN>Did you find solution?</SPAN><BR /><BR /><SPAN>I have same problem and try everything as you and problem is still there.</SPAN><BR /><BR /><SPAN>I will appreciate if you can share solution for this problem.</SPAN><BR /><BR /><SPAN>Thanks and regards,</SPAN><BR /><BR /><SPAN>Jurica</SPAN></BODY></HTML> Wed, 11 Sep 2013 11:25:03 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-from-3-4-d-to-4-0-a-c-d/m-p/261512#M214642 jurica 2013-09-11T11:25:03Z