Sharepoint Server Search is not working - Event ID 2424
Posted On Saturday at at 7:21 PM by VMEvent Type: Error Event Source: Windows SharePoint Services 3 Search
Event Category: Gatherer Event ID: 2424User: N/A
Computer: ComputerName
Description: The update cannot be started because the content sources cannot be accessed. Fix the errors and try the update again. Context: Application 'Search', Catalog 'index file on the search server Search'
Resolution
Central Administration -> Operations -> Services on server -> Click on the Windows Sharepoint Services Search service and make sure that the 'Service Account' and 'Content Access Account' service account specified are the same. They should not be working with two separate accounts. If it still does not work, Stop the service and while starting it again specify a common service account and create a new Search Database.
velmurugan said...
Hi
my Sharepoint server search is not working.i followed your points.and i stopped the service in under Operation in Services on Server tab in "Windows SharePoint Services Search" afterthat i can't start again the service.It's showing below the error.
WSS_Search_ESPROD on ESPROD\OfficeServers contains user-defined schema. Databases must be empty before they can be used. Delete all of the tables, stored procedures and other objects or use a different database.
Troubleshoot issues with Windows SharePoint Services.
How to solve the problem.please help me.
Thanks in advance,Vel
my Sharepoint server search is not working.i followed your points.and i stopped the service in under Operation in Services on Server tab in "Windows SharePoint Services Search" afterthat i can't start again the service.It's showing below the error.
WSS_Search_ESPROD on ESPROD\OfficeServers contains user-defined schema. Databases must be empty before they can be used. Delete all of the tables, stored procedures and other objects or use a different database.
Troubleshoot issues with Windows SharePoint Services.
How to solve the problem.please help me.
Thanks in advance,Vel
Parmi said...hi,
Please delete the database or rename the database "WSS_Search_ESPROD". sharepoint is trying to create a new search database and find the file already exists so its not able to overwrite the schema of that database.
hope this helps.
Please delete the database or rename the database "WSS_Search_ESPROD". sharepoint is trying to create a new search database and find the file already exists so its not able to overwrite the schema of that database.
hope this helps.
velmurugan said...
Hi,
I am getting same error, what you mentioned in image “No results matching your search were found”. I followed your points. I set my URL to AAM (SharedServices22 > Search Settings > Content Sources > Edit Content Source.)
I selected my WSS server here also Application Management > Content Databases.
It throwing error Event IDs: 3759, 6398,11,8193
I stopped the service “Windows SharePoint Services Search” under Central Administration > Operations > Services on Server and again. When I click “start”, service is not starting. It showing error “WSS_Search_server1 on server1\OfficeServers contains user-defined schema. Databases must be empty before they can be used. Delete all of the tables, stored procedures and other objects or use a different database.”
What I do? Please help me
Thanks in advance, velmurugan
I am getting same error, what you mentioned in image “No results matching your search were found”. I followed your points. I set my URL to AAM (SharedServices22 > Search Settings > Content Sources > Edit Content Source.)
I selected my WSS server here also Application Management > Content Databases.
It throwing error Event IDs: 3759, 6398,11,8193
I stopped the service “Windows SharePoint Services Search” under Central Administration > Operations > Services on Server and again. When I click “start”, service is not starting. It showing error “WSS_Search_server1 on server1\OfficeServers contains user-defined schema. Databases must be empty before they can be used. Delete all of the tables, stored procedures and other objects or use a different database.”
What I do? Please help me
Thanks in advance, velmurugan
Lise said...Hi!
That error that you get when you try to start the Windows Search Service means that you must RENAME the search database on that page, because it wants to create a new database for the WSS search. So just add like _new or something after the database name that it suggests (or whatever name you want, I try to be clear with all database names so that you can tell what they belong to on the SQL server). Then you will be able to start the WSS service again.
/Lise
That error that you get when you try to start the Windows Search Service means that you must RENAME the search database on that page, because it wants to create a new database for the WSS search. So just add like _new or something after the database name that it suggests (or whatever name you want, I try to be clear with all database names so that you can tell what they belong to on the SQL server). Then you will be able to start the WSS service again.
/Lise
Velmurugan said...
Hi Lise,
Thanks for your response
I renamed my database (WSS_Search_server1 to WSS_Search_server1_new) and added under (Central Administration > Operations > Services on Server > Windows SharePoint Services Search) page in Search database area, after that I started service "Windows SharePoint Services Search”. The service is started.
But the Search is not working; I am getting below the Event ids: 6482, 7076, and 6398
Please help me
Thanks in advance,Velmurugan
Thanks for your response
I renamed my database (WSS_Search_server1 to WSS_Search_server1_new) and added under (Central Administration > Operations > Services on Server > Windows SharePoint Services Search) page in Search database area, after that I started service "Windows SharePoint Services Search”. The service is started.
But the Search is not working; I am getting below the Event ids: 6482, 7076, and 6398
Please help me
Thanks in advance,Velmurugan
velmurugan writes:
7/8/2009
Hi,
when i search any word in my SharePoint server, an error occurs, it display's the below error, "No results matching your search were found"
http://miss-sharepoint.blogspot.com/2009/03/no-results-matching-your-search-were.html
I (Velmurugan) posted two comments in July 7th 2009 in the above URL.
Please give me the solution,
Thanks in advance, Velmurugan
when i search any word in my SharePoint server, an error occurs, it display's the below error, "No results matching your search were found"
http://miss-sharepoint.blogspot.com/2009/03/no-results-matching-your-search-were.html
I (Velmurugan) posted two comments in July 7th 2009 in the above URL.
Please give me the solution,
Thanks in advance, Velmurugan
In this walk through, you will learn how to customize the default SharePoint search interface by adding new tabs:
a. You will add a new content source.
b. You will add a new scope and add rules for this new scope.
c. You will add a new tab in the search center on your SharePoint site and create search pages for this tab.
d. Finally, you will publish your changes to SharePoint.
1. Open SharePoint Central Administration and select a Shared Services Provider. If you haven't created a SSP yet,
2. Click Search Settings.
3. Click Content sources and crawl schedules in search settings.
4. If there is no content source available, add a new one by clicking New Content Source. By default, Local Office SharePoint Server sites is available.
Open the content source's context menu by left-clicking the down arrow and select Start Full Crawl to index all files. This will start the indexing process.
5. Click View Crawl Log from the same context menu to view the processing.
Had there been any error, a red icon (circle) would have been shown here. This page will show the status of the indexing process.
6. Go back to the search settings page and click View scopes link in the Scopes section. On the page that opens, click New Scope. In the Title, add "My Documents". In the Description field, add some description and click OK.
7. Following page will appear:
Note that Update Status shows "Empty" against the newly added scope (My Documents). Click Add rules link to specify rules for this scope. Select Web Address radio button and enter a web address in the folder text box. This will be the web address of the site you want to search. Click OK.
8. You will notice that the new scope has been added but indexing is still pending.
To start indexing immediately, go to Search Settings page and click Start update now link (Scopes section).
9. Go to the search center of your SharePoint site and add a new tab to search the newly added scope but wait .. before adding a new tab we need to create two pages, one for search and the other for search results.
Go to Site Actions and select Create Page.
Enter "My Documents" in the Title field and enter "MyDocuments" in the URL Name field. In fact, SharePoint will automatically add the URL name but of course, you can change the page name to your liking. Select "(Welcome Page) Search Page" from the Page Layout box and click the Create button.
10. Click Add New Tab link.
Enter "My Documents" in the Tab Name field and "mydocuments.aspx" in the Page field and "Search your favorite documents" in the Tooltip field and click OK.
11. Now, the second step is to create the search results page for the tab we just added. Again, select Create Page from the Site Actions. Enter "My Documents Results" in the Title field. Enter "mydocumentsresults" in the URL Name field. Select "Search Results Page" from the Page Layout box and click the Create button.
12. On the page that opens, click the Add New Tab link. Enter "My Documents" in the Tab Name field and "mydocumentsresults.aspx" in the Page field and click OK
13. Click the edit link in the search box and select Modify Shared Web Part. This will open the properties page for the search box. Expand Miscellaneous and enter "mydocumentsresults.aspx" in the Target search results page URL. By default, this field contains results.aspx.
.14. On the same page, there is another web part called as Search Core Results. Click the edit button in this web part and select Modify Shared Web Part. Expand Miscellaneous and enter the name of the scope that you created in the previous steps (My Documents). Once you have done that, it's time to publish the page. Click Check In to Share Draft link.
15. Try your newly added tab. Enter a keyword and click the search icon. Now, you will see results that are of interest to you. You won't see all the links in the results. Your search results have been filtered.
Working With SharePoint Search - Part 2
1. Open the search center (Select Search from the tabs bar) in your SharePoint site.
2. Select Edit Page from the Site Actions menu.
3. Click the edit link in the Search Box and select Modify Shared Web Part. Expand Scopes Dropdown. There are several options listed in the Dropdown mode dropdown. If you want to show scopes drop down on the search page, select "Show scopes dropdown" and if you want to hide it, select "Do not show scopes dropdown". It doesn't make sense to show the scopes drop down because we are searching only one scope that we added in
4. To increase the width of the search box, expand Query Text Box and add "350" in the Query text box width field. Click Ok to save the changes.
5. Click edit link in the Search Core Results web part and select Modify Shared Web Part. Expand Results Display/Views. Enter "5" in the Results Per Page field. Enter "1" in Sentences in Summary field. This will reduce the cluttering on the results page. Select "Modified Date" in the Default Results View drop down to show the results sorted by the modified date.
6. You can also modify the appearance of the results page by modifying the XSL. Click the XSL Editor... button to open the editor. You will notice there are different sections in the stylesheet. You can change image paths in this stylesheet. You can also modify the text messages that appear on the results page.
7. Click Check In to Share Draft link to publish the changes. You will see the changes that you just made on the results page. There will be only 5 rows, only 1 line summary, etc.
There are some more interesting features related to search that we can take advantage of. For example, SharePoint provides a way to view search usage reports. We all know how important reports are for the administrators, senior managers and executives. Let's explore some of these great features.
1. Open SharePoint Central Administration and click on the Shared Services link. Depending on your needs, you can create more than one SSP. Click on Search usage reports to view some interesting reports. This page shows following reports:
a. Queries over previous 30 days
b. Queries over past 12 months
c. Top query origin site collections over previous 30 days
d. Queries per scope over previous 30 days
e. Top queries over previous 30 days
Good thing about these reports is that you can export them to other formats like Excel and PDF. For example, select "Acrobat(PDF) File" from the Select a format dropdown and click the Export link located next to the dropdown. SharePoint will prompt you to open or save the document.
2. Another nice feature in SharePoint Search is the Search Result Removal. Suppose some one mistakenly uploaded a confidential document which should not have been published and you, as an administrator, want to remove the document from the search results. What will you do? Click Search settings on the Shared services page. Under Crawl Settings, select Search result removal. Enter the path of the confidential document in the URLs to remove and click Remove Now button. That's it! The link(s) will be immediately removed from the index and yes, there is no need to start the crawl to re-index the site.
3. There are some more useful reports that I forgot to mention. On shared services page, click Search usage reports. Click Search results from the Search usage reports box on the left.
This view shows following reports:
a. Search Results Top Destination Pages
b. Queries With Zero Results
c. Most Clicked Best Bets
d. Queries With Zero Best Bets
e. Queries With Low Clickthrough
4. You can create crawl rules of your own. On the Configure Search Settings page, click Crawl rules link and then click New Crawl Rule.
Enter a path in the Path field. You can exclude or include this path from the crawl process depending on your requirements. If you select Exclude all items in this path, all other options on this page will be grayed out. In that case, this path will not be included in the crawl process. If you include it in the indexing process, then you can make some more configurations which can be seen in the above figure. For example, you can enable the Crawl complex URLs option to include all types of URLs in the indexing process. You can also specify authentication and not only that, you can also select a certificate from the drop down if you select the Specify client certificate option.
5. You can enable or disable search based alerts by clicking the Search-based alerts link on the Configure Search Settings page.