​
Infrastructure prerequisites

Before setting up the Advancing Controller, ensure the following components are properly set up:

  • FlowX.AI Engine Deployment: The Advancing Controller depends on the FlowX Engine and must be deployed in the same environment. Refer to the FlowX Engine setup guide for more information on setting up the Engine.
  • Database Instance: The Advancing Controller uses a PostgreSQL or OracleDB instance as its database.

​
Dependencies

Ensure the following dependencies are met:

  • Database: Properly configured database instance.
  • Datasource: Configuration details for connecting to the database.
  • FlowX.AI Engine: Must be set up and running. Refer to the FlowX Engine setup guide.

​
Database compatibility

The Advancing Controller supports both PostgreSQL and OracleDB databases. However, the FlowX.AI Engine and the Advancing Controller must be configured to use the same type of database at any given time. The FlowX.AI Engine employs two databases: one shared with the FlowX.AI Admin microservice for process metadata and instances, and the other dedicated to advancement.

Mixing PostgreSQL and OracleDB is not supported; both databases must be of the same type.

​
Database configuration

​
PostgreSQL

A basic PostgreSQL configuration for Advancing:

postgresql:
  enabled: true
  postgresqlUsername: "postgres"
  postgresqlPassword: ""
  postgresqlDatabase: "advancing"
  existingSecret: "postgresql-generic"
  postgresqlMaxConnections: 200
  persistence:
    enabled: true
    storageClass: standard-rwo
    size: 20Gi
  resources:
    limits:
      cpu: 1000m
      memory: 1024Mi
    requests:
      memory: 256Mi
      cpu: 100m
  metrics:
    enabled: true
    serviceMonitor:
      enabled: false
    prometheusRule:
      enabled: false
  primary:
    nodeSelector:
      preemptible: "false"

If the parallel advancing configuration already exists, you must reset the ‘advancing’ database by executing the SQL command DROP DATABASE advancing;. Once the database has been dropped, the Liquibase script will automatically re-enable it.

​
Configuration

The Advancing Controller uses a PostgreSQL or an Oracle database as a dependency.

  • Ensure that the user, password, connection link, and database name are correctly configured. If these details are not configured correctly, errors will occur at startup.
  • The datasource is configured automatically via a Liquibase script inside the engine. All updates will include migration scripts.

​
Configuring datasource

If you need to change the datasource configuration detail, you can use the following environment variables:

VariableDescriptionExample Value
SPRING_DATASOURCE_URLJDBC URL for database connectionjdbc:postgresql://jx-onboardingdb:5432/onboarding
SPRING_DATASOURCE_DRIVERCLASSNAMEJDBC driver class nameorg.postgresql.Driver
SPRING_DATASOURCE_USERNAMEDatabase usernamepostgres
SPRING_DATASOURCE_PASSWORDDatabase password[your-secure-password]
SPRING_JPA_DATABASEDatabase type (accepted values: oracle or postgresql)postgresql
SPRING_JPA_SHOWSQLToggle SQL query loggingfalse
SPRING_JPA_PROPERTIES_HIBERNATE_DEFAULT_SCHEMADefault database schema (❗️only for Oracle DBs)public
SPRING_LIQUIBASE_CHANGELOGPath to Liquibase changelog for database migrationsclasspath:config/liquibase/master.xml

It’s important to keep in mind that the Advancing Controller is tightly integrated with the FlowX.AI Engine. Therefore, it is crucial to ensure that both the Engine and the Advancing Controller are configured correctly and are in sync.

​
Health monitoring

VariableDescriptionExample Value
MANAGEMENT_HEALTH_DB_ENABLEDEnable database health checkstrue