[Issue] [2.40.4.1] Metadata Sync Failing - RelativePeriods cascade

Support - Assistance technique
3

Hi @Gassim

Greetings of the day!

While analysing I saw these issues occurring with Event Visualisations.

Workaround I Followed while doing the synchronisation is as below:

  1. Identified the event visualisation that were part of the metadata sync
  2. Updated the relativeperiodsid column in eventvisualisation table as NULL.

Post which the issue was resolved.

PS: As mentioned earlier, I have upgraded the instance from 2.37.9.1 to 2.40.4.1, and I noticed a big difference in id columns of all the tables in central vs field server.

Could hibernate have changed the ids of the schema during upgrade? Is the id column mismatch the root cause of the issues here as well as in the issue posted for ExpressionDimensionItems?