<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic IBM CM: Unable to execute a search for checked out documents in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/ibm-cm-unable-to-execute-a-search-for-checked-out-documents/m-p/263189#M216319</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;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.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Neither "Checked_Out_UserID" nor "Checked_Out_TS" can be used in your search templates, I always get the following exception:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;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" ])&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.wewebu.ow.server.ecmimpl.ibmcm.OwIBMCMNetwork.doNativeSearch(OwIBMCMNetwork.java:3252)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.wewebu.ow.server.ecmimpl.ibmcm.OwIBMCMNetwork.doNativeSearch(OwIBMCMNetwork.java:2886)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.wewebu.ow.server.ecmimpl.ibmcm.OwIBMCMNetwork.doSearch(OwIBMCMNetwork.java:1618)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;… 37 more&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Caused by: com.ibm.mm.sdk.common.DKQueryException: DGL7089A: Unbekannter Attributname Checked_Out_UserID.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.internal.ql.PQExceptionHelperICM.(PQExceptionHelperICM.java:130)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.internal.ql.PQueryEngineICM.getAttrID(PQueryEngineICM.java:1182)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.internal.ql.CUP$XqpeParser$actions.CUP$XqpeParser$do_action(XqpeParser.java:1339)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.internal.ql.XqpeParser.do_action(XqpeParser.java:686)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java_cup.runtime.lr_parser.parse(lr_parser.java:569)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.internal.ql.PQueryEngineICM.sqlString(PQueryEngineICM.java:714)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.internal.ql.PQueryEngineICM.process(PQueryEngineICM.java:643)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.server.DKResultSetCursorICM.processQuery(DKResultSetCursorICM.java:291)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.server.DKResultSetCursorICM.Init(DKResultSetCursorICM.java:230)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.server.DKResultSetCursorICM.(DKResultSetCursorICM.java:140)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.server.DKDatastoreICM.execute(DKDatastoreICM.java:4006)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ibm.mm.sdk.server.DKDatastoreICM.execute(DKDatastoreICM.java:3876)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.wewebu.ow.server.ecmimpl.ibmcm.OwIBMCMNetwork.doNativeSearch(OwIBMCMNetwork.java:3213)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;… 39 more&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Do you have any advice?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks in advance &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 21 Sep 2012 12:15:51 GMT</pubDate>
    <dc:creator>popeye</dc:creator>
    <dc:date>2012-09-21T12:15:51Z</dc:date>
    <item>
      <title>IBM CM: Unable to execute a search for checked out documents</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/ibm-cm-unable-to-execute-a-search-for-checked-out-documents/m-p/263189#M216319</link>
      <description>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 exceptio</description>
      <pubDate>Fri, 21 Sep 2012 12:15:51 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/ibm-cm-unable-to-execute-a-search-for-checked-out-documents/m-p/263189#M216319</guid>
      <dc:creator>popeye</dc:creator>
      <dc:date>2012-09-21T12:15:51Z</dc:date>
    </item>
    <item>
      <title>Re: IBM CM: Unable to execute a search for checked out documents</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/ibm-cm-unable-to-execute-a-search-for-checked-out-documents/m-p/263190#M216320</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;OWD does not handle correctly the search for the system attributes "Checked_Out_UserID" / "Checked_Out_TS"&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;see: (/Document[@SEMANTICTYPE=1 and @VERSIONID=latest-version(.) and @Checked_Out_UserID = "ICMADMIN" ]) — DGL7089A: Unbekannter Attributname Checked_Out_UserID.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;it should be:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;(/Document[@SEMANTICTYPE=1 and @VERSIONID=latest-version(.) and &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;ICMCHECKEDOUT/@ICMCHKOUTUSER = "ICMADMIN"])&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;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&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;We will communicate this feature to the Product Management. Maybe it would be available in the next OWD release.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;…&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;from &lt;/SPAN&gt;&lt;A href="http://publib.boulder.ibm.com/infocenter/cmgmt/" rel="nofollow noopener noreferrer"&gt;http://publib.boulder.ibm.com/infocenter/cmgmt/&lt;/A&gt;&lt;BR /&gt;&lt;SPAN&gt;Example 28: checked out items&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; This query finds all items of the "Journal" item type that are currently checked out.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; /Journal [ICMCHECKEDOUT]&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Example 29: checked out items by person&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; This query finds all items checked out by "SMITH":&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; /Journal [ICMCHECKEDOUT/@ICMCHKOUTUSER = "SMITH"]&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;regards&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 21 Sep 2012 12:30:33 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/ibm-cm-unable-to-execute-a-search-for-checked-out-documents/m-p/263190#M216320</guid>
      <dc:creator>vahe</dc:creator>
      <dc:date>2012-09-21T12:30:33Z</dc:date>
    </item>
  </channel>
</rss>

