<?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 Migratiing from Labs 2.9 to Labs 3.0C - Bug in Schema Update in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/migratiing-from-labs-2-9-to-labs-3-0c-bug-in-schema-update/m-p/187466#M140596</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Good Evening, &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I have a "production" system running under Suse Enterprise Linux with the last Alfresco Labs 2.9 and a "new" system with Alfresco Labs 3.0C installed.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I wanted to migrate the data, categories, rights, users, etc to the new system, so I followed the wiki procedure&lt;/SPAN&gt;&lt;BR /&gt;&lt;UL&gt;&lt;LI&gt;shutdown alfresco&lt;/LI&gt;&lt;BR /&gt;&lt;LI&gt;mysqldump&lt;/LI&gt;&lt;BR /&gt;&lt;LI&gt;erase mysqldb and alf_data on new system after successfull testruns&lt;/LI&gt;&lt;BR /&gt;&lt;LI&gt;copy alf_data&lt;/LI&gt;&lt;BR /&gt;&lt;LI&gt;import dump.sql&lt;/LI&gt;&lt;BR /&gt;&lt;LI&gt;startup alfresco&lt;/LI&gt;&lt;BR /&gt;&lt;LI&gt;watch anxiously&lt;/LI&gt;&lt;/UL&gt;&lt;SPAN&gt;And here it is …&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;16:46:44,007 INFO&amp;nbsp; [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework&lt;BR /&gt;16:47:42,421 INFO&amp;nbsp; [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from c&lt;BR /&gt;lass path resource [alfresco/file-servers.properties]&lt;BR /&gt;16:48:02,657 INFO&amp;nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hib&lt;BR /&gt;ernate.dialect.MySQLInnoDBDialect.&lt;BR /&gt;16:48:02,741 INFO&amp;nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/to&lt;BR /&gt;mcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-20016.sql (Copied from classpa&lt;BR /&gt;th:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-2.2-ACL.sql).&lt;BR /&gt;16:48:03,421 INFO&amp;nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/to&lt;BR /&gt;mcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-20017.sql (Copied from classpa&lt;BR /&gt;th:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-0-create-missing-tables.sql)&lt;BR /&gt;.&lt;BR /&gt;16:48:03,534 INFO&amp;nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/to&lt;BR /&gt;mcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-20018.sql (Copied from classpa&lt;BR /&gt;th:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-from-2.1.sql).&lt;BR /&gt;16:48:13,723 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:&lt;BR /&gt;&amp;nbsp;&amp;nbsp; SQL: INSERT INTO t_alf_usage_delta&lt;BR /&gt;&amp;nbsp;&amp;nbsp; (&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; id, version,&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; node_id,&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; delta_size&lt;BR /&gt;&amp;nbsp;&amp;nbsp; )&lt;BR /&gt;&amp;nbsp;&amp;nbsp; SELECT&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ud.id, 1,&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ud.node_id,&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ud.delta_size&lt;BR /&gt;&amp;nbsp;&amp;nbsp; FROM&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; alf_usage_delta ud&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; Error: Table 'alfresco.alf_usage_delta' doesn't exist&lt;BR /&gt;&amp;nbsp;&amp;nbsp; File: /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-20018&lt;BR /&gt;.sql&lt;BR /&gt;&amp;nbsp;&amp;nbsp; Line: 441&lt;BR /&gt;16:48:13,725 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed&lt;BR /&gt;com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_usage_delta' doesn't exist&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;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;prior to this message, now error message is shown. Is this a bug or did I miss something ? &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN style="color:#FF8000;"&gt;&lt;BR /&gt;Added as bug under &lt;A href="https://issues.alfresco.com/jira/browse/ALFCOM-2512" rel="nofollow noopener noreferrer"&gt;https://issues.alfresco.com/jira/browse/ALFCOM-2512&lt;/A&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Regards, Norgan&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 19 Jan 2009 16:12:53 GMT</pubDate>
    <dc:creator>norgan</dc:creator>
    <dc:date>2009-01-19T16:12:53Z</dc:date>
    <item>
      <title>Migratiing from Labs 2.9 to Labs 3.0C - Bug in Schema Update</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/migratiing-from-labs-2-9-to-labs-3-0c-bug-in-schema-update/m-p/187466#M140596</link>
      <description>Good Evening, I have a "production" system running under Suse Enterprise Linux with the last Alfresco Labs 2.9 and a "new" system with Alfresco Labs 3.0C installed.I wanted to migrate the data, categories, rights, users, etc to the new system, so I followed the wiki procedureshutdown alfrescomysqldu</description>
      <pubDate>Mon, 19 Jan 2009 16:12:53 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/migratiing-from-labs-2-9-to-labs-3-0c-bug-in-schema-update/m-p/187466#M140596</guid>
      <dc:creator>norgan</dc:creator>
      <dc:date>2009-01-19T16:12:53Z</dc:date>
    </item>
    <item>
      <title>Re: Migratiing from Labs 2.9 to Labs 3.0C - Bug in Schema Update</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/migratiing-from-labs-2-9-to-labs-3-0c-bug-in-schema-update/m-p/187467#M140597</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;This is fixed in 3Stable (formerly 3D)&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Here's the original bug I raised&lt;/SPAN&gt;&lt;BR /&gt;&lt;A href="https://issues.alfresco.com/jira/browse/ALFCOM-2268" rel="nofollow noopener noreferrer"&gt;https://issues.alfresco.com/jira/browse/ALFCOM-2268&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;and the post I made with a workaround if you need to stick with 3C&lt;/SPAN&gt;&lt;BR /&gt;&lt;A href="http://forums.alfresco.com/en/viewtopic.php?f=8&amp;amp;t=16047" rel="nofollow noopener noreferrer"&gt;http://forums.alfresco.com/en/viewtopic.php?f=8&amp;amp;t=16047&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;However, I recommend you skip 3C and go to 3Stable.&amp;nbsp; I had other problems with 3C that are now fixed in 3Stable.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Steve&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 21 Jan 2009 16:49:48 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/migratiing-from-labs-2-9-to-labs-3-0c-bug-in-schema-update/m-p/187467#M140597</guid>
      <dc:creator>steve_tekell</dc:creator>
      <dc:date>2009-01-21T16:49:48Z</dc:date>
    </item>
    <item>
      <title>Re: Migratiing from Labs 2.9 to Labs 3.0C - Bug in Schema Update</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/migratiing-from-labs-2-9-to-labs-3-0c-bug-in-schema-update/m-p/187468#M140598</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Just received your update - Thanks a lot !&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 21 Jan 2009 18:07:52 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/migratiing-from-labs-2-9-to-labs-3-0c-bug-in-schema-update/m-p/187468#M140598</guid>
      <dc:creator>norgan</dc:creator>
      <dc:date>2009-01-21T18:07:52Z</dc:date>
    </item>
  </channel>
</rss>

