Uploaded image for project: 'Activiti'
  1. ACT-4055

Activiti 6 Beta 1 Upgrade Script for Oracle invalid identifier

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Lowest
    • Resolution: Fixed
    • Affects versions: None
    • Fix versions: 6.0
    • Components: Engine
    • Labels:
      None
    • Sprint:

      Description

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

      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:

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

      There are no errors:

      corrected_activiti.oracle.upgradestep.59900.to.6000.engine.sql
      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';
      

        Attachments

          Activity

            People

            • Assignee:
              joram.barrez Joram Barrez (Inactive)
              Reporter:
              phm Ph M
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: