Friday, December 12, 2008

SharePoint Configuration Fail after Update

My SharePoint installation is totally broken now. If I am trying to load my homepage I am getting this message:
An error has occurred on the server.http://go.microsoft.com/fwlink?LinkID=96177

I am receiving the following error with the service pack:

Configuration Failed
One or more configuration settings failed. Completed configuration settings will not be rolled back. Resolve the problem and run this configuration wizard again. The following contains detailed information about the failure:

Failed to initiate the upgrade sequence.

An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Ad hoc update to system catalogs is not supported.
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

To diagnose the problem, review the application event log and the configuration log file located at:

c:\....logs\pscdiagnostics....log


Solution:
---------------------------------------------------------------------------------------------------------------
I did a new sql query within the sql database:

USE master;
GOEXEC sp_configure 'show advanced option', '1';

RECONFIGURE WITH OVERRIDE;
EXEC sp_configure;

And afterwards run:SharePoint Products and Technologies Configuration Wizard

..\12\Bin\
---------------------------------------------------------------------------------------------------------------

Psconfig -cmd upgrade -force
Stsadm -o upgrade -inplace -forceupgrade

Tuesday, November 25, 2008

SSRS 2008 x64 add-in Error

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Runtime
Event ID: 6611
Date: 11/25/2008
Time: 1:59:18 PM
User: N/A
Computer: WebFrontEnd Server
Description:
Error: Failure in loading assembly: Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

WSS Search Error

Event Type: Error
Event Source: Windows SharePoint Services 3 Search
Event Category: Gatherer
Event ID: 2424
Date: 9/7/2007
Time: 11:52:50 AM
User: N/A
Computer: Search Server
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'

Solution :

1:Reconfigure Search Service in Central Administrator
2:Delete old Search Database and Create New Database
3:Create New Index after Re Configration of Search Service on Search Server in Farm - Full Crawl

Workflow Features Warning

Event Type: Warning – Repeated
Event Source: Office SharePoint Server
Event Category: Workflow Features
Event ID: 7397
Date: 8/5/2008
Time: 7:38:47 AM
User: N/A
Computer: Server-Name
Description:
message

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.