PostgreSQL error in "process-usertasks-quarkus-with-console" example about incubator-kie-kogito-examples HOT 5 OPEN

@cristianonicolai @wmedvede @ricardozanini looks like an issue with Flyway ?

from incubator-kie-kogito-examples.

cc @nmirasch

from incubator-kie-kogito-examples.

Add
%postgresql.quarkus.flyway.baseline-on-migrate=true
to application.properties and run
mvn clean package quarkus:dev -Pinfinispan

Running the service outside of docker will initialize the migrations for the database, which is what postgresql is missing here: the process_instances table

from incubator-kie-kogito-examples.

Yes, it seems a problem with Flyway. @nmirasch @tiagodolphine @wmedvede can you take a look?

from incubator-kie-kogito-examples.

Please download the DDL scipts file from https://repository.jboss.org/org/kie/kogito/kogito-ddl/1.43.0.Final/ which is mentioned on the documentation page https://docs.jboss.org/kogito/release/latest/html_single/#proc-infinispan-persistence-enabling_kogito-configuring.
In this zip file you will find DDL scripts for postgres in a separate folder named postgresql. Execute the script V1.35.0__create_runtime_PostgreSQL.sql in the same schema/database which is mentioned in the configuration.
This will resolve the error.
It seems that the DDLs in this script are not executed automatically.

Regards.

from incubator-kie-kogito-examples.