![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Unlocking objects after SA crashes Topic Summary: Unlocking objects after SA crashes Created On: 8-Jun-2006 21:39 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Hi!
I am using an Oracle based encyclopedia. After an SA crash, a number of objects were left marked as in use by myself and I cannot update them anymore. I did not find any obvious way to unlock them with SA, but It looks like I could do this with encyclopedia manager. However, Encyclopedia manager does not allow me to unlock the objects as Encyclopedia Manager believes (incorrectly) that the encyclopedia is used by someone else. Any idea? Thanks, Marcel (new to SA) |
|
![]() |
|
![]() |
|
Highlight the locked objects. Right mouse click select "Access Control" from the pull down select "unlock" (it's usually the default). That should unlock the diagrams.
------------------------- Theodore A. Menard |
|
![]() |
|
![]() |
|
Hi Marcel
this sounds like you are not set up as administrator for your system. To do this you need to rename SABind1.dll to SABind.dll. Be careful to rename your existing SABind.dll to something else so you can rollback to your original state if necessary. This should then allow you to unlock items which have been locked in a crash situation. Ed |
|
![]() |
|
![]() |
|
You don't need to change your SABIND to unlock objects that you have locked yourself - only if you want to unlock others and to freeze/unfreeze
|
|
![]() |
|
![]() |
|
Overnight I run a routine that unlocks all definitions and diagrams within an SA encyclopedia. I use this because there are occasions where users have locked objects within SA and by the time anyone finds out the objects are locked, the user who locked them has moved on. -- Author: Duane Hennessy
-- Author: Duane Hennessy
-- Author: Duane Hennessy CREATE FUNCTION sas_system_architect_active () select @count = count(spid) from sysprocesses procs if @count > 0 RETURN @active Edited: 22-Jun-2006 at 04:33 by Duane Hennessy |
|
![]() |
|
![]() |
|
In a rather Nieve fashion, with the proviso that All the locks were left by the current user and the encyclopaedia is a professional one - this seems to work. I am unclear why the setField does not need a save, if I don't do the SetField the 'stuck' lock does not clear. This VBA macro does not check who has the lock.
Private Sub unlockMyLocks() Dim def As Definition Dim objects As SAObjects Set objects = Application.Encyclopedia.GetFilteredDefinitions("*", DFXOOUSECASE) Call objects.ReadAll For Each def In objects 'Debug.Print def.Locked Debug.Print "audit id", def.GetField(DEFNFLD_SAAUDITID) Debug.Print "locked", def.GetField(DEFNFLD_SALOCK) def.SetField DEFNFLD_SALOCK, "F" 'Debug.Print def.Locked Set def = Nothing Next End Sub |
|
![]() |
|
![]() |
|
Did you ever resolve this?
|
|
![]() |
|
![]() |
|
Michael
Not sure which post / issue you are referring to? Regards Toby |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.