AnsweredAssumed Answered

Schema update failed with 'Table already exists'

Question asked by nikita on Dec 15, 2009
Latest reply on Dec 15, 2009 by mikeh
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:
   SQL:     create table alf32.JBPM_ACTION (
        ID_ number(19,0) not null,
        class char(1 char) not null,
        NAME_ varchar2(255 char),
        ISPROPAGATIONALLOWED_ number(1,0),
        ACTIONEXPRESSION_ varchar2(255 char),
        ISASYNC_ number(1,0),
        REFERENCEDACTION_ number(19,0),
        ACTIONDELEGATION_ number(19,0),
        EVENT_ number(19,0),
        PROCESSDEFINITION_ number(19,0),
        TIMERNAME_ varchar2(255 char),
        DUEDATE_ varchar2(255 char),
        REPEAT_ varchar2(255 char),
        TRANSITIONNAME_ varchar2(255 char),
        TIMERACTION_ number(19,0),
        EXPRESSION_ clob,
        EVENTINDEX_ number(10,0),
        EXCEPTIONHANDLER_ number(19,0),
        EXCEPTIONHANDLERINDEX_ number(10,0),
        primary key (ID_)
   Error: ORA-00955: name is already used by an existing object

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?

Any help is appreciated!