cancel
Showing results for 
Search instead for 
Did you mean: 

Schema update failed with 'Table already exists'

nikita
Champ in-the-making
Champ in-the-making
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!
2 REPLIES 2

nikita
Champ in-the-making
Champ in-the-making
Sorry, not 3.2r2 (community), we have 3.2 enterprise

mikeh
Star Contributor
Star Contributor
Please contact support if you're using the Enterprise version.

Thanks,
Mike