Full Text Search in Community 7.x

[oto]

Hello, Full Text Search not working in any uploaded document, i have Alfresco All In One archetype runing on Docker container.

[robinp]

Hi,

can you provide more informations (configurations, logs etc..) about the issue?

How do you check if full text search is working or not?

[oto]

Hello, im trying search using Share web portal search 

Also i have tried Search using  Rest API from alfresco API-EXPLORER with following query and it returned documents wich title conatines "simple" text;
{
"query": {
"query": "*simple*",
"language": "afts"
}
}

//Alfresco-global.properties

alfresco.context=alfresco
alfresco.host=localhost
alfresco.port=8080
alfresco.protocol=http

# Alfresco Share Webapp (share.war) context, ports etc
share.context=share
share.host=localhost
share.port=8180
share.protocol=http

# Don't try and recover any index
index.recovery.mode=NONE

# These jobs seem to require Lucene (Unsupported Operation with Solr) so we disable them / set to future date
# See https://forums.alfresco.com/en/viewtopic.php?f=52&t=41597
# If you want to enable them (and so full WQS functionality), please also set index.subsystem.name=lucene
wcmqs.dynamicCollectionProcessor.schedule=0 30 2 * * ? 2060
wcmqs.feedbackProcessor.schedule=0 40 2 * * ? 2060
wcmqs.publishQueueProcessor.schedule=0 50 2 * * ? 2060

# Fail or not when there are node integrity checker errors
integrity.failOnError=true

# Alfresco Repository PostgreSQL Database configuration.
# The PostgreSQL Driver is brought in via the tomcat7-maven-plugin as a dependency.
db.driver=org.postgresql.Driver

# This Alfresco Platform Configuration file should be used for custom properties that are introduced by this module.
# Define default values for all properties here.
# System Administrators can override these values in environment specific configurations in
# alfresco/tomcat/shared/classes/alfresco-global.properties.
#
index.subsystem.name=solr6
solr.host=fina-epg-ass
solr.port=8983
solr.secureComms=secret
solr.sharedSecret=secret

db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100

db.url=jdbc:postgresql://fina-epg-postgres:5432/alfresco

# File servers related properties
# For local runs we disable CIFS and FTP
cifs.enabled=false
ftp.enabled=false

csrf.filter.enabled=false

# Embedded broker without persistence
messaging.broker.url=vm://localhost?broker.persistent=false

# Disable ATS
transform.service.enabled=false
local.transform.service.enabled=false
legacy.transform.service.enabled=false

//solr 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

# Properties treated as identifiers when indexed

alfresco.identifier.property.0={http://www.alfresco.org/model/content/1.0}creator
alfresco.identifier.property.1={http://www.alfresco.org/model/content/1.0}modifier
alfresco.identifier.property.2={http://www.alfresco.org/model/content/1.0}userName
alfresco.identifier.property.3={http://www.alfresco.org/model/content/1.0}authorityName
alfresco.identifier.property.4={http://www.alfresco.org/model/content/1.0}lockOwner

# Suggestable Propeties
alfresco.suggestable.property.0={http://www.alfresco.org/model/content/1.0}name
alfresco.suggestable.property.1={http://www.alfresco.org/model/content/1.0}title
alfresco.suggestable.property.2={http://www.alfresco.org/model/content/1.0}description
alfresco.suggestable.property.3={http://www.alfresco.org/model/content/1.0}content

# Data types that support cross locale/word splitting/token patterns if tokenised
alfresco.cross.locale.property.0={http://www.alfresco.org/model/content/1.0}name
alfresco.cross.locale.property.1={http://www.alfresco.org/model/content/1.0}lockOwner

# Data types that support cross locale/word splitting/token patterns if tokenised
alfresco.cross.locale.datatype.0={http://www.alfresco.org/model/dictionary/1.0}text
alfresco.cross.locale.datatype.1={http://www.alfresco.org/model/dictionary/1.0}content
alfresco.cross.locale.datatype.2={http://www.alfresco.org/model/dictionary/1.0}mltext

alfresco.model.tracker.cron=0/10 * * * * ? *

# Whether path queries are enabled.
alfresco.cascade.tracker.enabled=true

Log File Links:
Alfresco.log 
Share.log 
solr.log 

ActiveMQ.log 

[oto]

Any suggestions? 

[robinp]

Hi,

when you run a solr query, details should be visible in the logs if there is an error. I'm assuming there are no syntax errors in the query you run so this is a clear configuration issue but looking at your *.properties files I'm not sure what it can be. When you upload any document do you see changes in the indexes? Normally every time you upload a document they should change. 

When you're using search API through the api explorer do you receive the correct results? So the problem is only in the advanced search?

[oto]

Hello, Thank you for your response.

when i use search API through the API-EXPLORER im getting incorrect results, i think it is only searching in documents titles not in content.

I have no error messages in log files.

when i upload new document 

'Alfresco Nodes in Index' is incremeting ,

also 

'Id for last TX in index' and 'Id for last TX on server' are updating.

I have generated this project from Alfresco All-In-One maven archetype, and iti is running on Mac OSX aarch64 m1 chip.

Alfresco services is running on docker. 

[robinp]

Ok, so the main problem is that you're not able to search in the content of the document.

For example: if you search for query -> cm:title:"*simple*" you have correct results, but you have incorrect results when searching for TEXT:"*simple*".

You should maybe check the transformers (they're responsible to extract text from docs). I don't remember if by default in the maven archetype the index of the content is disabled (for example alfresco.index.transformContent must be true otherwise you're going to index only docs metadata).

[robinp]

Just found these properties on the global properties file you shared:

# Disable ATS
transform.service.enabled=false
local.transform.service.enabled=false
legacy.transform.service.enabled=false

[oto]

I have enabled legacy transform service but result is same.

legacy.transform.service.enabled=true

even if i search with cmis query.
SELECT * FROM cmis:document WHERE CONTAINS('blah')

[robinp]

Hi,

afaik from Alfresco Content Services 7 legacy transformers are no more supported.

You should use local.transform.service.enabled=true to enable local transformations (and content indexing).

Follow the official Alfresco Docs to configure it correctly based on your installed version of ACS.