topic More Installation problems in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/more-installation-problems/m-p/10224#M3823 <HTML><HEAD></HEAD><BODY><SPAN>I am currently trying to upgrade from 1.2.1 to 1.3.0. I am getting the following errors in my alfresco.log .</SPAN><BR /><BR /><SPAN>10:25:51,099 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_assoc add index FKC6EFFF3274173FF4 (child_node_id), add constraint FKC6EFFF3274173FF4 foreign key (child_node_id) references node (id)</SPAN><BR /><SPAN>10:25:51,103 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Can't create table './alfresco/#sql-ada_2b.frm' (errno: 150)</SPAN><BR /><SPAN>10:25:51,143 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_assoc add index FKC6EFFF328E50E582 (parent_node_id), add constraint FKC6EFFF328E50E582 foreign key (parent_node_id) references node (id)</SPAN><BR /><SPAN>10:25:51,143 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Can't create table './alfresco/#sql-ada_2b.frm' (errno: 150)</SPAN><BR /><SPAN>10:25:51,160 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_aspects add index FK2B91A9DE7F2C8017 (node_id), add constraint FK2B91A9DE7F2C8017 foreign key (node_id) references node (id)</SPAN><BR /><SPAN>10:25:51,160 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Can't create table './alfresco/#sql-ada_2b.frm' (errno: 150)</SPAN><BR /><SPAN>10:25:51,165 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_assoc add index FK5BAEF398B69C43F3 (source_node_id), add constraint FK5BAEF398B69C43F3 foreign key (source_node_id) references node (id)</SPAN><BR /><SPAN>10:25:51,165 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Can't create table './alfresco/#sql-ada_2b.frm' (errno: 150)</SPAN><BR /><SPAN>10:25:51,185 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_assoc add index FK5BAEF398A8FC7769 (target_node_id), add constraint FK5BAEF398A8FC7769 foreign key (target_node_id) references node (id)</SPAN><BR /><SPAN>10:25:51,185 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Can't create table './alfresco/#sql-ada_2b.frm' (errno: 150)</SPAN><BR /><SPAN>10:25:51,193 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_properties add index FKC962BF907F2C8017 (node_id), add constraint FKC962BF907F2C8017 foreign key (node_id) references node (id)</SPAN><BR /><SPAN>10:25:51,193 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Can't create table './alfresco/#sql-ada_2b.frm' (errno: 150)</SPAN><BR /><SPAN>10:25:51,201 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_status add index FK38ECB8CF7F2C8017 (node_id), add constraint FK38ECB8CF7F2C8017 foreign key (node_id) references node (id)</SPAN><BR /><SPAN>10:25:51,202 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Can't create table './alfresco/#sql-ada_2b.frm' (errno: 150)</SPAN><BR /><SPAN>10:25:51,221 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table store add index FK68AF8E122DBA5BA (root_node_id), add constraint FK68AF8E122DBA5BA foreign key (root_node_id) references node (id)</SPAN><BR /><SPAN>10:25:51,221 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Can't create table './alfresco/#sql-ada_2b.frm' (errno: 150)</SPAN><BR /><SPAN>10:25:56,428 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to execute command: imconvert /usr/local/alfresco-1.3.0/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_34823.gif&nbsp; /usr/local/alfresco-1.3.0/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_34824.png</SPAN><BR /><SPAN>10:25:57,650 ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot add or update a child row: a foreign key constraint fails</SPAN><BR /><SPAN>10:25:57,715 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:427)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.onApplicationEvent(ImporterBootstrap.java:654)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:804)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:693)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:450)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:536)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)</SPAN><BR /><SPAN>Caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [org.alfresco.repo.domain.hibernate.NodeImpl]; SQL [insert into node (protocol, identifier, uuid, type_qname, acl_id) values (?, ?, ?, ?, ?)]; Cannot add or update a child row: a foreign key constraint fails; nested exception is java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:370)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:612)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.newNode(HibernateNodeDaoServiceImpl.java:264)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.createStore(HibernateNodeDaoServiceImpl.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy1.createStore(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.createStore(DbNodeServiceImpl.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy2.createStore(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:343)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 32 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1968)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:530)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:615)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 54 more</SPAN><BR /><SPAN>10:25:57,721 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:427)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.onApplicationEvent(ImporterBootstrap.java:654)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:804)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:693)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:450)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:536)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)</SPAN><BR /><SPAN>Caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [org.alfresco.repo.domain.hibernate.NodeImpl]; SQL [insert into node (protocol, identifier, uuid, type_qname, acl_id) values (?, ?, ?, ?, ?)]; Cannot add or update a child row: a foreign key constraint fails; nested exception is java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:370)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:612)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.newNode(HibernateNodeDaoServiceImpl.java:264)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.createStore(HibernateNodeDaoServiceImpl.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy1.createStore(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.createStore(DbNodeServiceImpl.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy2.createStore(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:343)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 32 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1968)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:530)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:615)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 54 more</SPAN><BR /><SPAN>10:25:57,725 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:427)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.onApplicationEvent(ImporterBootstrap.java:654)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:804)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:693)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:450)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:536)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)</SPAN><BR /><SPAN>Caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [org.alfresco.repo.domain.hibernate.NodeImpl]; SQL [insert into node (protocol, identifier, uuid, type_qname, acl_id) values (?, ?, ?, ?, ?)]; Cannot add or update a child row: a foreign key constraint fails; nested exception is java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:370)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:612)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.newNode(HibernateNodeDaoServiceImpl.java:264)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.createStore(HibernateNodeDaoServiceImpl.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy1.createStore(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.createStore(DbNodeServiceImpl.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy2.createStore(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:343)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 32 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1968)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:530)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:615)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 54 more</SPAN><BR /><SPAN>10:25:57,731 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context destroyed event to listener instance of class org.alfresco.web.app.ContextListener</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:427)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.onApplicationEvent(ImporterBootstrap.java:654)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:804)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:693)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:450)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:536)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)</SPAN><BR /><SPAN>Caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [org.alfresco.repo.domain.hibernate.NodeImpl]; SQL [insert into node (protocol, identifier, uuid, type_qname, acl_id) values (?, ?, ?, ?, ?)]; Cannot add or update a child row: a foreign key constraint fails; nested exception is java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:370)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:612)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.newNode(HibernateNodeDaoServiceImpl.java:264)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.createStore(HibernateNodeDaoServiceImpl.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy1.createStore(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.createStore(DbNodeServiceImpl.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy2.createStore(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:343)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 32 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1968)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:530)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:615)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 54 more</SPAN><BR /><BR /><SPAN>I ran the db upgrade script and it seemed to work fine so I am not sure why I am getting these db errors.</SPAN></BODY></HTML> Fri, 21 Jul 2006 14:39:57 GMT trying2alfresco 2006-07-21T14:39:57Z More Installation problems https://connect.hyland.com/t5/alfresco-archive/more-installation-problems/m-p/10224#M3823 I am currently trying to upgrade from 1.2.1 to 1.3.0. I am getting the following errors in my alfresco.log .10:25:51,099 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_assoc add index FKC6EFFF3274173FF4 (child_node_id), add constraint FKC6EFFF3274173FF4 foreign key ( Fri, 21 Jul 2006 14:39:57 GMT https://connect.hyland.com/t5/alfresco-archive/more-installation-problems/m-p/10224#M3823 trying2alfresco 2006-07-21T14:39:57Z Re: More Installation problems https://connect.hyland.com/t5/alfresco-archive/more-installation-problems/m-p/10225#M3824 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>What is the result of </SPAN><STRONG>describe child_assoc</STRONG><SPAN> ?</SPAN><BR /><SPAN>When/where did you get the upgrade script?&nbsp; Was it the latest from HEAD?</SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Wed, 16 Aug 2006 09:26:45 GMT https://connect.hyland.com/t5/alfresco-archive/more-installation-problems/m-p/10225#M3824 derek 2006-08-16T09:26:45Z