<?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 CMIS query is querying Relationship instead of Type - Naming clash for Alfresco Type and Association in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/cmis-query-is-querying-relationship-instead-of-type-naming-clash/m-p/279102#M232232</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Executing this simple query using CMIS Workbench fails:&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;SELECT * FROM tdm:publicManual&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;We get this log output:&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;Mar 26, 2014 5:11:42 PM org.apache.solr.common.SolrException log&lt;BR /&gt;SEVERE: org.apache.chemistry.opencmis.commons.exceptions.CmisInvalidArgumentException: Type is not queryable tdm:publicManual -&amp;gt; R:tdm:publicManual&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.opencmis.search.CMISQueryParser.buildSource(CMISQueryParser.java:1417)&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Using CMIS Workbench, I can see that &amp;lt;em&amp;gt;R:tdm&lt;img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;ublicManual&amp;lt;/em&amp;gt; is a cmis:relationship…not a type as I had expected. I can see &amp;lt;em&amp;gt;D:tdm&lt;img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;ublicManual&amp;lt;/em&amp;gt; exists with a Base Type of cmis:document…this is what I want to query on. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Inspecting the model we have a type and relationship with the same name.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;type name="tdm:publicManual"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;……&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/type&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;aspect name="tdm:staged"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;….&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;associations&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;association name="tdm:publicManual"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;……&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/association&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;……&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/associations&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/aspect&amp;gt;&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;This model has been deployed in production since mid 2013 with no problems. e.g. Lucene queries work fine, model deploys without error, we can create content of type tdm&lt;img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;ublicManual and also associations with the name tdm&lt;img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;ublicManual.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;We are just starting to use the CMIS API for new client apps, and this has raised it's head now.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;ul&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;li&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Does anyone know if there a way to request CMIS to explicitly query against the type and not the relationship? &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;/li&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;li&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Is it a case that our model is inherently flawed, and should be changed, by having a type and relationship with the same name?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;/li&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;/ul&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Patrick&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 27 Mar 2014 09:33:14 GMT</pubDate>
    <dc:creator>patquinn00</dc:creator>
    <dc:date>2014-03-27T09:33:14Z</dc:date>
    <item>
      <title>CMIS query is querying Relationship instead of Type - Naming clash for Alfresco Type and Association</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/cmis-query-is-querying-relationship-instead-of-type-naming-clash/m-p/279102#M232232</link>
      <description>Executing this simple query using CMIS Workbench fails&lt;IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" /&gt;ELECT * FROM tdm&lt;IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;ublicManual‍‍‍We get this log output:Mar 26, 2014 5:11:42 PM org.apache.solr.common.SolrException logSEVERE: org.apache.chemistry.opencmis.commons.exceptions.CmisInvalidArgumentException: Type is not queryable tdm&lt;IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;ublicManual</description>
      <pubDate>Thu, 27 Mar 2014 09:33:14 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/cmis-query-is-querying-relationship-instead-of-type-naming-clash/m-p/279102#M232232</guid>
      <dc:creator>patquinn00</dc:creator>
      <dc:date>2014-03-27T09:33:14Z</dc:date>
    </item>
    <item>
      <title>Re: CMIS query is querying Relationship instead of Type - Naming clash for Alfresco Type and Association</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/cmis-query-is-querying-relationship-instead-of-type-naming-clash/m-p/279103#M232233</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;From debugging through the CMISQueryParser, it looks up the Type Definition using the CMIS Dictionary Service (CMISStrictDictionaryService and CMISAbstractDictionaryService) using &lt;/SPAN&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;findTypeByQueryName(tableName)&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;SPAN&gt;. tableName is "tdm&lt;img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;ublicManual"&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The dictionary service uses a registry which is mapping names to Type definitions…so more than likely, the mapping of tdm&lt;img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;ublicManual to the Type named "tdm&lt;img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;ublicManual" is being overwritten in the Map by the association named "tdm&lt;img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;ublicManual".&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Whether the model is inherently flawed or not, I'm not sure, but certainly the CMIS Query Parser is not compatible with it as it is.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;This is looking like an update to the model and a data fix script.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 27 Mar 2014 10:22:21 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/cmis-query-is-querying-relationship-instead-of-type-naming-clash/m-p/279103#M232233</guid>
      <dc:creator>patquinn00</dc:creator>
      <dc:date>2014-03-27T10:22:21Z</dc:date>
    </item>
    <item>
      <title>Re: CMIS query is querying Relationship instead of Type - Naming clash for Alfresco Type and Association</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/cmis-query-is-querying-relationship-instead-of-type-naming-clash/m-p/279104#M232234</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;In CMIS Specification a relationship object MAY be queryable,but now alfresco does not support queries for relationship type.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;So in my opinion ,you'd better avoid defining an association with same name as a a type.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 27 Mar 2014 14:24:36 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/cmis-query-is-querying-relationship-instead-of-type-naming-clash/m-p/279104#M232234</guid>
      <dc:creator>kaynezhang</dc:creator>
      <dc:date>2014-03-27T14:24:36Z</dc:date>
    </item>
  </channel>
</rss>

