Reserved and Locked Documents

Does anyone have an example or solution for unreserving and unlocking all documents? When copying our instances of production for testing we want to be able to remove the documents and manually. Manually deleting folders works for the most part until we run into locked / reserved documents.

Find more posts tagged with

Comments

Lee_Butler

Message from Lee Butler <lbutler@opentext.com> via eLink

eLink

Hi Eric,

If you have the WebReports module you can create a report thatlists all the locked/reserved items and then use the NODEACTION sub-tag tounlock or unreserved them. In terms of syntax, all you need is[LL_REPTAG=DATAID NODEACTION:UNLOCK /] where the id of the item you want tounlock is in DATAID.

It’s worth noting that the tag can only perform actions accordingto the permissions and privileges of the person running the report.

Thanks,
Lee.

From: eLink Discussion:LAPI Discussion [mailto:lapi@elinkkc.opentext.com]
Sent: Saturday, January 31, 2009 10:15 PM
To: eLink Recipient
Subject: Reserved and Locked Documents

Reserved and Locked Documents

Posted by erichimel (Himel, Eric ) on 2009/01/31 16:09

[To reply to this thread, use your normal E-mail reply function.]
Discussion:	LAPI Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.lapi@elinkkc.opentext.com.

__________ Information from ESET NOD32 Antivirus, version of virus signaturedatabase 3815 (20090131) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 3815 (20090131) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Eric_Himel

Thanks for the quick reply, but we do not have web reports.

Philip Forshaw

Message from Philip Forshaw <philip.forshaw@res-ltd.com> via eLink

eLink

Hi, we did a similar exercise a few weeksback.

Its not ideal but the only way I found tobulk unreserve documents was to locate a manageable number using SQL (we used ‘Reserved>0’),lets say 200, create a collection and note its dataid, then insert entries inthe Collections table for each found document. We then used LL Explorer to unreservea decent number at a time (Explorer complains too easily so I did about 10 at atime). Then finally you can use SQL or the collection features to remove theunreserved entries from the collection. A bit long winded but it worked for us.

NOTE: As this is table manipulation it canbe dangerous, hence I haven’t added the SQL here.

Philip Forshaw

CONFIDENTIALITY NOTICE: This e-mail, including any attachments, contains information that may be confidential, and is protected by copyright. It is directed to the intended recipient(s) only. If you have received this e-mail in error please e-mail the sender by replying to this message, and then delete the e-mail. Unauthorised disclosure, publication, copying or use of this e-mail is prohibited. Any communication of a personal nature in this e-mail is not made by or on behalf of any RES group company. E-mails sent or received may be monitored to ensure compliance with the law, regulation and/or our policies.

Carsten_Kulms

Message from Carsten Kulms via eLinkSince the question was posted in the LAPI discussion: What about implementing a small LAPI client tool which traverses thenode hierarchy and unreserves a node when needed? (LAPI functionsListObjects with corresponding "where" parameter and functionsUnreserveObject resp. UnlockObject)Of course the tool has to run with an account/user with sufficientpermissions.This may not be the fastest way to solve the issue but surely lessdangerous than direct database manipulation. (What, btw, implies some.. er, let's say "difficulties", with CS.)

Philip Forshaw

Message from Philip Forshaw <philip.forshaw@res-ltd.com> via eLink

eLink

Or you could search for all reserveddocuments using a Complex Query of "OTReserved":128 andassuming your index is up to date all reserved document you have permissions tosee will be returned. You can then add them to a Collection and unreserve onmasse with LL Explorer.

We didn’t have an index on thesystem we were working on so could not do this.

Philip Forshaw

Eric_Himel

It probably wasn't the cleanest way of doing this but, I did a lookup against the database for all reserved docs, populated a listbox with the dataid's then iterated through the list unreserving.Imports com.opentext.apiPartial Class Unreserve Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim svr, usr, dft, pw As String svr = ConfigurationManager.AppSettings.Get("host") dft = ConfigurationManager.AppSettings.Get("dft") usr = ConfigurationManager.AppSettings.Get("admusr") pw = ConfigurationManager.AppSettings.Get("admpw") Dim objllvalue As LLValue = New LLValue() objllvalue.setAssoc() Dim session As LLSession = New LLSession(svr, 2099, dft, usr, pw, objllvalue) Dim doc As LAPI_DOCUMENTS = New LAPI_DOCUMENTS(session) Dim l As Integer For i As Integer = 0 To reserveddocsList.Items.Count reserveddocsList.SelectedIndex = i l = reserveddocsList.SelectedValue If (doc.UnreserveObject(0, l) <> 0) Then Label1.Text = "Error encountered, Document still reserved" End If i = i + 1 Next End SubEnd Class