Problem:

Is there a way to reset a user associated with files that have previously been checked-out in the Project Management Utility?  

The customer ran the query to reset the locks (as they had problems checking in and checking out files) which worked fine, i.e., the page is no longer checked out BUT the USER associated with the Checkout is still listed in RED.  Is there a way to reset this?

Resolution:

A database administrator for the underlying database could issue the following query against the ELMasterRepository ODBC DSN using their favorite SQL tool or via http://localhost/stadmin/query.html :

   UPDATE pm_pageinfo

   SET checkedoutto = NULL,

       checkoutlocation = NULL,

       checkoutcomment = NULL,

       checkoutdate = NULL

   WHERE pageno IN

(SELECT pageno

FROM pm_pageinfo, SR_MPAG, SR_APPL

WHERE pm_pageinfo.pagename = SR_MPAG.name AND pm_pageinfo.project = SR_APPL.name AND

SR_MPAG.appid = SR_APPL.appid and SR_MPAG.buttonbar & 2 = 0)

for an SQL Server-based Master repository and

UPDATE pm_pageinfo

SET checkedoutto = NULL,

    checkoutlocation = NULL,

    checkoutcomment = NULL,

    checkoutdate = NULL

WHERE pageno IN

(SELECT pageno

FROM pm_pageinfo, SR_MPAG, SR_APPL

WHERE pm_pageinfo.pagename = SR_MPAG.name AND pm_pageinfo.project = SR_APPL.name AND

SR_MPAG.appid = SR_APPL.appid and BITAND(SR_MPAG.buttonbar, 2) = 0);

for an Oracle-based Master repository.