The digiwf-engine crashes on startup if forms (json schema) have too long keys

it-at-m / digiwf-core

central workflow automation and integration platform based on the free process framework Camunda.

MIT License

19 stars 7 forks source link

The digiwf-engine crashes on startup if forms (json schema) have too long keys #1311

Closed lmoesle closed 6 months ago

lmoesle commented 7 months ago

Describe the bug

The digiwf-engine crashes on startup if forms (json schema) have too long keys.

With https://github.com/it-at-m/digiwf-core/blob/dev/digiwf-engine/digiwf-engine-service/src/main/resources/db/migration/oracle/V8__JsonSchema.sql the json schema key has to a maximum of 36 characters.

To Reproduce

Start the engine and use a oracle db

Expected behavior

The behaviour should be the same as in environments with prostgres dbs

lmoesle commented 7 months ago

We disable auto deployment of forms and configs in digiwf-test stage. We should raise the character length in the oracle db migrations accordingly to postgres migrations

simonhir commented 7 months ago

Solution: new migration to change the length for the key for oracle to 255 be equal to PostgreSQL