Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

DMX search does not find documents
Last Post 11/06/2014 9:41 AM by Peter Donker. 1 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
torheskje
New Member
New Member
Posts:17


--
06/20/2014 10:34 PM
DMX search does not return all the documents that correspond to the search criteria.


sql query:


select s.Text,e.EntryType,e.* from DMX_ShortTexts s
inner join DMX_Entries e on e.EntryId=s.ObjectId
inner join (select e.EntryId from DMX_EntryPermissions e where e.roleId=0 and e.PermissionId=1 and e.PortalId=0) p on p.EntryId=e.EntryId
where s.text like '%TWI%' and s.SubTypeKey='TITLE' and s.TypeKey='ENT'
and e.Deleted=0 and e.EntryId=e.LastVersionId and e.PortalId=0


returns 737 rows


DMX search run when logged in as user host (administrator)


Search: "TWI" on "Title, keywords, Contnents" and "Whole repository"
returns 39 rows (with current settings 100 rows should be returned)

Advanced: Field: Title ; Select: contains ; Search term: TWI Scope: Whole repository
returns 47 rows

About our installation:
DNN version 05.02.03 (74)
DMX version 5.1.3
Search provider: LuceneSearchProvider
Max search results: 100

Our system runs on several servers with merge replication on DNN and DMX sql data once an hour using one distributor and several subscribers. The actual documents are stored in files that "replicate" with wget.
DMX_Entries trigger DMX_EntryUpdatePath has been deactivated for replication.

Once a month we run the DMX script "Reindex Portal, This script will reindex all found entries in the current portal." to update search indexes on all servers because Lucene Search indexes are not updated on documents that are replicated from other sites.

Reindex procedure: stop document (wget) replication, delete all files in D:\flag\flagweb22\Portals\0\DMX\Lucene\Index
run reindex script
Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
11/06/2014 9:41 AM
Since this version search has been significantly overhauled (your version is over 5 years old!). You'll need to upgrade to get the latest features and fixes.
You are not authorized to post a reply.