Inconsistency between Oracle 7.11 create scripts and upgrade scripts

Camunda 7 Topics Discussion & Questions
1

To upgrade Camunda database from 7.8 to 7.11 we use the database scripts in the Camunda Nexus (https://app.camunda.com/nexus/repository/public/org/camunda/bpm/distro/camunda-sql-scripts/7.11.0/camunda-sql-scripts-7.11.0.zip)
We noticed that there are some inconsistencies between the create script and the upgrade script for Oracle.

In oracle_engine_7.9_to_7.10.sql, ROOT_PROC_INST_ID_ is added to several tables with type NVARCHAR2(64).

ALTER TABLE ACT_HI_DEC_IN
  ADD ROOT_PROC_INST_ID_ NVARCHAR2(64);

ALTER TABLE ACT_HI_DEC_OUT
  ADD ROOT_PROC_INST_ID_ NVARCHAR2(64);

While in the create script oracle_engine_7.11.0.sql

create table ACT_HI_DEC_IN (
...
    ROOT_PROC_INST_ID_ varchar(64),
...
);

create table ACT_HI_DEC_OUT (
...
    ROOT_PROC_INST_ID_ varchar(64),
 ...
);

We decided on using NVARCHAR2(64) but can anyone confirm this is the way to go?

2

Hi @Kim,

welcome to the forum, first and foremost! :slight_smile:

Thanks for spotting this!
I actually created a ticket in our Issue Tracker for this.

I would stick to NVARCHAR2(64) as you did. :+1:

Best,
Tobias

3

Hi Tobias,

Thanks for your quick reply! I will update our scripts accordingly.

Regards,
Kim

4