Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...SearchItemWordPosition table continually growing due to duplicate entriesSearchItemWordPosition table continually growing due to duplicate entries
Previous
 
Next
New Post
3/20/2013 4:26 AM
 

I am running v7.0.2 and a problem with database capacity because the SearchItemWordPosition is continually growing. Examining the table, there are many duplicate entries in it. I have truncated the table, but the Search Indexer replaces all the entries again, including the duplicate ones.

This problem seems to have been running for a while now. I have seen posts for the same problem / symptoms for v4.8 and onwards. The suggested fix to AddSearchItemWordPosition proc fails with a syntax error when I try to run it in on my database (possibly because the compability level is set to SQL 2005 - but I don't control this). Does anyone know if there is a definitive solution for this yet?



Paul Taylor
Dotcom Software Solutions Ltd
DotNetNuke, ASP.NET and SQL Server Development
 
New Post
3/28/2013 5:41 AM
 

I still haven't got to the bottom of this and would appreciate any help. 

After querying the SearchItemWordPosition and related tables, what I do know is that the duplicate entries are not limited to a single DNN module, but include the list below. This must be an ongoing problem for others as well.

Announcements
DnnForge - NewsArticles
Documents
FAQs
Links
Media
Text/HTML
Wiki

The query I used to discover this is:

select distinct FriendlyName 
from ModuleDefinitions md
inner join Modules m
on md.ModuleDefId = m.ModuleDefId
where m.ModuleID IN (
select DISTINCT ModuleID
from SearchItemWordPosition siwp
inner join SearchItemWord siw
on siwp.SearchItemWordID = siw.SearchItemWordID
inner join SearchItem si
on siw.SearchItemID = si.SearchItemID
group by ModuleID, siw.SearchItemWordID, ContentPosition
having count(1) > 1)



Paul Taylor
Dotcom Software Solutions Ltd
DotNetNuke, ASP.NET and SQL Server Development
 
New Post
3/28/2013 8:17 AM
Accepted Answer 
this is a known issue in some DNN 5 installs, which should have been fixed (http://support.dotnetnuke.com/project...)

I suggest clearing the search tables (see http://www.deutschnetnuke.de/tabid/13...), add a unique index constraint on SearchItemWordID and ContentPosition columns and re-index.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
4/12/2013 6:34 AM
 

Have added a comment in Gemini to the effect that this bug is still active in DNN701.

Thanks for the fix suggestion. Do you know if that approach has been tested? Sounds like it might cause errors in the indexing stored procedures.



Paul Taylor
Dotcom Software Solutions Ltd
DotNetNuke, ASP.NET and SQL Server Development
 
New Post
4/12/2013 7:21 AM
 

Tested it myself. Cleared down Search Index tables, added unique index, ran Search Scheduler job twice, and worked OK on both occasions. No increase in the number of rows in SearchItemWordPosition table after second run of indexing job.



Paul Taylor
Dotcom Software Solutions Ltd
DotNetNuke, ASP.NET and SQL Server Development
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...SearchItemWordPosition table continually growing due to duplicate entriesSearchItemWordPosition table continually growing due to duplicate entries


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out