Issue

A model edition remains in LOCKED status and cannot be opened or edited.


This typically happens during the creation of a new edition when copying from a previously closed edition to a new open edition.


As a result:

  • The new edition appears in the repository.
  • It remains permanently in LOCKED status.
  • Users cannot continue development.
  • The edition lifecycle is blocked.


Cause

When a new model edition is created, the platform performs a transactional copy of the previous closed edition into the new open edition.


This copy process is atomic and transactional.


However, if the transaction is interrupted (for example due to):

  • Database connection failure.
  • Application server restart.
  • Timeout.
  • Manual interruption.
  • Unexpected system crash.


The copy may not complete successfully.


In such cases:

  • A new edition record is created in the database.
  • The copy is incomplete.
  • The edition remains in LOCKED status.
  • An empty or partially initialized edition entry may exist in the MTA_MODEL_EDITION table.


Solution

To resolve this situation, the incomplete edition must be cleaned up directly in the repository database.


/!\ Important

Perform these actions only after confirming that no model operation is currently running.

Always take a database backup before performing manual updates.


Step 1 - Identify the incomplete edition

Query the MTA_MODEL_EDITION table and identify:

  • The latest edition in LOCKED status.
  • The previous valid edition.


Example:

SELECT UUID, STATUS, CREDATE
FROM MTA_MODEL_EDITION
ORDER BY CREDATE DESC;


Step 2 - Delete the incomplete edition

Delete the last (empty or incomplete) edition entry:

DELETE FROM MTA_MODEL_EDITION
WHERE UUID = '<UUID_of_locked_edition>';

Ensure that you are deleting only the incomplete edition.


Step 3 - Reopen the previous edition

Update the previous edition to restore it to a valid OPEN state:

UPDATE MTA_MODEL_EDITION
SET STATUS = 'OPEN', LOCK_UUID = NULL
WHERE UUID = '<UUID_of_previous_valid_edition>';


This:

  • Removes the lock.
  • Restores the edition to editable state.
  • Allows development to resume.


Validation

After applying the fix:

  • Restart the application (recommended) to force a repository synchronisation.
  • Log back into the platform.
  • Confirm:
    • The previous edition is now OPEN.
    • No edition remains in LOCKED status.
    • Model editing is possible.