Issue

Unable to upgrade ‘MOSS 2007 SP1 + Dec 2008 CU (12.0.0.6335)’ to ‘MOSS 2007 SP2 + Aug 2011 CU (12.0.0.6565)’.  It was getting failed on 8^th – 9^th step while running the ‘SharePoint Products and Technologies Configuration Wizard’ with below error message.

SearchSP2AnchorTextDatabaseAction.Upgrade on database SPDBP\SPDBP:SharedServices1_Search_DB

Action 12.2.506.0 of Microsoft.Office.Server.Search.Upgrade.SearchDatabaseSequence failed.

The statistics 'LinkId' is dependent on column 'LinkID'.

Cause

The statistics for ‘LinkID’ and ‘BatchID’ were dependent on column ‘LinkID’ and ‘BatchID’ in ‘SharedServices1_Search_DB’ database and it failed because one or more objects access this column. In order to get this done, dropped and re-created the statistics.

Steps taken to resolve the issue.

·         Drop the statistics for ‘LinkID’ (script attached) and tried to attempt but it got failed on the same step (8^th-9^th) with below error message.

SearchQFE21038DatabaseAction.Upgrade: Changing MSSBatchHistory column BatchID type to bigint on database SPDBP\SPDBP:SharedServices1_Search_DB

Action 12.2.508.0 of Microsoft.Office.Server.Search.Upgrade.SearchDatabaseSequence failed.

The statistics 'BatchID' is dependent on column 'BatchID'.

·         Drop the statistics for ‘BatchID’ (script attached) then tried to attempt and again it got failed on the same step (8^th-9^th) with ASP.Net error message.

Action 3.0.3.0 of Microsoft.SharePoint.Upgrade.SPIisWebSiteWssSequence failed.

InstallAspNet 1785161557 failed.

·         Re-register the ASP.Net component by running the command ‘aspnet_regiis –u’ and ‘aspnet_regiis –I’

·         Attempt to run ‘SharePoint Products and Technologies Configuration Wizard’ and this time MOSS 2007+SP2 got updated successfully.

·         Next steps to install Aug CU 2011, binary got installed on all servers successfully but when we tried to run ‘SharePoint Products and Technologies Configuration Wizard’ then again it got failed on the same step (8^th-9^th) with time out error message.

Action 12.2.508.0 of Microsoft.Office.Server.Search.Upgrade.SearchDatabaseSequence failed to commit.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

·         Restarted the SQL services and SharePoint servers then tried to attempt ‘SharePoint Products and Technologies Configuration Wizard’ and it got completed successfully.

·         Re-created the statistics for ‘LinkID’ and ‘BatchID’ (script attached).

·         Verified the version (12.0.0.6565) from Central Administration -> Operations -> Servers in farm.

Script to drop statistics

/****** Object:  Statistic [LinkId]    ******/

USE [SharedServices1_Search_DB]

GO

if  exists (select * from sys.stats where name = N'LinkId' and object_id = object_id(N'[dbo].[MSSAnchorText]'))

DROP STATISTICS [dbo].[MSSAnchorText].[LinkId]

GO

/****** Object:  Statistic [BatchId]    ******/

USE [SharedServices1_Search_DB]

Go

if  exists (select * from sys.stats where name = N'BatchID' and object_id = object_id(N'[dbo].[MSSBatchHistory]'))

DROP STATISTICS [dbo].[MSSBatchHistory].[BatchID]

GO

Script to create statistics

USE [SharedServices1_Search_DB]

GO

/****** Object:  Statistic [BatchID]    

CREATE STATISTICS [BatchID] ON [dbo].[MSSBatchHistory]([LinkId])

GO

/****** Object:  Statistic [LinkId]    

CREATE STATISTICS [LinkId] ON [dbo].[MSSAnchorText]([LinkId])

GO

PDF Icon does not show in the document library while uploading the pdf file.

Steps Taken for resolution

1. Copy the PDF.GIF file to “C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Images”

2. Edit the file C:\Program Files\Common Files\Microsoft Shared\Web server extensions\12\Template\Xml\DOCICON.XML

1. Add an entry for the .pdf extension.
2. Reset the IIS
3. After that we were able to view the pdf icon in your document library.

Unable to open few Links on SSP Site.

Steps for resolution

1. Unable to open Search Settings page on SSP Site.

Error :- Access Denied C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033\STYLES\Menu.css

Solution:-
Added the WSS_ADMIN_WPG Group on the 12 Folder (Security & Groups).

2. Also unable to open User Profiles and My Sites.
Error:- HTTP 403 Page not found.

Solution:-
Checked the event viewer and ntlm authentication was failing.
And we run the below command
stsadm -o authentication -type windows -usewindowsintegrated -exclusivelyusentlm -enableclientintegration -url http://abcxyz:8080

Issue resolved.

Slow performance of SharePoint Site

Problem:
========================================
SharePoint site takes 25-40 seconds to load initial web page when accessed from overseas sites.
SPS Web server in Toronto is accessed quickly when the client is local, but takes a long time when accessed from Australia, for instance.

Solution:========================================
Traces have been taken from client and server, and we intermittently see a substantial delay between client sending an HTTP GET and server responding, as well as a delay in establishing the initial session. However, there is no way to determine where exactly in the path between the machines the delays are introduced.
The traffic flow is as follows:
Client----->Internal Switches-----> Certeon Application Accelerator-----> Router-----> MPLS Cloud-----> Router-----> Certeon Application Accelerator-----> Internal Switches-----> Web Server

Also of note is that after the initial delay in loading the website, further navigation of the site is done with acceptable performance.
Local Toronto clients do not access the site through the Certeon, but go direct via LAN, and see no delays. So this should eliminate the server config as an issue.
All remote clients experience the delays, some greater than others, generally corresponding to how far away the client is. For instance, clients in Perth see about a 28 second delay in loading the site, while clients in Salt Lake City see a delay of about 15 seconds. This leads us to suspect that the MPLS cloud routing and infrastructure is introducing the delay, but we need to trace on both sides of the
Certeon to eliminate it as the cause.
The Certeon translates the IP address of the client, and also alters the port on which the connection is made to the server, and so it is not possible to correlate packet for packet the communication between client and server captured in the traces.
In order to remove the Certeon devices from the environment, we disabled its functionality on both sides of the connection, effectively allowing all traffic to pass through the devices unaltered. This now allows us to see the full communication between client and server with correct port assignments and IP addresses, and we see that there are actually no intermittent long delays recorded
at all, and the full download of the site legitimately takes a full 28 seconds based on the amount of data over the latency of the connection.

Unable to browse CentralAdminSite. It keeps ask the user name & password.

DESCRIPTION: Unable to browse Central Admin Site. Every time It asks the user name & password while we were putting the right credentials for central admin site.
SYMPTOMS: Every time Central Admin Site asks the user name & password while we are putting the correct credentials.
ERROR MESSAGE: We get the pop-up screen (User Logon Box) for entering the user name and password.
RESOLUTION: Run the command psconfig -cmd adminvs -provision -port 45576 -windowsauthprovider -onlyusentlm
Fixed the issue.

Unable to browse Central Admin Site after applying SP1

DESCRIPTION: Unable to browse the Central Admin Site after applying the Service Pack1 on MOSS 2007.
SYMPTOMS: Unable to run the PSConfig Wizard it fails at first step. Manually Run the PSConfig Wizard using psconfig.exe -cmd upgrade -inplace b2b -wait command also it fails at first step.
ERROR MESSAGE: [SPManager] [ERROR] [8/19/2008 10:19:07 AM]: The specified SPConfigurationDatabase Name=MOSS_Config Parent=SPDatabaseServiceInstance has been upgraded to a newer version of SharePoint.
Please upgrade this SharePoint application server before attempting to access this object.
[SPManager] [ERROR] [8/19/2008 10:19:07 AM]: at Microsoft.SharePoint.Upgrade.SPSequence.get_CanUpgrade()at Microsoft.SharePoint.Upgrade.SPDatabaseWssSequence.InternalCanUpgrade(String sqlstrLegacyBuildVersion)at Microsoft.SharePoint.Upgrade.SPConfigurationDatabaseSequence.get_CanUpgrade()at Microsoft.SharePoint.Upgrade.SPManager.CanUpgrade(Object o)
RESOLUTION:
We found out, In SharePoint Server after applying the SP1. Database was updated but the binary files were not updated on the Application Server. So we decided to re-install the SharePoint server.
So we decided to disconnect the serevr farm through PSConfig Wizard then uninstalled the SharePoint and re-installed the SharePoint then installed the WSS 3.0 SP1 and MOSS 2007 SP1.
Now go to SQL Server open the SQL Managmet Studio and elected the SharePoint_AdminContent_GUID database which is containing the 12.0.0.42518 version in the dbo.version table. Because this is the SharePoint _Admin_Content database before to applying the SP1 and we can add it to the SharePoint Site.
Then run the command 'Stsadm –o addcontentdb –url http://SharePoint:7800 –databasename SharePoint_AdminContent_GUID'
5. Then run the Product and technologies configuration wizard. It will be done successfully.
6. Issue resolved

Unable to delete Shared Services in Sharepoint

DESCRIPTION: Unable to Delete Shared Services when it’s database is deleted from SQL server.
SYMPTOMS: Unable to delete Shared Services. There are still some objects which are dependent on configuration database and on project serve, due to which users are unable to delete SSP. Manually deleting of SSP using stsadm -o deletessp -title “ssp_name” command also shows same error.
ERROR MESSAGE: “An object in the SharePoint administrative framework, “SharedResourceProvider Name=SSP Parent=SPFarm Name=MOSS”, could not be deleted because other objects depend on it. Update all of these dependants to point to null or different objects and retry this operation. The dependant objects are as follows: ProjectPSISharedApplicationTimerJob Name=Project Server Synchronizing Job for ‘SSP’ Parent=ProjectApplicationService Name=ProjectApplicationService”
RESOLUTION: ° Identify the GUID for the problem SSP. ° Use STSADM -o deleteconfigurationobject -id “id retrieved from object table” to remove these items from the configuration database.
Use the following procedure to identify the Shared Services GUID:
Login to SQL server. ° Open SQL Management Studio and expend Databases. ° Expand Configuration Database & Tables. ° Opened table for dbo.object. ° Executed following query in query analyzer: SELECT * FROM [MOSS_CFG_CA_01].[dbo].[Objects]where name like ‘Name of the Shared Services’. ° Copy the ID of object referenced in objects table of configuration database. ° Open command prompt and changed directory to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN> and executed following command to delete the Shared Services using the ID which was copied: Stsadm -o deleteconfigurationobject -id “id retrieved from object table”
Shared Services should be deleted from the Cenral Administration.