We're updating the issue view to help you get more done. 

Activiti 6 Beta 1 Upgrade Script for Oracle invalid identifier

Description

When executing the Upgrade Script for Activiti 6, i get erros:

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

Fehler beim Start in Zeile : 1 in Befehl -
alter table ACT_RE_PROCDEF add column ENGINE_VERSION_ NVARCHAR2(255)
Fehlerbericht -
SQL-Fehler: ORA-00904: : ungültiger Bezeichner
00904. 00000 -  "%s: invalid identifier"
*Cause:   
*Action:

If the statement ist altered, e.g:

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

There are no errors:

corrected_activiti.oracle.upgradestep.59900.to.6000.engine.sql

1 2 3 4 5 6 7 8 9 10 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';

Status

Assignee

Joram Barrez

Reporter

Ph M

Labels

None

Components

Fix versions

Priority

Lowest