trusty service postgres error

[deepakkapoor23]

Describe the bug

Running kogito trusty postgres image v1.43.0 throws this error when an event is received. Event is discarded due to this error.

relation "kogito_data_cache" does not exist

Expected behavior

Event is persisted and sent to explainability service for evaluation.

Actual behavior

Event is discarded and not persisted.

How to Reproduce?

1. Run kafka broker
2. Run explainability service
3. Run trusty docker image: quay.io/kiegroup/kogito-trusty-postgresql:1.43.0
4. Connect to postgres db as admin user and default db
5. Run a kogito runtime app with a sample DMN and events-decisions, tracing-decisions addons
6. Invoke the DMN via swagger-ui by sending a sample request
7. Notice the error in trusty service logs
8. No executions show up in trusty ui because they are not persisted

Output of uname -a or ver

Windows

Output of java -version

11

GraalVM version (if different from Java)

No response

Kogito version or git rev (or at least Quarkus version if you are using Kogito via Quarkus platform BOM)

1.43.0

Build tool (ie. output of mvnw --version or gradlew --version)

maven 3.9..6

Additional information

No response