When attempting to open two separate models I receive the following error: "Cannot change the cat (4288856)

When attempting to open two separate models I receive the following error: "Cannot change the cat

When attempting to open two separate models I receive the following error: "Cannot change the catalog entry; the catalog entry, its parent, or a child entry is locked. Contact your Mart Administrator for more information."

Description:

When two users attempt to open two separate Mart models with no locks, both users receive the following error: "Cannot change the catalog entry; the catalog entry, its parent, or a child entry is locked. Contact your Mart Administrator for more information."

The issue occurs only when two specific users try to open two specific model; even though both users close erwin Data Modeler/Mart Server completely and then reopen the Client and Mart sessions, each attempt made to open the models will prompt the same lock related error message.

Cause:

This is due to a hanging Inactive session and/or Lock between both users.

Resolution:

WARNING:  Please make sure you have a backup of your Database Management System before you attempt to make any changes to it.  Also, make sure that ALL users are logged out from Mart BEFORE running these queries in the database.

Run the following delete queries to clear out all Inactive Sessions and Locks:

Delete all Inactive Sessions:  Run the following query in the database where Mart resides:

Delete from m9session where S_Status = 'I' ;

Delete all Locks: Run the following query in the database where Mart resides:

Delete m9lock;