Create database with template DATA_CATALOGUE_RWE_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 DATA_CATALOGUE_RWE_STAGING on an empty emx2 instance I get the error: ImportProfileTask failed: Transaction failed: Create column 'Variable mappings.target' failed: refSchema 'catalogue' cannot be found for column 'Variable mappings.target'. Do you have access permissions? (I am logged in as admin).

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 DATA_CATALOGUE_RWE_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 DATA_CATALOGUE_RWE_STAGING

System configuration

• Operating system: ubuntu 24.04