I did a Checkout of some entities and accidently left the Lock Entities checked. Now, I can't checkout those entities because it says they're locked. If I look in my Entities Outline, I have blue checks next to those entities indicating that they have been locked. How do I unlock them?

The regular way to unlock locked entities is to find the original check out and check the stuff back in again. If you happen to notice at the time that you do the check out that you had entities locked, then you just check them straight back in (preferably with the lock flag cleared). It is supposed to stop a team of programmers from stuffing up each others stuff.

But it can be manually fixed sometimes. You might want to make a backup first.

For the right search criteria Oystein retrieved these for me.

and

.

For each thing that is locked there is a corresponding entry in the system table SYSREPOS

eg for program PETUNIA (source code) in the APRICOT application there would be an record with a key like

APRICOT*STDPROC**PETUNIA

Field 22 (SYSREP_CHECKOUT$) of this would be set to 1 if it is locked

You could try a search for

"SYSREPOS" AND "CHECK"

I ended up writing a program to go through the whole sysrepos and clear the flag in field 22. But that in itself may not be enough. At one point I got an error "the entity is checked out by the current user" etc, and the only way I could make my check out check back in was to attach the folder it was in (ATTACH_TABLE) and do a COPY_ROW for all the records in each *_TEMP file into the corresponding * file.

Scott, LMS

View this thread on the forum...