<?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 Afresco 201901 GA (6.1.2) search not worked in Alfresco Forum</title>
    <link>https://connect.hyland.com/t5/alfresco-forum/afresco-201901-ga-6-1-2-search-not-worked/m-p/93350#M27610</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear, developers!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is the overall community 201901 GA (6.1) distributive search mechanism problem or incorrect configuration?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Installed software:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;OS: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;Fedora 30&lt;BR /&gt;DB: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;10.3.12-MariaDB MariaDB Server&lt;BR /&gt;Tomcat: &amp;nbsp;&amp;nbsp;&amp;nbsp;Apache Tomcat 8.5&lt;BR /&gt;JDK: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;openjdk version "11" 2018-09-25 OpenJDK Runtime Environment 18.9 (build 11+28) OpenJDK 64-Bit Server VM 18.9 (build 11+28, mixed mode)&lt;/P&gt;&lt;P&gt;alfresco-search-services: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;Alfresco Search Services 1.3.0.1 using Apache Solr 6.6.5&lt;BR /&gt;alfresco: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;alfresco-content-services-community-distribution-6.1.2-ga&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&lt;STRONG&gt;Search Case:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;1. Open dashboard &lt;BR /&gt;2. Create site title 'abc'&lt;BR /&gt;3. In search field enter 'abc' - got no result&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Analysis:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;1. Turn on debug&lt;/P&gt;&lt;P&gt;Edit file ${CATALINA_HOME}/webapps/alfresco/WEB-INF/classes/log4j.properties&lt;BR /&gt;Add the line:&lt;BR /&gt;log4j.logger.org.alfresco.repo.search.impl.solr.DbOrIndexSwitchingQueryLanguage=debug&lt;/P&gt;&lt;P&gt;2. Restart tomcat&lt;BR /&gt;3. Reproduce the steps&lt;BR /&gt;4. See log catalina.out for stacktrace with exception&lt;BR /&gt;[impl.solr.DbOrIndexSwitchingQueryLanguage] &lt;BR /&gt;org.alfresco.repo.search.impl.querymodel.QueryModelException: 07010023 Analysis mode not supported for DB DEFAULT&lt;BR /&gt; &lt;BR /&gt;&lt;STRONG&gt;Workaround:&lt;/STRONG&gt;&lt;BR /&gt;1. Edit SiteServiceImpl.java in (added '=' sign before cm)&lt;BR /&gt;line:911 query.append(" =cm:name:\" ");&lt;BR /&gt;line:923 query.append(" OR ").append(" =cm:title: ");&lt;BR /&gt;line:926 query.append(" OR =cm:description:\"" + escNameFilter + "\""); &lt;BR /&gt;2. Recompile SiteServiceImpl.class&lt;BR /&gt;3. Update file in archive alfresco-repository-7.43.jar/uzip://org/alfresco/repo/site/SiteServiceImpl.class&lt;BR /&gt;4. Restart tomcat&lt;BR /&gt;5. On dashboard try test case again and we see result without error&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;And:&lt;/STRONG&gt;&lt;BR /&gt;All other searches for folder, user, sites on other pages and so on doesn't work too with different reasons&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 01 Aug 2019 13:38:57 GMT</pubDate>
    <dc:creator>rasl</dc:creator>
    <dc:date>2019-08-01T13:38:57Z</dc:date>
    <item>
      <title>Afresco 201901 GA (6.1.2) search not worked</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/afresco-201901-ga-6-1-2-search-not-worked/m-p/93350#M27610</link>
      <description>Dear, developers!Is the overall community 201901 GA (6.1) distributive search mechanism problem or incorrect configuration?Installed software&lt;IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /&gt;S: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;Fedora 30DB: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;10.3.12-MariaDB MariaDB ServerTomcat: &amp;nbsp;&amp;nbsp;&amp;nbsp;Apache Tomcat 8.5JDK: &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;openjdk version "11" 2018-09-25 OpenJDK Runtime Env</description>
      <pubDate>Thu, 01 Aug 2019 13:38:57 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/afresco-201901-ga-6-1-2-search-not-worked/m-p/93350#M27610</guid>
      <dc:creator>rasl</dc:creator>
      <dc:date>2019-08-01T13:38:57Z</dc:date>
    </item>
    <item>
      <title>Re: Afresco 201901 GA (6.1.2) search not worked</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/afresco-201901-ga-6-1-2-search-not-worked/m-p/93351#M27611</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;It is likely some kind of configuration issue. I have been using 6.1.2 GA with Search Services 1.3.x for a couple of customers now (production systems and demo environments), and have had no issues with search behaviour. Since you listed Fedora as an OS, I am assuming you did a manual setup instead of using the default Docker images...&lt;/P&gt;&lt;P&gt;The exception you listed is actually not a real error - it just states that the specific query in question cannot be executed via the DB, and a fallback to SOLR / Search Services should be attempted after that, provided the integration is properly configured and SOLR is running correctly.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 01 Aug 2019 22:57:36 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/afresco-201901-ga-6-1-2-search-not-worked/m-p/93351#M27611</guid>
      <dc:creator>afaust</dc:creator>
      <dc:date>2019-08-01T22:57:36Z</dc:date>
    </item>
    <item>
      <title>Re: Afresco 201901 GA (6.1.2) search not worked</title>
      <link>https://connect.hyland.com/t5/alfresco-forum/afresco-201901-ga-6-1-2-search-not-worked/m-p/93352#M27612</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thank you Axel!&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;A little bit clear now.&lt;/P&gt;&lt;P&gt;Yes, I'm not using Docker and this is manual setup with Search Services 1.3 without mutual TLS which was shutdowned before tests (with this service enabled also not works). I thought the installation manuals sufficient.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Looks like it is wrong chosen DB (just using standard from Fedora repository). &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Ok, will try other configuration.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 02 Aug 2019 08:01:51 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-forum/afresco-201901-ga-6-1-2-search-not-worked/m-p/93352#M27612</guid>
      <dc:creator>rasl</dc:creator>
      <dc:date>2019-08-02T08:01:51Z</dc:date>
    </item>
  </channel>
</rss>

