How to unlock userLocks in EA repository
Currently we have a big number of userLocks in EA repository, which Im not able to unlock as administrator (with right "Security - Manage Locks"). Users who locked pakcages and elements do not working in company anymore.
Locks are available in t_seclocks and when I go to element and click on "Lock..." than I see "The selected element is user locked by person XY...". When I open GUI "Manage Locks" there are no userLocks available. When I try to use some standardized methods like .ReleaseUserLock() in script, it is not working as well.
I have tried to described problem here, but here I have problem a bit simplified and it is possibility a upload screen as well... ![[Manage Locks]](https://i.sstatic.net/xGXAI.png)
First thing to try is to run a project integrity check.
If that doesn't help you can delete the locks from the database using a script
Repository.Execute "delete from t_seclocks where userID = '<GUID of deleted user>'"
Disclaimer: Repository.Execute is an undocumented and unsupported method. If you screw up your database you are completely on your own. Make sure to make a backup before trying anything.
- SQL, Link to Element Feature
- Moving diagrams between projects in enterprise architect
- How to use expansion regions for loops in an activity diagram?
- How to attach a child diagram stereotype to a custom Stereotype
- Enterprise Architect Shape Script - Connector arrow disappears
- Enterprise Architect: Automatically add dependencies in class diagram
- Traceability Status Chart (requirement coverage) in Enterprise Architect
- Get an escaped multi syntax sql update string
- How to add Enumeration Table under corresponding Attributes in Custom Documents in Sparx Enterprise Architect?
- How do you stop Sparx Enterprise Architect adding relationships to all diagrams?
- Keyboard shortcut to change Z-order in Enterprise Architect
- Error In HTML Export using Enterprise Architect C# api
- Navigate from instance/part/... to its type definition in EA
- How to create arrow symbol inbetween and adjust <<>> in Enterprise Architect from Sparx Systems
- How to add primitive type 'String'?
- Change class element to interface element
- How to properly place Hyperlinks in generated document using a custom script?
- Complex Type Ordering in Enterprise Architect Sparx Systems
- Are indirectly inherited methods supposed to be accessed from a class that does not directly realize the containing interfaces
- How to unlock userLocks in EA repository
- Missing text from <memo> field in table in report
- Is it possible to programatically get the root node of an element?
- Can I use a (business process) lane in a sequence diagram in enterprise architect?
- Class doesn't support Automation: 'CreateObject" when creating a Scripting.Dictionary object
- Not sure if my UML USE-CASE diagram is correct
- Deploy addin via MDG technology
- What are these in the UML Class Diagram?
- Is the UML sequence diagram with two activations instead of one correct?
- Typed connectors in EA
- Where is the Sparx EA CSV Exchange Specification Stored?