Hey there, the surrounding environment is: vagrant machine hosting a fresh DB2 scheme with a user which has revoked CREATEIN, ALTERIN, DROPIN capabilities (no DDL like in production). script from flowable.db2.all.create.sql executed from a DBA-capable user. Websphere OpenLiberty running the deplo…

[image] grimpressive: The application fails because the *.all.create.sql inserts values with ACT_GE/ID_PROPERTY for 6.3.1.0 so the DBchecker on SpringBoot fails expecting a 6.4.1.3 one. This could be a bug, the *.all.create.sql should probably insert the last version. [image] grimpressive…

Yep I already took a look into that but it refers to the configuration via flowable.cfg.xml and, instead, I’m using the “other” way providing an application.properties for Springboot… S̶o̶ ̶d̶u̶n̶n̶o̶ ̶w̶h̶a̶t̶’̶s̶ ̶t̶h̶e̶ ̶s̶p̶e̶c̶u̶l̶a̶r̶ ̶p̶a̶r̶a̶m̶ ̶f̶o̶r̶ ̶"̶ ̶d̶a̶t̶a̶b̶a̶s̶e̶S̶c̶h̶e̶m̶a̶U̶p̶d…

Thank you for your feedback Filip, so, is there a “complete” way to find out what scripts will provide me a consistend database structure for a 6.4.1.3 deployment? Because peeking into the docs the upgrade “should” be available in the package too, and it’s not the case… So I’ve to find a reliable a…

[image] grimpressive: I just tried with the param flowable.database-schema-update=false but it did not sorted the desired behaviour, Liquibase still tries to perform table creations… Using the flowable.database-schema-update=false property should work. Can you perhaps show us the logs that yo…

@filiphr @grimpressive Just wondering, wouldn’t the requirement be to support: a fresh install in a new environment (DEV, TEST, PROD) an upgrade to an existing environment A flag to enable/disable schema creation: FLOWABLE_DATABASE_SCHEMA_CREATE (-> dbSchemaCreate()) flowable.database-schema-c…

[image] filiphr: Using the flowable.database-schema-update=false property should work. Can you perhaps show us the logs that you are getting Hi Filip, I already tried it, because I found it to be… uhm… “appropriate” when peeking here: [image] Open Source The Flowable project prov…

[image] grimpressive: install from scratch or upgrades Sound like you have a requirement to support: a fresh install in a new environment (DEV, TEST, PROD) an upgrade to an existing environment Additionally, you would like it if your schema versioning tool (liquibase, flyway) supported SQL…

[image] Robinyo: Sound like you have a requirement to support: a fresh install in a new environment (DEV, TEST, PROD) an upgrade to an existing environment Additionally, you would like it if your schema versioning tool (liquibase, flyway) supported SQL so that database migration could be perf…

[image] grimpressive: Hi Filip, <snip…> I’ll provide a full server log asap… Hi again, https://ufile.io/0d1fr here a tgz (25Kb) having: application.properties server.xml console.log (server.log in OpenLiberty)

[Flowable 6.4.1.3] - DB errors on production environments

Flowable Engine

Robinyo January 25, 2019, 9:41pm 2

See: Disable Auto creation of DB Tables

Topic		Replies	Views
Version mismatch: library version is '6.5.0.6', db version is 6.1.2.0 Flowable Engine	0	1365	July 14, 2020
Flowable upgrade from 6.0.1 - 6.4.1 Flowable Engine	0	401	July 30, 2019
Disable Auto Creation of DB during Flowable engine startup Flowable Engine	3	1138	June 10, 2020
NullPointerException at org.flowable.engine.impl.db.ProcessDbSchemaManager.schemaUpdate Flowable Engine	3	1509	October 20, 2020
Flowable Task down! Flowable Engine	16	3088	September 11, 2020

[Flowable 6.4.1.3] - DB errors on production environments

Related topics