IBM CM: Unable to execute a search for checked out documents

[popeye]

Hi,
I have tried several approaches to execute a search for checked out documents. It seems, that it is not possible to build such a search that can be executed as a XPATH query.
Neither "Checked_Out_UserID" nor "Checked_Out_TS" can be used in your search templates, I always get the following exception:

Caused by: com.wewebu.ow.server.ecmimpl.ibmcm.exceptions.OwSearchException: Search error, search query = (/Document[@SEMANTICTYPE=1 and @VERSIONID=latest-version(.) and @Checked_Out_UserID = "ICMADMIN" ])
   at com.wewebu.ow.server.ecmimpl.ibmcm.OwIBMCMNetwork.doNativeSearch(OwIBMCMNetwork.java:3252)
   at com.wewebu.ow.server.ecmimpl.ibmcm.OwIBMCMNetwork.doNativeSearch(OwIBMCMNetwork.java:2886)
   at com.wewebu.ow.server.ecmimpl.ibmcm.OwIBMCMNetwork.doSearch(OwIBMCMNetwork.java:1618)
   … 37 more
Caused by: com.ibm.mm.sdk.common.DKQueryException: DGL7089A: Unbekannter Attributname Checked_Out_UserID.
   at com.ibm.mm.sdk.internal.ql.PQExceptionHelperICM.(PQExceptionHelperICM.java:130)
   at com.ibm.mm.sdk.internal.ql.PQueryEngineICM.getAttrID(PQueryEngineICM.java:1182)
   at com.ibm.mm.sdk.internal.ql.CUP$XqpeParser$actions.CUP$XqpeParser$do_action(XqpeParser.java:1339)
   at com.ibm.mm.sdk.internal.ql.XqpeParser.do_action(XqpeParser.java:686)
   at java_cup.runtime.lr_parser.parse(lr_parser.java:569)
   at com.ibm.mm.sdk.internal.ql.PQueryEngineICM.sqlString(PQueryEngineICM.java:714)
   at com.ibm.mm.sdk.internal.ql.PQueryEngineICM.process(PQueryEngineICM.java:643)
   at com.ibm.mm.sdk.server.DKResultSetCursorICM.processQuery(DKResultSetCursorICM.java:291)
   at com.ibm.mm.sdk.server.DKResultSetCursorICM.Init(DKResultSetCursorICM.java:230)
   at com.ibm.mm.sdk.server.DKResultSetCursorICM.(DKResultSetCursorICM.java:140)
   at com.ibm.mm.sdk.server.DKDatastoreICM.execute(DKDatastoreICM.java:4006)
   at com.ibm.mm.sdk.server.DKDatastoreICM.execute(DKDatastoreICM.java:3876)
   at com.wewebu.ow.server.ecmimpl.ibmcm.OwIBMCMNetwork.doNativeSearch(OwIBMCMNetwork.java:3213)
   … 39 more


Do you have any advice?

Thanks in advance 🙂

[vahe]

Hi,

OWD does not handle correctly the search for the system attributes "Checked_Out_UserID" / "Checked_Out_TS"
see: (/Document[@SEMANTICTYPE=1 and @VERSIONID=latest-version(.) and @Checked_Out_UserID = "ICMADMIN" ]) — DGL7089A: Unbekannter Attributname Checked_Out_UserID.

it should be:
(/Document[@SEMANTICTYPE=1 and @VERSIONID=latest-version(.) and
ICMCHECKEDOUT/@ICMCHKOUTUSER = "ICMADMIN"])

This is not supported by the OWD Version 4.0.0.0. OWD should check the "Checked_Out_UserID" / "Checked_Out_TS" attributes and convert them to an IBM CM query language construct like: ICMCHECKEDOUT/@ICMCHKOUTUSER or ICMCHECKEDOUT/@ICMCHKOUTTS

We will communicate this feature to the Product Management. Maybe it would be available in the next OWD release.

…
from http://publib.boulder.ibm.com/infocenter/cmgmt/
Example 28: checked out items
   This query finds all items of the "Journal" item type that are currently checked out.
    /Journal [ICMCHECKEDOUT]

Example 29: checked out items by person
    This query finds all items checked out by "SMITH":
    /Journal [ICMCHECKEDOUT/@ICMCHKOUTUSER = "SMITH"]

regards