<?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 Schema update failed with 'Table already exists' in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/schema-update-failed-with-table-already-exists/m-p/217646#M170776</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi all!&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I have alfresco 3.1 running on Oracle 10g and trying to update it to 3.2r2.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Schema update always fails with following message:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;15:04:32,373 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:&lt;BR /&gt;&amp;nbsp;&amp;nbsp; SQL:&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; create table alf32.JBPM_ACTION (&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ID_ number(19,0) not null,&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; class char(1 char) not null,&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; NAME_ varchar2(255 char),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ISPROPAGATIONALLOWED_ number(1,0),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ACTIONEXPRESSION_ varchar2(255 char),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ISASYNC_ number(1,0),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; REFERENCEDACTION_ number(19,0),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ACTIONDELEGATION_ number(19,0),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; EVENT_ number(19,0),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; PROCESSDEFINITION_ number(19,0),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; TIMERNAME_ varchar2(255 char),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DUEDATE_ varchar2(255 char),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; REPEAT_ varchar2(255 char),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; TRANSITIONNAME_ varchar2(255 char),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; TIMERACTION_ number(19,0),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; EXPRESSION_ clob,&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; EVENTINDEX_ number(10,0),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; EXCEPTIONHANDLER_ number(19,0),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; EXCEPTIONHANDLERINDEX_ number(10,0),&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; primary key (ID_)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; )&lt;BR /&gt;&amp;nbsp;&amp;nbsp; Error: ORA-00955: name is already used by an existing object&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;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;I look into auto-generated script and see that all tables are present there. But why are they? Why alfresco trying to create already existing tables? How it determines which tables need to be modified/created etc?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Any help is appreciated!&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 15 Dec 2009 14:22:50 GMT</pubDate>
    <dc:creator>nikita</dc:creator>
    <dc:date>2009-12-15T14:22:50Z</dc:date>
    <item>
      <title>Schema update failed with 'Table already exists'</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/schema-update-failed-with-table-already-exists/m-p/217646#M170776</link>
      <description>Hi all!I have alfresco 3.1 running on Oracle 10g and trying to update it to 3.2r2.Schema update always fails with following message:15:04:32,373 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:&amp;nbsp;&amp;nbsp; SQL:&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; create table alf32.JBPM_ACTION (&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ID_ number(19,0) not</description>
      <pubDate>Tue, 15 Dec 2009 14:22:50 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/schema-update-failed-with-table-already-exists/m-p/217646#M170776</guid>
      <dc:creator>nikita</dc:creator>
      <dc:date>2009-12-15T14:22:50Z</dc:date>
    </item>
    <item>
      <title>Re: Schema update failed with 'Table already exists'</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/schema-update-failed-with-table-already-exists/m-p/217647#M170777</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Sorry, not 3.2r2 (community), we have 3.2 enterprise&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 15 Dec 2009 17:10:57 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/schema-update-failed-with-table-already-exists/m-p/217647#M170777</guid>
      <dc:creator>nikita</dc:creator>
      <dc:date>2009-12-15T17:10:57Z</dc:date>
    </item>
    <item>
      <title>Re: Schema update failed with 'Table already exists'</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/schema-update-failed-with-table-already-exists/m-p/217648#M170778</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Please contact support if you're using the Enterprise version.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Mike&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 15 Dec 2009 21:11:55 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/schema-update-failed-with-table-already-exists/m-p/217648#M170778</guid>
      <dc:creator>mikeh</dc:creator>
      <dc:date>2009-12-15T21:11:55Z</dc:date>
    </item>
  </channel>
</rss>

