topic Foreign Key exception installing 3.4.d on OSX in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/foreign-key-exception-installing-3-4-d-on-osx/m-p/254456#M207586 <HTML><HEAD></HEAD><BODY><SPAN>Hi, I just attempted to install Alfresco Community 3.4.d on 10.6 OSX</SPAN><BR /><BR /><SPAN>I selected using an existing MySQL server and had already created a blank database called 'alfresco' (InnoDB)</SPAN><BR /><BR /><SPAN>Alfresco fails to start and looking in the log I see</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />19:53:05,303 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed<BR />org.alfresco.error.AlfrescoRuntimeException: 03160000 Workflow deployment failed<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer.init(WorkflowDeployer.java:330)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer$1.doWork(WorkflowDeployer.java:437)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:508)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer.onBootstrap(WorkflowDeployer.java:433)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:905)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:740)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:519)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:581)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)<BR />Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [org.jbpm.graph.node.StartState]; SQL [insert into JBPM_NODE (NAME_, DESCRIPTION_, PROCESSDEFINITION_, ISASYNC_, ISASYNCEXCL_, ACTION_, SUPERSTATE_, CLASS_) values (?, ?, ?, ?, ?, ?, ?, 'R')]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [org.jbpm.graph.node.StartState]<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:637)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)<BR />&nbsp;&nbsp;&nbsp;at org.springmodules.workflow.jbpm31.JbpmTemplate.execute(JbpmTemplate.java:80)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.jbpm.JBPMEngine.deployDefinition(JBPMEngine.java:348)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowServiceImpl.deployDefinition(WorkflowServiceImpl.java:170)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.proceedWithAudit(AuditMethodInterceptor.java:217)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.proceed(AuditMethodInterceptor.java:184)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:137)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)<BR />&nbsp;&nbsp;&nbsp;at $Proxy68.deployDefinition(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer.init(WorkflowDeployer.java:300)<BR />&nbsp;&nbsp;&nbsp;… 37 more<BR />Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [org.jbpm.graph.node.StartState]<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:40)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2163)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2643)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:322)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:218)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascade(Cascade.java:130)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1282)<BR />&nbsp;&nbsp;&nbsp;at $Proxy200.save(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:87)<BR />&nbsp;&nbsp;&nbsp;at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.jbpm.JBPMEngine$1.doInJbpm(JBPMEngine.java:356)<BR />&nbsp;&nbsp;&nbsp;at org.springmodules.workflow.jbpm31.JbpmTemplate$1.doInHibernate(JbpmTemplate.java:87)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)<BR />&nbsp;&nbsp;&nbsp;… 61 more<BR />Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`alfresco`.`jbpm_node`, CONSTRAINT `FK_NODE_PROCDEF` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `JBPM_PROCESSDEFINITION` (`ID_`))<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.getInstance(Util.java:384)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)<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:2568)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:33)<BR />&nbsp;&nbsp;&nbsp;… 106 more<BR /><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>‍</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><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>‍</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><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>‍</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><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></BODY></HTML> Sat, 16 Apr 2011 10:02:58 GMT gommo 2011-04-16T10:02:58Z Foreign Key exception installing 3.4.d on OSX https://connect.hyland.com/t5/alfresco-archive/foreign-key-exception-installing-3-4-d-on-osx/m-p/254456#M207586 Hi, I just attempted to install Alfresco Community 3.4.d on 10.6 OSXI selected using an existing MySQL server and had already created a blank database called 'alfresco' (InnoDB)Alfresco fails to start and looking in the log I see19:53:05,303 ERROR [org.springframework.web.context.ContextLoader] Cont Sat, 16 Apr 2011 10:02:58 GMT https://connect.hyland.com/t5/alfresco-archive/foreign-key-exception-installing-3-4-d-on-osx/m-p/254456#M207586 gommo 2011-04-16T10:02:58Z Re: Foreign Key exception installing 3.4.d on OSX https://connect.hyland.com/t5/alfresco-archive/foreign-key-exception-installing-3-4-d-on-osx/m-p/254457#M207587 <HTML><HEAD></HEAD><BODY><SPAN>If anyone runs into this on OSX it turns out it is MySQL 5.5.11. I rolled back to 5.5.8 and it worked fine</SPAN></BODY></HTML> Sat, 16 Apr 2011 14:19:29 GMT https://connect.hyland.com/t5/alfresco-archive/foreign-key-exception-installing-3-4-d-on-osx/m-p/254457#M207587 gommo 2011-04-16T14:19:29Z