Friday, July 15, 2011

The Execute method of job definition Microsoft.Office.Server.Search.Administration.IndexingScheduleJobDefinition - threw an exception.

Error Details:
The Execute method of job definition Microsoft.Office.Server.Search.Administration.IndexingScheduleJobDefinition - threw an exception. More information is included below.
Solution Details:

Step 1:
stsadm -o osearch -action stop

Warning: The Office SharePoint Server Search service that was enabled on this server will uninstall and all index files for all SSPs will be deleted. Are you sure you want to permanently delete all data in the index for all SSPs? [y/n]

NOTE: Only do this if you have not crawled / indexed content that cannot be re-indexed. If this is the case, then you open a support ticket with MSFT and work through it. Otherwise, hit Y

Step 2:
Now issue: stsadm -o osearch -action start -role index
You may receive the errror 'start' action failed. Additional information: the handle is invalid. Wait 30-60 secs and re-issue the command. It should go through fine.

Step 3:
Open Central Admin - select your SSP
Check / validate your search service configuration.

Tuesday, July 12, 2011

Steps to Change SharePoint Database "Server Name/IP Address"

Step 1: Login to SharePoint Application Server and Run SharePoint Production Wizard

Step 2: Disconnect the database from Application Server

Step 3: Login to the SharePoint Database Server and Change the Database Server IP Address/Server

Step 4: Open Microsoft Sql Server Management Studio

Step 5: Go to SharePoint_Config Database and Run the following command to change the Exist database IP Address/Server

Find Server Name/IP Address Command (ID Example only):
select * from Objects where id='E41F2DE6-4003-4F8F-BA3C-AFF155B1A643'

Update Server Name/IP Address Command (ID Example only) :
begin tran
update Objects set Name='pkravdb2.naieng.nai.org' where Id='E41F2DE6-4003-4F8F-BA3C-AFF155B1A643'
commit tran

Step 6: Again start run the SharePoint Product Wizard.