AnsweredAssumed Answered

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

Question asked by popeye on Sep 21, 2012
Latest reply on Sep 21, 2012 by vahe
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 :-)

Outcomes