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 

[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.

[abhinavmishra14]

Try enabling local transform service as suggested by @robinp , if you are using share and solr (specially). 

Please keep in mind that when your deployment has Share and SOLR (think of full text indexing), or both then you'll need to have local.transform and transformservice (asynchronous - only for enterprise edition) enabled and running.

The Repository will try to transform content using the Transform Service via the T-Router if possible and fall back to direct Local Transform Service. Share makes use of both, so functionality such as preview will be unavailable if local.transform service is disabled.