<?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 Solr - Mismatch character EOF expecting ''' in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/solr-mismatch-character-eof-expecting/m-p/278361#M231491</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I’m trying to perform a search using alfresco foundation api, but I’m facing some troubles.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Follow the log when I perform a simple search (@cm:name:\”001899.xml\") by my code:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;2014-11-30 17:22:58,827&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-1] &amp;gt;&amp;gt; "POST /solr/alfresco/afts?wt=json&amp;amp;fl=DBID%2Cscore&amp;amp;rows=1000&amp;amp;df=TEXT&amp;amp;start=0&amp;amp;locale=pt_BR&amp;amp;alternativeDic=DEFAULT_DICTIONARY&amp;amp;fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&amp;amp;fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON HTTP/1.1[\r][\n]"&lt;BR /&gt; 2014-11-30 17:22:58,839&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-1] &amp;gt;&amp;gt; "Authorization: Basic YWRtaW46YWRtaW4=[\r][\n]"&lt;BR /&gt; 2014-11-30 17:22:58,839&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-1] &amp;gt;&amp;gt; "User-Agent: Jakarta Commons-HttpClient/3.1[\r][\n]"&lt;BR /&gt; 2014-11-30 17:22:58,839&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-1] &amp;gt;&amp;gt; "Host: localhost[\r][\n]"&lt;BR /&gt; 2014-11-30 17:22:58,839&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-1] &amp;gt;&amp;gt; "Content-Length: 292[\r][\n]"&lt;BR /&gt; 2014-11-30 17:22:58,839&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-1] &amp;gt;&amp;gt; "Content-Type: application/json[\r][\n]"&lt;BR /&gt; 2014-11-30 17:22:58,840&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-1] &amp;gt;&amp;gt; "[\r][\n]"&lt;BR /&gt; 2014-11-30 17:22:58,840&amp;nbsp; DEBUG [httpclient.wire.content] [http-bio-8080-exec-1] &amp;gt;&amp;gt; "{"tenants":[""],"locales":["pt_BR"],"defaultNamespace":"&lt;A href="http://www.alfresco.org/model/content/1.0%22,%22textAttributes" rel="nofollow noopener noreferrer"&gt;http://www.alfresco.org/model/content/1.0','textAttributes&lt;/A&gt;":[],"defaultFTSOperator":"OR","defaultFTSFieldOperator":"OR","query":"@cm\\:name:\"001899.xml\"","templates":[],"allAttributes":[],"queryConsistency":"DEFAULT","authorities":[]}"&lt;BR /&gt; 2014-11-30 17:22:59,161&amp;nbsp; ERROR [solr.core.SolrCore] [http-bio-8443-exec-3] org.alfresco.repo.search.impl.parsers.FTSQueryException: 10300000 line 1:1 mismatched character '&amp;lt;EOF&amp;gt;' expecting '"'&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;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The same search performed by the node browser:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;2014-11-30 17:24:10,053&amp;nbsp; DEBUG [httpclient.wire.content] [http-bio-8080-exec-4] &amp;gt;&amp;gt; "{"tenants":[""],"locales":["en_US"],"defaultNamespace":"&lt;A href="http://www.alfresco.org/model/content/1.0%22,%22textAttributes" rel="nofollow noopener noreferrer"&gt;http://www.alfresco.org/model/content/1.0','textAttributes&lt;/A&gt;":[],"defaultFTSOperator":"OR","defaultFTSFieldOperator":"OR","query":"@cm\\:name:\"001899.xml\"","templates":[],"allAttributes":[],"queryConsistency":"DEFAULT","authorities":["GROUP_EVERYONE","ROLE_ADMINISTRATOR","ROLE_AUTHENTICATED","admin"]}"&lt;BR /&gt; 2014-11-30 17:24:10,116&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-4] &amp;lt;&amp;lt; "HTTP/1.1 200 OK[\r][\n]"&lt;BR /&gt; 2014-11-30 17:24:10,116&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-4] &amp;lt;&amp;lt; "HTTP/1.1 200 OK[\r][\n]"&lt;BR /&gt; 2014-11-30 17:24:10,116&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-4] &amp;lt;&amp;lt; "Server: Apache-Coyote/1.1[\r][\n]"&lt;BR /&gt; 2014-11-30 17:24:10,116&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-4] &amp;lt;&amp;lt; "Content-Type: text/plain;charset=UTF-8[\r][\n]"&lt;BR /&gt; 2014-11-30 17:24:10,116&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-4] &amp;lt;&amp;lt; "Content-Length: 143[\r][\n]"&lt;BR /&gt; 2014-11-30 17:24:10,116&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-4] &amp;lt;&amp;lt; "Date: Sun, 30 Nov 2014 19:24:10 GMT[\r][\n]"&lt;BR /&gt; 2014-11-30 17:24:10,116&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-4] &amp;lt;&amp;lt; "[\r][\n]"&lt;BR /&gt; 2014-11-30 17:24:10,117&amp;nbsp; DEBUG [httpclient.wire.content] [http-bio-8080-exec-4] &amp;lt;&amp;lt; "{"responseHeader":{"status":0,"QTime":52},"response":{"numFound":1,"start":0,"maxScore":3.3113513,"docs":[{"DBID":["853"],"score":3.3113513}]}}"&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;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The only difference I could notice was the authorities and the locale, but I do not believe that it is the cause.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;My Java code:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-java line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;ResultSet results&amp;nbsp; = null;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;SearchParameters sp = new SearchParameters();&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;sp.setLanguage(SearchService.LANGUAGE_SOLR_FTS_ALFRESCO);&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;sp.setQuery("@cm\\:name:\"001899.xml\"");&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;sp.addStore(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE);&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;results = searchService.query(sp);&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;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;The version of Alfresco I’m using is 4.2.f.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks a lot.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sun, 30 Nov 2014 19:41:28 GMT</pubDate>
    <dc:creator>moraisdefreitas</dc:creator>
    <dc:date>2014-11-30T19:41:28Z</dc:date>
    <item>
      <title>Solr - Mismatch character EOF expecting '''</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/solr-mismatch-character-eof-expecting/m-p/278361#M231491</link>
      <description>I’m trying to perform a search using alfresco foundation api, but I’m facing some troubles.Follow the log when I perform a simple search (@cm:name:\”001899.xml\") by my code:2014-11-30 17:22:58,827&amp;nbsp; DEBUG [httpclient.wire.header] [http-bio-8080-exec-1] &amp;gt;&amp;gt; "POST /solr/alfresco/afts?wt=json&amp;amp;</description>
      <pubDate>Sun, 30 Nov 2014 19:41:28 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/solr-mismatch-character-eof-expecting/m-p/278361#M231491</guid>
      <dc:creator>moraisdefreitas</dc:creator>
      <dc:date>2014-11-30T19:41:28Z</dc:date>
    </item>
    <item>
      <title>Re: Solr - Mismatch character EOF expecting '''</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/solr-mismatch-character-eof-expecting/m-p/278362#M231492</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;the authorities can theoretically be an issue here because they are used in the query too (as a filter query). There should always be at least one entry in the authorities array. Your code leading to an empty array has me thinking that the code runs in a context where the user has not been properly authenticated yet (or identified as a guest / anonymous user with the appropriate authority for that).&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;With what kind of code are you calling the SearchService? Web script / action?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Regards&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Axel&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 01 Dec 2014 09:32:15 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/solr-mismatch-character-eof-expecting/m-p/278362#M231492</guid>
      <dc:creator>afaust</dc:creator>
      <dc:date>2014-12-01T09:32:15Z</dc:date>
    </item>
    <item>
      <title>Re: Solr - Mismatch character EOF expecting '''</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/solr-mismatch-character-eof-expecting/m-p/278363#M231493</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Dear Axel,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;That's was the point. I'm using a WebScript and, in order to perform some tests, I have included this line:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;lt;webscript&amp;gt;&lt;BR /&gt;&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;authentication&amp;gt;none&amp;lt;/authentication&amp;gt;&lt;BR /&gt;&amp;lt;/webscript&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;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Just changed to:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;&amp;lt;webscript&amp;gt;&lt;BR /&gt;&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;authentication&amp;gt;guest&amp;lt;/authentication&amp;gt;&lt;BR /&gt;&amp;lt;/webscript&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;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;And fix the error&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks a lot.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 01 Dec 2014 13:48:44 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/solr-mismatch-character-eof-expecting/m-p/278363#M231493</guid>
      <dc:creator>moraisdefreitas</dc:creator>
      <dc:date>2014-12-01T13:48:44Z</dc:date>
    </item>
  </channel>
</rss>

