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
|