Missing DB schema patch to upgrade from v1.0.0-beta-4 to v1.0.0

der · November 7, 2025, 4:41pm

It appears that in v1.0.0-beta-5, an update to the operaton database happened, which was persisted for v1.0.0.

While checking the documentation for the manual update, it seems that the required scripts to perform it are still missing.

The question is, is there a resource available to obtain database patch scripts for upgrading from beta-4 to 1.0.0?

Julian · November 7, 2025, 5:38pm

Hello @der,

unfortunately we shipped beta-4 with an incomplete 7.23.0 schema. Beta-5 is based on the full 7.23.0 schema.

Please review and apply these two alter table statements manually (or if you’re not using postgres, search for your database engine in the the same directory):

github.com/operaton/operaton

engine/src/main/resources/org/operaton/bpm/engine/db/upgrade/postgres_engine_7.22_to_7.23.sql

b356b5ffc


      
          --     https://www.apache.org/licenses/LICENSE-2.0
          --
          -- Unless required by applicable law or agreed to in writing, software
          -- distributed under the License is distributed on an "AS IS" BASIS,
          -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
          -- See the License for the specific language governing permissions and
          -- limitations under the License.
          --
          
          insert into ACT_GE_SCHEMA_LOG
          values ('1200', CURRENT_TIMESTAMP, '7.23.0');
          
          alter table ACT_HI_COMMENT
              add column REV_ integer not null
                  default 1;
          
          alter table ACT_RU_EXECUTION add column PROC_DEF_KEY_ varchar(255);

In the 1.0 release only the database version changed to 7.24.0 with no fields added.

Thanks,

Julian