After I upgrade to the latest Sparkflows Release, I get the following or similar error : Missing column: application_id in FIREDB.PUBLIC.ANALYSIS_FLOW_EXECUTION. How can I fix this?

Setup & Configuration Upgradation
1

After upgrading the Sparkflows Server, it is important to upgrade the Database Schema.

  • Upgrade it by running create-h2-db.sh or create-mysql-db.sh from the Sparkflows install directory.
  • This would upgrade your DB schema to the latest.

Otherwise you can run into an error like below, when you start the Sparkflows Server:

Error creating bean with name 'entityManagerFactory' defined in class path resource   [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]:
Invocation of init method failed; nested exception is org.hibernate.HibernateException:

Missing column: application_id in FIREDB.PUBLIC.ANALYSIS_FLOW_EXECUTION