Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: mkelman on November 23, 2016, 10:10:16 pm

Title: Unlock a Object when security is not on
Post by: mkelman on November 23, 2016, 10:10:16 pm

Hello All,

I'm currently using EA 12.1 installed on my local machine. Somehow a lock (red !) has appeared on one of the objects (business process) and I can't remove it because security setting is not switched on.

How do I remove it, when I can't switch security on, and I can access the menu to manage the locks?

I feel like I'm in a catch 22 or a deadlock

Title: Re: Unlock a Object when security is not on
Post by: Geert Bellekens on November 23, 2016, 10:38:01 pm

Have you tried running a project integrity check.
Otherwise the easiest would be to turn security on and remove all locks (why can't you turn security on?)

As a last resort you can also remove all users lock by deleting everything from t_seclocks
You can either do that directly in an SQL client, or use a script with the Repository.Execute()

Geert

Title: Re: Unlock a Object when security is not on
Post by: mkelman on November 23, 2016, 11:08:20 pm

Hi Geert,

Thanks for the reply.

I tried the integrity check, all OK apart from a couple of little issues that were unrelated.

I can't turn on the security because I don't know the Authorization Code, I guess I could get it from someone in the company.

Lastly, I'm not much of a programmer, just a user of EA. Do you have a script I would need to run?

Cheers

Title: Re: Unlock a Object when security is not on
Post by: qwerty on November 24, 2016, 12:15:41 am

An admin can do that from the context menu. You should do that rather than fiddling with the tables on SQL level.

q.

Title: Re: Unlock a Object when security is not on
Post by: Geert Bellekens on November 24, 2016, 01:20:51 am

The security key is just a fixed GUID that can be found on the registered section of the website.
So if you have the login/password for the registered section you can get the key.

Geert

Title: Re: Unlock a Object when security is not on
Post by: mkelman on November 24, 2016, 04:40:51 am

Hello Geert,

Thanks for the information. Very helpful. I'm still baffled to how the lock got applied in the first place, I'm sure I was working on that object yesterday, I'm the only one working on the model and I don't have access to lock it. Oh well, maybe my memory is failing.

Still waiting for IT, but at least with your help I can point them in the right direction.

Thanks

Martin

Title: Re: Unlock a Object when security is not on
Post by: Eve on November 24, 2016, 08:45:42 am

It's not just the regular lock (no security involved) that can be removed by any user by selecting lock in the context menu?

Title: Re: Unlock a Object when security is not on
Post by: VKN on November 24, 2016, 09:54:32 am

Select 'Lock Element' context menu option when you right click on that element on a diagram.