topic Migrating from Windows to Mac OS X in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/migrating-from-windows-to-mac-os-x/m-p/170627#M123903 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm trying to backup an exsiting Alfresco 2.1.1 install on Windows / MySQL / Tomcat to Mac OS X. Followed the instructions from the wiki. Restored the alf_dir and the database. However, when starting up Alfresco on Mac it goes into bootstrap mode and tries to run database script Executing database script /Users/apillai/Documents/Projects/detica/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-60270.sql to create the tables and falls over. </SPAN><BR /><BR /><SPAN>1. I have checked the table names are case sensitve on both Windows and Mac in MySQL. </SPAN><BR /><SPAN>2. The index is set to full rebuild. </SPAN><BR /><BR /><SPAN>The exact error is;</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>17:24:42,269 INFO&nbsp; [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.<BR />17:24:43,418 INFO&nbsp; [domain.schema.SchemaBootstrap] Executing database script /Users/apillai/Documents/Projects/detica/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-60270.sql (Generated).<BR />17:24:43,437 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:<BR />&nbsp;&nbsp; SQL:&nbsp; create table JBPM_ACTION (ID_ bigint not null auto_increment, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EXPRESSION_ text, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) type=InnoDB<BR />&nbsp;&nbsp; Error: Table 'JBPM_ACTION' already exists<BR />&nbsp;&nbsp; File: /Users/apillai/Documents/Projects/detica/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-60270.sql<BR />&nbsp;&nbsp; Line: 1<BR />17:24:43,439 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed<BR />com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'JBPM_ACTION' already exists<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Statement.execute(Statement.java:692)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:700)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:675)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:485)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:767)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)<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:448)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:552)<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:585)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)<BR />17:24:43,442 ERROR [web.context.ContextLoader] Context initialization failed<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></CODE></PRE><BR /><SPAN>Anyone?</SPAN><BR /><BR /><SPAN>Ainga</SPAN></BODY></HTML> Tue, 17 Jun 2008 16:31:34 GMT zaizi 2008-06-17T16:31:34Z Migrating from Windows to Mac OS X https://connect.hyland.com/t5/alfresco-archive/migrating-from-windows-to-mac-os-x/m-p/170627#M123903 Hi,I'm trying to backup an exsiting Alfresco 2.1.1 install on Windows / MySQL / Tomcat to Mac OS X. Followed the instructions from the wiki. Restored the alf_dir and the database. However, when starting up Alfresco on Mac it goes into bootstrap mode and tries to run database script Executing databas Tue, 17 Jun 2008 16:31:34 GMT https://connect.hyland.com/t5/alfresco-archive/migrating-from-windows-to-mac-os-x/m-p/170627#M123903 zaizi 2008-06-17T16:31:34Z Re: Migrating from Windows to Mac OS X https://connect.hyland.com/t5/alfresco-archive/migrating-from-windows-to-mac-os-x/m-p/170628#M123904 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>Did anyone get the solution of above error…..</SPAN><BR /><BR /><SPAN>Regards,</SPAN></BODY></HTML> Tue, 09 Dec 2008 07:28:42 GMT https://connect.hyland.com/t5/alfresco-archive/migrating-from-windows-to-mac-os-x/m-p/170628#M123904 lakshya 2008-12-09T07:28:42Z