Oracle DB upgrade fails

cancel
Showing results for 
Search instead for 
Did you mean: 
buksvdl
Member II

Oracle DB upgrade fails

alter table ACT_RE_PROCDEF add (ENGINE_VERSION_ NVARCHAR2(255));
update ACT_RE_PROCDEF set ENGINE_VERSION_ = 'activiti-5';

alter table ACT_RE_DEPLOYMENT add (ENGINE_VERSION_ NVARCHAR2(255));
update ACT_RE_DEPLOYMENT set ENGINE_VERSION_ = 'activiti-5';

alter table ACT_RU_EXECUTION add (ROOT_PROC_INST_ID_ NVARCHAR2(64));
create index ACT_IDX_EXEC_ROOT on ACT_RU_EXECUTION(ROOT_PROC_INST_ID_);

update ACT_GE_PROPERTY set VALUE_ = '6.0.0.0' where NAME_ = 'schema.version';

alter table ACT_RE_PROCDEF add (ENGINE_VERSION_ NVARCHAR2(255));

java.sql.SQLException: ORA-01430: column being added already exists in table

1 Reply
cjose
Senior Member II

Re: Oracle DB upgrade fails

It appears that the column name got created in a previous run or something like that. Could you please explain the steps that led to the failure?

Can you try running the scripts manually from Activiti 6 branch (Activiti/modules/activiti-engine/src/main/resources/org/activiti/db/upgrade at activiti-6.0.0 · Acti... )?