Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-6911

7.5 engine upgrade script fails if identity tables were never created

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Won't Fix
    • Icon: L2 - Critical L2 - Critical
    • None
    • 7.5.0
    • None
    • None

      I created my database with 'oracle_engine_7.3.0.sql' without identity part, so that user and groups can be taken from an existing application instead. This worked fine. Upgrade to 7.4 ('oracle_engine_7.3_to_7.4.sql') also went smoothly. However, upgrade to 7.5 ('oracle_engine_7.4_to_7.5.sql') failed at this statement:

      alter table ACT_ID_TENANT_MEMBER
      add constraint ACT_FK_TENANT_MEMB_USER
      foreign key (USER_ID_)
      references ACT_ID_USER (ID_);

      because table ACT_ID_USER was never created — it is not part of engine SQL script.

      I'd guess that the new tenant table should also be part of identity upgrade, not engine upgrade. However, I have no idea if the library will work without it.

        This is the controller panel for Smart Panels app

              Unassigned Unassigned
              doublep Paul Pogonyshev
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: