Create database with template UMCU_COHORT_STAGING fails on empty EMX2 instance

[erikzwart]

Have you checked if this issue already exists?

• yes

Molgenis EMX2 version

13.167.1

Description

When I try to create a new database/schema with the template UMCU_COHORT_STAGING on an empty emx2 instance I get the error: ImportProfileTask failed: Transaction failed: cannot ALTER TABLE "Age groups" because it has pending trigger events.

Reproduction steps

1. Go to 'https://emx2.dev.molgenis.org' or preview that might be quicker
2. Make sure the schemas catalogue and CatalogueOntologies are removed
3. Create a new database test with the template UMCU_COHORT_STAGING
4. See error

Expected behaviour

Instead of the error I expect the template to create a catalogue and the CatalogueOntologies schema. And successfully create the new schema with the template UMCU_COHORT_STAGING

System configuration

• Operating system: ubuntu 24.04