topic Re: SOLR 6 Tracking failed - Exception from executeScript in Alfresco Forum

SOLR 6 Tracking failed - Exception from executeScript

Giuliano — Mon, 08 Feb 2021 20:53:25 GMT

Trying to reinstall Afresco 6.2 ga with ansible scrpt

https://github.com/jpotts/ansible-alfresco
I'm facing a problem never experieced before, correlated with SOLR6 communication malfuncion (I belive)

I have configured both Alfresco and Solr NOT to use SSL (as before ...), so there SHOULD not be any certificate problem.

Syntoms I'm facing:

Serach : no result for any terms
My Documents dashboard : Error loading items

I digged the error logs from alfrsco and solr, but I cannot find an hint on where to try to fix it
Here the full logs

https://github.com/Giuliano69/ansible-alfresco/blob/master/catalina.out
https://github.com/Giuliano69/ansible-alfresco/blob/master/solr.log

It seems that solr and alfresco are not comunicatin anymore, but ansible script did not change (!!)

The solr log keep looping on two "Tracking failed"

The alfresco log, kep looping on "Wrapped exception , and "Failed to execute search"

quick error list in alfresco log

2021-02-08 21:23:11,186 ERROR [extensions.webscripts.AbstractRuntime] [http-nio-8080-exec-1] Exception from executeScript: 01080002 Wrapped Exception (with status template): 01080020 Failed to execute s
cript 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 01080019 Failed to execute search: +@cm\:modified:[2021\-2\-1T00\:00\:00.000 TO 2021\-2\-8T23\:59\
:59.999] +@cm\:modifier:"admin" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fm:post" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")
org.springframework.extensions.webscripts.WebScriptException: 01080002 Wrapped Exception (with status template): 01080020 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/s
lingshot/documentlibrary/doclist.get.js': 01080019 Failed to execute search: +@cm\:modified:[2021\-2\-1T00\:00\:00.000 TO 2021\-2\-8T23\:59\:59.999] +@cm\:modifier:"admin" +TYPE:"cm:content" -TYPE:"cm:s
ystemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fm:post" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")
..
Caused by: org.alfresco.scripts.ScriptException: 01080020 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 01080019 Failed to exe
cute search: +@cm\:modified:[2021\-2\-1T00\:00\:00.000 TO 2021\-2\-8T23\:59\:59.999] +@cm\:modifier:"admin" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic"
-TYPE:"fm:post" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")
...
Caused by: org.alfresco.error.AlfrescoRuntimeException: 01080019 Failed to execute search: +@cm\:modified:[2021\-2\-1T00\:00\:00.000 TO 2021\-2\-8T23\:59\:59.999] +@cm\:modifier:"admin" +TYPE:"cm:conten
t" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fm:post" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")
at org.alfresco.repo.jscript.Search.queryResultMeta(Search.java:1127)
...
Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 01080018 Request failed 500 /solr/alfresco/alfresco?wt=json&fl=DBID%2Cscore&rows=50&df=TEXT&start=0&locale=en_US&alternativeDic
=DEFAULT_DICTIONARY&sort=%40cm%3Amodified+desc&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON

quick errol list in solr log: there are continuos errors like

2021-02-08 20:24:10.012 ERROR (org.alfresco.solr.AlfrescoCoreAdminHandler@69eb86b4_Worker-38) [ ] o.a.s.t.AbstractTracker Tracking failed for AclTracker - archive
java.net.UnknownHostException: alfdev1.metaversant.com
...

2021-02-08 20:24:10.035 ERROR (org.alfresco.solr.AlfrescoCoreAdminHandler@69eb86b4_Worker-21) [ ] o.a.s.t.AbstractTracker Tracking failed for ModelTracker - archive
java.net.UnknownHostException: alfdev1.metaversant.com
..

2021-02-08 20:24:18.220 ERROR (qtp592983282-13) [ x:alfresco] o.a.s.h.RequestHandlerBase org.alfresco.service.namespace.NamespaceException: Namespace prefix cm is not mapped to a namespace URI
at org.alfresco.service.namespace.QName.createQName(QName.java:109)
...
2021-02-08 20:24:18.222 ERROR (qtp592983282-13) [ x:alfresco] o.a.s.s.HttpSolrCall null:org.alfresco.service.namespace.NamespaceException: Namespace prefix cm is not mapped to a namespace URI
at org.alfresco.service.namespace.QName.createQName(QName.java:109)

I also cheched the config files, but both programs seems not to use SSL:

/opt/alfresco/tomcat/shared/classes/alfresco-global.properties

### Solr indexing in alfresco.global.properties###
index.subsystem.name=solr6
dir.keystore=${dir.root}/keystore
solr.host=192.168.0.80
solr.protocol=http
solr.secureComms=none
solr.port=8983
solr.baseUrl=/solr

/opt/alfresco/alfresco-search-services/solrhome/conf/shared.properties

# Shared Properties file
#Host details an external client would use to connect to Solr
solr.host=localhost
#If not set then solr.port will be the jetty.port
#solr.port=8983
solr.baseurl=/solr
solr.content.dir=/opt/alfresco/alf_data/solr6

Have you experimented a similar behaviour ?

Any hint on how ti fix or to investigate ?

Re: SOLR 6 Tracking failed - Exception from executeScript

afaust — Tue, 09 Feb 2021 08:23:04 GMT

The UnknownHostException is quite self-explanatory: Search Service cannot resolve the host name of your ACS instance configured in solrcore.properties (the only file for which you did not provide config snippets). As a result, Search Service was not able to track the repository, which includes retrieving / downloading the data models, which define namespaces and prefixes. Then, when a search call is made to Search Services, it did not have sufficient information to process the request, e.g. transform prefixed field names (e.g. cm:name) into the full field names, which requires resolution of the prefix "cm" using the models to arrive at the full qualified name.

You need to check your DNS / host configuration to enable Search Service to resolve whatever alfresco.host value you put in the solrcore.properties

Re: SOLR 6 Tracking failed - Exception from executeScript

Giuliano — Tue, 09 Feb 2021 21:26:57 GMT

Thanks afaust for your kind reply.

Unfortunately this seems NOT to be the problem... Following your hint, I tried anyway to write in many "possible" way the addres of alfresco.host, but with the SAME result:

#alfresco.host=localhost
#alfresco.host=192.168.0.80
alfresco.host=127.0.0.1

The error log keep showing the same problem (there is also a creation/connection problem on port 8009, but this seems not to be correlated)

I cannot understand why the the previous ansible installation DID work.

These are the log files

https://github.com/Giuliano69/ansible-alfresco/blob/master/errorlogs/catalina.out

https://github.com/Giuliano69/ansible-alfresco/blob/master/errorlogs/solr.log

And these are the configuration files:

https://github.com/Giuliano69/ansible-alfresco/blob/master/errorlogs/alfresco-global.properties

https://github.com/Giuliano69/ansible-alfresco/blob/master/errorlogs/shared.properties

https://github.com/Giuliano69/ansible-alfresco/blob/master/errorlogs/solrcore.properties

If the problem is the ip address, in which OTHER files could be the problem ?
Do the log files give some other possible causes ?
Can the error log depth be augmented, to reach the wrong configuration point ?

Thanks for your patience and help !

Giuliano

Re: SOLR 6 Tracking failed - Exception from executeScript

Giuliano — Tue, 09 Feb 2021 23:06:56 GMT

🙂

I was editing solcore.properties in /rerank directory... which make non difference...

I then insert correction in files undre /alfresco and /archive.... but still doesn't work.

What about the *defalut* config line

# none, https
alfresco.secureComms=https

should it be changed from default (https) to "none" ,

even if /opt/alfresco/tomcat/shared/classes/alfresco-global.properties is *already stating that ?

solr.protocol=http
solr.secureComms=none

AFTER setting this las properties [alfresco.secureComms=none],

(almost) every error disappeared, and search restarted working again...