<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Problems with upgrading from 2.1 to 3.0 stable in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/problems-with-upgrading-from-2-1-to-3-0-stable/m-p/184588#M137718</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello all…&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;We are running Alfresco 2.1 Community release and today we tried to upgrade to Alfresco 3.0 labs. Our system runs on Windows 2003 server and the database that Alfresco uses is MS SQL Server 2000.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;We did make a cold backup of both the db and the repository and made a clean install as referred from &lt;/SPAN&gt;&lt;A href="http://wiki.alfresco.com/wiki/General_Upgrade_Process#The_Upgrade_Process" rel="nofollow noopener noreferrer"&gt;http://wiki.alfresco.com/wiki/General_Upgrade_Process#The_Upgrade_Process&lt;/A&gt;&lt;SPAN&gt; . Steps 1 to 5 completed without any errors but when we tried to restore the old repository (alf_data) and database the system produced several errors.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I am copying the error log from alfresco.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;15:48:16,027 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table alf_version_count add store_id numeric(19,0) unique&lt;BR /&gt;15:48:16,043 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 4. Most significant primary key is '&amp;lt;NULL&amp;gt;'.&lt;BR /&gt;15:48:16,043 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table alf_authority_alias add constraint fk_alf_autha_ali foreign key (alias_id) references alf_authority&lt;BR /&gt;15:48:16,043 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Column 'alf_authority.recipient' is not the same data type as referencing column 'alf_authority_alias.alias_id' in foreign key 'fk_alf_autha_ali'.&lt;BR /&gt;15:48:16,043 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table alf_authority_alias add constraint fk_alf_autha_aut foreign key (auth_id) references alf_authority&lt;BR /&gt;15:48:16,043 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Column 'alf_authority.recipient' is not the same data type as referencing column 'alf_authority_alias.auth_id' in foreign key 'fk_alf_autha_aut'.&lt;BR /&gt;15:48:16,043 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table alf_node add constraint fk_alf_node_store foreign key (store_id) references alf_store&lt;BR /&gt;15:48:16,043 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] The number of columns in the referencing column list for foreign key 'fk_alf_node_store' does not match those of the primary key in the referenced table 'alf_store'.&lt;BR /&gt;15:48:16,043 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table alf_version_count add constraint fk_alf_vc_store foreign key (store_id) references alf_store&lt;BR /&gt;15:48:16,043 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Foreign key 'fk_alf_vc_store' references invalid column 'store_id' in referencing table 'alf_version_count'.&lt;BR /&gt;15:48:29,902 INFO&amp;nbsp; [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]&lt;BR /&gt;15:48:36,559 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed&lt;BR /&gt;org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activityService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'postDaoService' while setting bean property 'postDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [C:\Alfresco\tomcat\shared\classes\alfresco\extension\custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.&amp;nbsp; Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.&amp;nbsp; Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.&amp;nbsp; Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.SQLServerDialect/ActivityPost.xml&lt;BR /&gt;Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [C:\Alfresco\tomcat\shared\classes\alfresco\extension\custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.&amp;nbsp; Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.&amp;nbsp; Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.&amp;nbsp; Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.SQLServerDialect/ActivityPost.xml&lt;BR /&gt;Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [C:\Alfresco\tomcat\shared\classes\alfresco\extension\custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.&amp;nbsp; Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.&amp;nbsp; Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.&amp;nbsp; Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.SQLServerDialect/ActivityPost.xml&lt;BR /&gt;Caused by: java.lang.RuntimeException: Error occurred.&amp;nbsp; Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.&amp;nbsp; Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.&amp;nbsp; Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.SQLServerDialect/ActivityPost.xml&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:109)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:90)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapClient(SqlMapClientFactoryBean.java:326)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:280)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:516)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:578)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.lang.reflect.Method.invoke(Method.java:597)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)&lt;BR /&gt;Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.&amp;nbsp; Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.&amp;nbsp; Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.SQLServerDialect/ActivityPost.xml&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:106)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;… 57 more&lt;BR /&gt;Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.&amp;nbsp; Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.SQLServerDialect/ActivityPost.xml&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;… 58 more&lt;BR /&gt;Caused by: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.SQLServerDialect/ActivityPost.xml&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:108)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:93)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:383)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;… 62 more&lt;BR /&gt;15:48:51,762 INFO&amp;nbsp; [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework&lt;BR /&gt;15:49:02,465 INFO&amp;nbsp; [org.alfresco.web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs&lt;BR /&gt;15:49:02,465 INFO&amp;nbsp; [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 1132.9504ms)&lt;BR /&gt;15:50:05,685 INFO&amp;nbsp; [org.alfresco.web.scripts.DeclarativeRegistry] Registered 101 Web Scripts (+0 failed), 105 URLs&lt;BR /&gt;15:50:05,685 INFO&amp;nbsp; [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 63178.2ms)&lt;BR /&gt;15:50:06,201 INFO&amp;nbsp; [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;From the first error messages it seems that the db schema changed for 3.0 and it cannot update the 2.1 schema cause it produces relationship errors.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;If anyone could help here it would be very very appreciated.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Paris Kapsouros&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 26 Feb 2009 15:35:33 GMT</pubDate>
    <dc:creator>savah</dc:creator>
    <dc:date>2009-02-26T15:35:33Z</dc:date>
    <item>
      <title>Problems with upgrading from 2.1 to 3.0 stable</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/problems-with-upgrading-from-2-1-to-3-0-stable/m-p/184588#M137718</link>
      <description>Hello all…We are running Alfresco 2.1 Community release and today we tried to upgrade to Alfresco 3.0 labs. Our system runs on Windows 2003 server and the database that Alfresco uses is MS SQL Server 2000.We did make a cold backup of both the db and the repository and made a clean install as referre</description>
      <pubDate>Thu, 26 Feb 2009 15:35:33 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/problems-with-upgrading-from-2-1-to-3-0-stable/m-p/184588#M137718</guid>
      <dc:creator>savah</dc:creator>
      <dc:date>2009-02-26T15:35:33Z</dc:date>
    </item>
    <item>
      <title>Re: Problems with upgrading from 2.1 to 3.0 stable</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/problems-with-upgrading-from-2-1-to-3-0-stable/m-p/184589#M137719</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The Labs versions of Alfresco only support MySQL; it's Open Source and MS SQLServer is not.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;All other databases are supported and tested for Enterprise versions.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;In this case, Hibernate has had a go at doing the upgrade, but there's not chance!&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Regards&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 26 Feb 2009 16:57:29 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/problems-with-upgrading-from-2-1-to-3-0-stable/m-p/184589#M137719</guid>
      <dc:creator>derek</dc:creator>
      <dc:date>2009-02-26T16:57:29Z</dc:date>
    </item>
  </channel>
</rss>

