topic Re: Some files are not searchable using advance search in Alfresco Archive

Some files are not searchable using advance search

fouada — Wed, 12 Oct 2016 08:27:28 GMT

Hi Everyone,We are using alfresco 4.1.4 and some documents are not searchable using advance search. We have already tried re-indexing but it didn't resolve the issue,Please share some alternatives we can use to make the files searchable. This issue is of Production so please help us it is urgent.

Re: Some files are not searchable using advance search

mrks_js1 — Wed, 12 Oct 2016 10:42:25 GMT

you need to provide more information!

what are the visible differences between a searchable and a non-searchable document? which aspects are set? what are you searching for.

since you seem to be on enterprise you should also be able to contact alfresco support.

Re: Some files are not searchable using advance search

fouada — Wed, 12 Oct 2016 11:24:32 GMT

Firsly I appreciate your quick response.

I am searching document by its name and it gives zero result, but document is present in a particular site.We have already tried Solr re-indexing but it was not helpful. We are using alfresco 4.1.4 so we can't have alfresco support.

Is there any way to find out how many document are not searchable in alfresco.

Thanks,

Fouad

Re: Some files are not searchable using advance search

mitpatoliya — Wed, 12 Oct 2016 12:13:10 GMT

Could you please post details with example on what is searchable and what is not?

Is there any comment pattern in all non searchable documents? Ex. White space in names, Special characters in name etc..

Also check your solr.logs and see if there is any error related to indexes there.

Re: Some files are not searchable using advance search

mrks_js1 — Wed, 12 Oct 2016 12:15:17 GMT

so, if you upload a document "communityTest.txt" and you search for NAME:"communityTest.txt" you dont find it?

have you had a look in the solr console yet?

Connecting to the SSL-protected Solr web application | Alfresco Documentation

get details about 'alfresco' core. specifically fts report stats:

FTS Status Clean, FTS Status Dirty, FTS Status New

please post them or upload a screenshot

Re: Some files are not searchable using advance search

fouada — Wed, 12 Oct 2016 12:49:01 GMT

Like test.mdl is searchable while test1.mdl is not searchable.There is not any White space , Special characters in name.

When I remove extension from file name it get searched. Don't know what is problem indexing or database.

Re: Some files are not searchable using advance search

kalpesh_c2 — Wed, 12 Oct 2016 14:25:45 GMT

Cannot be sure about exact issue. You should check if there is any configuration change in solr indexing properties. Be sure to check if you are searching by keywords, title or name. I assume, your setup does not have any customization in advance search.

When I bump into such issues, I use node browser to validate my search query. It gives details about properties as well. Be sure to check if you the property you are searching for is having appropriate value in node browser. As Markus mentioned, try searching using attribute query.

Try performing the same search with two fresh files. May be, indexes got corrupted while you uploaded these files. Keep your eyes on logs and share log if you see issues.

Thanks,

Kalpesh

ContCentric

Re: Some files are not searchable using advance search

fouada — Wed, 12 Oct 2016 15:16:09 GMT

Hi Markus,

I am able to search newly uploaded document but But there are some old document in repository which are not searchable by name and any other property in advance search.

I have configured solr console what can I look for using solr admin console

Please tell from where we can get these FTS Status Clean, FTS Status Dirty, FTS Status New,Is there any Url or something or from solr admin console

we can get FTS Status

Thank you very much again for sharing information.

Re: Some files are not searchable using advance search

douglascrp — Wed, 12 Oct 2016 22:09:23 GMT

You can get a lot of useful troubleshooting tips here Searching with Alfresco 5.1 Community

Re: Some files are not searchable using advance search

fouada — Thu, 13 Oct 2016 07:44:22 GMT

Thanks a lot for reply It was really helpful, We can know a lot of things Using Solr Admin UI.

I have imported certificate as per steps shown in documents for using Solr admin UI and successfully accessed it using this URL "https://localhost:8443/solr/alfresco/admin/ "But I am not seeing a lot of options, Please have a look on screen shots below.

This is my configuration in alfresco-global.properties of solr

### Solr indexing ###

index.subsystem.name=solr

dir.keystore=${dir.root}/keystore

solr.port.ssl=8443

am i alfresco 4.1.4 and it uses solr 4 . Is there a way to update solr admin UI or I did any thing wrong configuring it? please share you view.

Re: Some files are not searchable using advance search

mrks_js1 — Thu, 13 Oct 2016 07:48:38 GMT

thats not the solr 4 admin ui, you are probably on solr 1.4.1

=> try to find the info under 'Cores: Alfresco'

Re: Some files are not searchable using advance search

fouada — Thu, 13 Oct 2016 08:40:03 GMT

Can we upgrade only Solr from 1.4.1 to 4 without upgrading Alfresco?

Re: Some files are not searchable using advance search

fouada — Thu, 13 Oct 2016 09:39:23 GMT

Hi Markus,

We are planning to re-upload documents which are not searchable . Is there any way to find out unsearchable file name or node-reference, BY Solr admin UI we can only find number of un-index file but not name or noderef of Docs so that we can reupload them.

Thanks,

Fouad

Re: Some files are not searchable using advance search

mrks_js1 — Thu, 13 Oct 2016 15:40:53 GMT

i would suggest to repair your index.

you should be able to list the unindexed transactions and re-try them or run a fix on the index.

its not very straight forward but the link from Douglas C. R. Paes should give you a lot of hints

Re: Some files are not searchable using advance search

binduwavell — Fri, 14 Oct 2016 01:13:02 GMT

Please provide a node dump for one of the nodes you can't find via search. Also please provide an exact sample search you are attempting that is failing. Ideally attempt to find the node via the Node Browser rather than the UI and then provide your findings with exact queries that fail and if you find any, ones that work.

Re: Some files are not searchable using advance search

fouada — Fri, 14 Oct 2016 11:18:28 GMT

Hi Bindu,

I have searched using node browser by providing nodref of unsearchable document and successfully found it But using advance search UI It fails.

I have also compare properties came in node browser with documents property and it is same.

Thanks,

Fouad

Re: Some files are not searchable using advance search

fouada — Fri, 14 Oct 2016 12:39:08 GMT

Hi Kalpesh,

I have checked document using node browser and property are appropriate. Fresh files are searchable checked by uploading new files.

Thanks,

Fouad

Re: Some files are not searchable using advance search

binduwavell — Fri, 14 Oct 2016 13:56:03 GMT

Please provide node dump. Also try searching in node browser using Lucerne or Alfresco FTS syntax.

Re: Some files are not searchable using advance search

kalpesh_c2 — Mon, 17 Oct 2016 14:01:14 GMT

Hi Fouad,

May be you can try executing below links and see if that fixes your problem. Please note this is just fixing the indexes with issues.

https://localhost:8443/solr4/admin/cores?action=FIX

This link expects solr4 installation. If you are using sol1.4 and want to upgrade to solr4, follow this link : Upgrading from Solr 1.4 to Solr 4 search | Alfresco Documentation

Let me know if this helps.

PS : Not sure, if you have solution already. Just thought to share information that might be useful.

Thanks,

Kalpesh

ContCentric

Re: Some files are not searchable using advance search

fouada — Tue, 18 Oct 2016 11:12:36 GMT

Hi Bindu,

I have run the lucene search in node browser for non searchable file. I couldn't get any result.

And I am getting result for searchable file.

Thanks,

Fouad