topic Re: Still unsuccessful migrating from 3.4.d to 4.0 (now e) in Alfresco Archive

Still unsuccessful migrating from 3.4.d to 4.0 (now e)

zanity84 — Mon, 20 Aug 2012 22:58:47 GMT

Hello all,I had a similar post earlier last week, but now it's more focused on getting Alfresco 4.0.e to properly migrate the data from 3.4.d. I've spent many an hour following migrating guides and have come up short. I wanted to see if we can pinpoint exactly what's going on, so I'll include the a

Re: Still unsuccessful migrating from 3.4.d to 4.0 (now e)

jpotts — Mon, 20 Aug 2012 23:12:04 GMT

Where'd your log go?

Jeff

Re: Still unsuccessful migrating from 3.4.d to 4.0 (now e)

zanity84 — Tue, 21 Aug 2012 15:08:47 GMT

I was trying to find the way to attach files but must be missing something. Below is the log, sorry about that!


16:01:35,027 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
16:01:35,098 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
16:01:43,231 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
16:01:46,760 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
16:01:46,763 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
16:01:53,757 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
16:01:55,439 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8183105340779268156.txt
16:02:02,625 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-6963058047176949773.txt
16:02:09,138 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-1248496286295736715.txt
16:02:17,030 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3524395657223590442.txt
16:02:22,967 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-4248472783159878558.txt
16:02:29,223 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-7841494564058956227.txt
16:02:35,312 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8599276401815501812.txt
16:02:41,751 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3482119987163177049.txt
16:02:47,812 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-7827465021293680450.txt
16:02:53,808 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8850442064257761476.txt
16:02:59,914 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5858014926254049588.txt
16:03:06,007 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-1276078938086265437.txt
16:03:12,051 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-4540091548047593297.txt
16:03:17,933 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5103710684233879594.txt
16:03:23,868 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-592998049768350869.txt
16:03:29,816 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5029107890820814900.txt
16:03:35,770 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8295049224847704624.txt
16:03:41,835 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5908792400006366762.txt
16:03:47,837 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3852371534114144842.txt
16:03:53,795 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-990914112380620938.txt
16:03:59,742 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8340947102449815626.txt
16:04:34,496 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
16:04:34,575 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
16:04:46,741 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
16:04:50,837 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
16:04:50,840 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
16:04:59,616 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
16:05:01,419 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8207704001413618307.txt
16:05:07,851 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5920710617772708284.txt
16:05:14,112 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-7458587896803989667.txt
16:05:20,258 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-4606763847109016185.txt
16:05:26,552 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-6482493078342965277.txt
16:05:32,959 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5648111596420512214.txt
16:05:38,804 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-1652475915441400005.txt
16:05:44,990 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-323307383608195519.txt
16:05:51,036 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-2495221590659597873.txt
16:05:57,299 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-9155672696683852688.txt
16:06:03,360 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-4099633853258127584.txt
16:06:09,308 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8844834145579279736.txt
16:06:15,268 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-255706817923859870.txt
16:06:21,225 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 2 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3030324121654232381.txt
16:06:27,299 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 1 potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-4655622940808645662.txt
16:06:27,940 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-4.0.e/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2472703545782638520.sql (Generated).
16:06:27,961 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] 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 'alfresco.#sql-d1f_22' (errno: 121)
   File: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2472703545782638520.sql
   Line: 1
16:06:27,962 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Can't create table 'alfresco.#sql-d1f_22' (errno: 121)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2663)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:888)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:730)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1319)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1269)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:836)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1479)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
16:06:27,966 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 07200000 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1612)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.sql.SQLException: Can't create table 'alfresco.#sql-d1f_22' (errno: 121)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2663)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:888)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:730)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1319)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1269)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:836)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1479)
   … 34 more
16:06:56,285 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
16:06:56,390 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
16:06:56,391 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
16:06:56,399 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
16:06:58,630 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 314 Web Scripts (+0 failed), 324 URLs
16:06:58,630 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 
16:06:58,630 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 
16:06:59,123 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2707.4324ms)
16:06:59,138 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
16:06:59,142 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
16:09:30,547 INFO  [org.alfresco.web.site.EditionInterceptor] Unable to retrieve License information from Alfresco: 404‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Still unsuccessful migrating from 3.4.d to 4.0 (now e)

loftux — Wed, 22 Aug 2012 05:11:07 GMT

Something is wrong with your database (as if you haven't noticed…).

Things to check
* Do the user you are using have full permissions to the db to do all the changes?
* Check the exact statement being run in file /opt/alfresco-4.0.e/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2472703545782638520.sql (you get the file name from the log). You may have to grab it before you stop tomcat, it resides in temp directory and can get deleted. Is there a statement trying to create something that already exists?
* Grab the Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade* files, what do they tell you?
* If the above doesn't give you any clues, install a clean alfresco db of the current version, and compare the db tables and see if you have any tables, index, foreign keys that do not match up. That is essentially what Schema validation does for you, so you should be able to see it from there.

Re: Still unsuccessful migrating from 3.4.d to 4.0 (now e)

darkmstr — Thu, 23 Aug 2012 15:48:09 GMT

Sorry if it have some mistakes, I'm not a native English speaker but I did what I could.

https://forums.alfresco.com/en/viewtopic.php?f=8&t=45911

I've done this guide with all the steps I've done to upgrade from 3.4.d to 4.0.d, the .e it's the same but with the new ssl certificate for SOLR.

Re: Still unsuccessful migrating from 3.4.d to 4.0 (now e)

zanity84 — Wed, 29 Aug 2012 21:00:11 GMT

I have given all grant permissions to the alfresco user for the mysql database, but I noticed something that may be a concern. I noticed that even a new install of both Alfresco and a blank mysql database won't work. It's looking like it wasn't connecting to the mysql database. From another post, I noticed someone changed the permissions on the mysql connector to 755, which got me thinking: I noticed that the owner of the alfresco folder is root as well as all child folders. Do I need to chown these to someone else, like apache? Thank you for the responses!

Re: Still unsuccessful migrating from 3.4.d to 4.0 (now e)

heiko_robert — Wed, 29 Aug 2012 23:03:10 GMT

Hi zanity84,
your database connection seems to work because the error comes from the database:

Caused by: java.sql.SQLException: Can't create table 'alfresco.#sql-d1f_22' (errno: 121)

I know errno 121 from duplicate foreign key contraints. Have you checked the preupdate files loftux mentioned?
Your imported db dump may have conflicting contraint names or there are tables from previous upgrade attempts?
Regards
Heiko

Re: Still unsuccessful migrating from 3.4.d to 4.0 (now e)

zanity84 — Thu, 30 Aug 2012 16:56:40 GMT

You'll have to forgive me, for I have no idea how to go about checking any of that. Any resources I could consult?

Re: Still unsuccessful migrating from 3.4.d to 4.0 (now e)

heiko_robert — Thu, 30 Aug 2012 20:41:29 GMT

zanity84,

you need SQL/MySQL knowledge to fix that issue. All required hints are written to files mentioned in your log:
There are several entries like

WARN [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found .. potential problems, results written to: /opt/alfresco-4.0.e/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-…

You can also look into the migration script mentioned in the log

/opt/alfresco-4.0.e/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2472703545782638520.sql

and search for the full statement causing the problem

Can't create table 'alfresco.#sql-d1f_22' (errno: 121)

regards
Heiko

Re: Still unsuccessful migrating from 3.4.d to 4.0 (now e)

zanity84 — Fri, 31 Aug 2012 20:14:13 GMT

Thank you for the responses,

So, I was able to install a new copy of 4.0.e with a new blank database, so it seems the connector is working. It populated the database with the necessary tables, so that's good! I didn't see any of the errors that I posted earlier, so I hope I'm on the right track.

I noticed when installing the new instance, I got an error when installing the OpenOffice part. It said another application is using the port (8100). I did a nmap, and sure enough, there's an application running on that port, called xprint-server. I'm doing some research on it now, but if anybody has an idea as to how to change the port on xprint-server for CentOS, I'm all ears! Thanks, and I will get back to this forum once I've made progress.