Kbase P80749: RTB - Object seems to be locked when attempting to open it
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/18/2004 |
|
Status: Unverified
SYMPTOM(s):
Roundtable 9.1D
Created an object (SmartWindow) and saved it into a particular task
Attempting to open the object that was just created by selecting the Roundtable's File => Open menu
A message stating that the object is locked by another user is displayed on the screen
"Roundtable ADELIB" is the title of the displayed message
The object <object-name> is in use by <login-name>
Task has a share-status of "Task"
Roundtable's File => Unlock Object option does not unlock the object for some reason
When starting AppBuilder up from the OS, the object can be opened without any problems by using the AppBuilder's File => Open menu
There is no Roundtable session open other than the current session
CHANGE:
Migrated to Roundtable 9.1D
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
To get around the issue, delete the in-use record with the following code:
FIND rtb.rtb_object
WHERE rtb.rtb_object.wspace-id = "<wspace-id>"
AND rtb.rtb_object.obj-type = "PCODE"
AND rtb.rtb_object.object = "<object-name>" NO-LOCK.
FOR EACH rtb.rtb_in-use
WHERE rtb.rtb_in-use.obj-rowid = STRING(ROWID(rtb.rtb_object)):
DELETE rtb.rtb_in-use.
END.
where <wspace-id> is the Workspace name, and <object-name> is the object name
(e.g., mywindow.w).