Rebuilding Search Index - error Timeout expired /

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
4/26/2011 3:25:58 AM
Gravatar
Total Posts 70

Rebuilding Search Index - error Timeout expired /

I am currently rebuilding the Search Index, because it returns pages I already deleted on the website.

I deleted the files under /Data/Sites/[SiteID]/index.  So when I search it displays No results found.

I have activated the Rebuild Search Index button.

But everytime  I click this button

I get the error below on my System Log:

ERROR mojoportal.web.mojoBasePage -10.11.40.111-en-US -/searchResults.aspx?q=consumer

System.Data.sqlClient.SQLException: Timeout expired. The timeout period elapsed prior to the completiion of the operation or the server is not responding

---

I checked the DB table mp_IndexingQueue and noticed that the IndexPath was 3 different paths

c:mojo\Data\Sites\[SiteID]\index

c:mojo44\Data\Sites\[SiteID]\index

c:mojo33\Data\Sites\[SiteID]\index - this is my latest folder for my website I dont when it still index on my previous folders.

On the last row of ItemKey / RemoveOnly column it displays <unable to read data> 

 

Thanks.

 

Your help is greatly appreciated.

 

Cesse

4/26/2011 6:36:03 AM
Gravatar
Total Posts 18439

Re: Rebuilding Search Index - error Timeout expired /

I would delete all rows from mp_IndexingQueue and mp_TaskQueue before rebuilding the index, there may be rows existing there with the older paths.

Hope it helps,

Joe

4/26/2011 8:57:57 PM
Gravatar
Total Posts 70

Re: Rebuilding Search Index - error Timeout expired /

Hello Joe,

 

I have successfully deleted all table contents and rebuild the search index. 

When I try to Search again the result being rendered are incomplete. for example if I search for a term it should return more than 20 items but it only returns 5. Do I have to edit and update all the contents of my website to make terms searchable?

I also noticed that the index folder contains files different from the one that I back up before I rebuild my index? Does this varies?

 

Thank you.

 

 

4/28/2011 8:27:08 AM
Gravatar
Total Posts 1203
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: Rebuilding Search Index - error Timeout expired /

Are you sure you waited long enough? It can take quite awhile for the indexing process to complete, and until it does you will not get full results when searching.

Jamie

4/28/2011 8:39:18 AM
Gravatar
Total Posts 70

Re: Rebuilding Search Index - error Timeout expired /

Thanks for the replies got my search working.  

Done the following:

  1. Deleted all files on /Data/Sites/[SiteID]/index 
  2. Deleting table  contents

 

You must sign in to post in the forums. This thread is closed to new posts.