SharePoint Issues Set 1

Issue 1:

Description of the issue:

The Dundas Chart web part was not displaying properly on SharePoint site or the Installation of Dundas web part solution was not happening.

Technical details:
• While installing Dundas web part solution on in our Staging farm, we were getting following error message:
o “Object reference not set to an instance of an object”
• At the same time the Event ID 3351 was appearing in the Application event Log which was talking about the Permissions issue on SQL server.
• After logging in with the farm account on SharePoint server, the above error message went away, however the web part was still not displaying on http://pilot.career.companyname.us/sites/hrl site.
• While adding the web part on the “HRPortal” page, it was giving following error message:
o Cannot import this web part
• We were also seeing event ID 6611 in the application event logs on the server.
Solution:
• We found missing assembly on the web front end server.
• After reinstalling the Dundas web part solution on both SharePoint servers with Farm admin account, all required dll’s were present in assembly and then we were able to add the web part successfully on SharePoint site.

Issue 2:

Description of the issue:

SharePoint search functionality not working on http://intranet.companyname.us

Technical details:

• The SharePoint search crawl logs were showing following error message:
o Error in site data web service (value does not fall within the expected range)
Solution:
• This issue started happening while domain user account migration.
• This is a known issue with SharePoint SP1 and has been document already.
• To fix this issue , we need to install Post SP1 hot fix for SharePoint:
o http://support.microsoft.com/kb/941422
(NOTE: we can directly install SharePoint SP2 as the hot fix is included in SP2)
Issue 3:

Description of the issue:

When we try to turn the second level recycle bin “OFF” from central administration \ application management \ web application general settings for http://server03:12004/ SharePoint site, the task does not complete.

Technical details:
• We see following event ID when the issue happens:

Event Type: Information
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1314
Date: 6/15/2010
Time: 8:32:15 AM
User: N/A
Computer: SERVER03

Description:
Event code: 4011 Event message: An unhandled access exception has occurred. Event time: 6/15/2010 8:32:15 AM Event time (UTC): 6/15/2010 1:32:15 PM Event ID: 5a09d37ba9a54dfa9b88b2fd184407e2 Event sequence: 155 Event occurrence: 1 Event detail code: 0 Application information: Application domain: /LM/W3SVC/386441856/Root-1-129210571218632131 Trust level: WSS_Minimal Application Virtual Path: / Application Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\17897\ Machine name: SERVER03 Process information: Process ID: 12312 Process name: w3wp.exe Account name: USCOMPANYNAME\Accountname Request information: Request URL: http://server03:12000/_admin/vsgeneralsettings.aspx?WebApplicationId=3f7d7915-
f5af-4bee-a397-8c1c6e427baf Request path: /_admin/vsgeneralsettings.aspx
User host address: 206.245.26.248 User: USCOMPANYNAME\Accountname Is authenticated: True Authentication Type: NTLM Thread account name: USCOMPANYNAME\Accountname

• To understand the potential causes, we enabled the verbose logging for SharePoint from central administration \ operations \ diagnostic logging and collected the log while reproducing the issue.
• We captured following error from log file:

Access Denied for /_admin/vsgeneralsettings.aspx. StackTrace: Microsoft.SharePoint.Utilities.SPUtility:Void HandleAccessDenied(System.Exception), Microsoft.SharePoint.SPGlobal:Void

HandleUnauthorizedAccessException(System.UnauthorizedAccessException), Microsoft.SharePoint.Library.SPRequest:Void GetAdminRecycleBinItems(System.String, System.Object ByRef, UInt32 ByRef), Microsoft.SharePoint.SPRecycleBinItemCollection:Void EnsureContent(), Microsoft.SharePoint.SPRecycleBinItemCollection:Int32 get_Count(), Microsoft.SharePoint.SPRecycleBinItemCollection:System.Guid[] GetSortedSecondStageIds(), Microsoft.SharePoint.SPRecycleBinItemCollection:Void DeleteAllSecondStageItems(), Microsoft.SharePoint.Administration.SPWebApplication:Void set_SecondStageRecycleBinQuota(Int32), Microsoft.SharePoint.ApplicationPages.VirtualServerGeneralSettingsPage:Void BtnSubmit_Click(System.Object, System.EventArgs), System.Web.UI.WebControls.Button:Void OnClick(System.EventArgs), System.Web.UI.WebControls.Button:Void RaisePostBackEvent(System.String), System.Web.UI.Page:Void RaisePostBackEvent(System.Web.UI.IPostBackEventHandler, System.String), System.Web.UI.Page:Void ProcessRequestMain(Boolean, Boolean), System.Web.UI.Page:Void ProcessRequest(Boolean, Boolean), System.Web.UI.Page:Void ProcessRequest(), System.Web.UI.Page:Void ProcessRequest(System.Web.HttpContext), ASP._admin_vsgeneralsettings_aspx:Void ProcessRequest(System.Web.HttpContext), System.Web.HttpApplication+CallHandlerExecutionStep:Void System.Web.HttpApplication.IExecutionStep.Execute(), System.Web.HttpApplication:System.Exception ExecuteStep(IExecutionStep, Boolean ByRef), System.Web.HttpApplication+ApplicationStepManager:Void ResumeSteps(System.Exception), System.Web.HttpApplication:System.IAsyncResult System.Web.IHttpAsyncHandler.BeginProcessRequest(System.Web.HttpContext, System.AsyncCallback, System.Object), System.Web.HttpRuntime:Void ProcessRequestInternal(System.Web.HttpWorkerRequest), System.Web.HttpRuntime:Void ProcessRequestNoDemand(System.Web.HttpWorkerRequest), System.Web.Hosting.ISAPIRuntime:Int32 ProcessRequest(IntPtr, Int32),
Solution:
• As per the above error message, it is clear that the issue is with the permissions.
• We logged in with the “Accountname” account and made the necessary changes which worked fine.

Root cause on why the “Accountname” account was not working in above issue:

• When we disable the recycle bin from central administration site, it actually deletes the items from the recycle bins of all site collections.
• To disable the recycle bin functionality, we need to have following two rights:
o your account should be farm administrator
o Account should be site collection administrator for which we are disabling the recycle bin.
• In our scenario, the “Accountname” account was part of farm administrators group however it was not a site collection administrator for http://server03:12004/ site.
Issue 4:

Description of the issue:

When we go to Central administration site on extranet environment \ application management \ Site collection administrators we get following error message:

“User cannot be found”

Technical details:

• Collected the verbose ULS logs and got following:
"Application error when access /_admin/owners.aspx, Error=User cannot be found. at Microsoft.SharePoint.SPUserCollection.GetByID(Int32 id) at Microsoft.SharePoint.SPSite.get_Owner() at Microsoft.SharePoint.Administration.SPSiteAdministration.get_OwnerLoginName() at Microsoft.SharePoint.ApplicationPages.OwnersPage.OnContextChange(Object sender, EventArgs e) at Microsoft.SharePoint.WebControls.ContextSelector`1.OnContextChange(EventArgs e) at Microsoft.SharePoint.WebControls.ContextSelector`1.set_CurrentId(String value) at Microsoft.SharePoint.WebControls.ContextSelector`1.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive..."
Solution:

• This issue happens when the site collection administrator user account will not be present in dbo.userinfo table of content database.
• To resolve this issue, you can run “STSADM –o siteowner” command and change the site collection administrator.
• However in our environment as we do not have latest SharePoint updates installed , we have to install hot fix from following KB article:
o http://support.microsoft.com/kb/950438
(NOTE: We can directly install SharePoint SP2 as the hot fix is included in SP2)


Issue 5:

Description of the issue:

Production WFE server’s System event Log shows following event intermittently:

Event Type: Warning
Event Source: W3SVC
Event Category: None
Event ID: 1013
Date: 6/26/2010
Time: 1:40:38 AM
User: N/A
Computer: SERVER
Description:
A process serving application pool 'Intranet - 12003' exceeded time limits during shut down. The process id was '4916'.

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

Technical details:

It happens due to Overlapping of IIS event and SharePoint activities. Consider a scenario where, user is uploading a document to SharePoint site which is more than 50 MB which could probably take a long time to finish. As default App pool shut down time is 90 seconds, there are chances where both of these events will overlap each other.
Solution:
• To resolve this issue we can increase a shut down period from 90 seconds to 300 seconds which is recommended by Microsoft.
• You can get more information on this : http://blogs.msdn.com/b/steveshe/archive/2007/12/19/overlapped-recycling-and-sharepoint-configuring-the-shutdown-timeout.aspx


Issue 6:

Description of the issue:

Extranet Production SharePoint Index server (10.202.1.82) shows following event ID’s intermittently:

Event Type: Warning
Event Source: Office Server Search
Event Category: Gatherer
Event ID: 2442
Date: 6/27/2010
Time: 7:00:12 PM
User: N/A
Computer: SERVER03
Description:
The index was paused.

Context: Application 'Companyname', Catalog 'SSP1 ProfileImport'

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

Event Type: Error
Event Source: Office Server Search
Event Category: Gatherer
Event ID: 10027
Date: 6/26/2010
Time: 11:22:00 PM
User: N/A
Computer: SERVER03
Description:
Failed to update committed transaction in SQL, DocID is 23847.

Context: Application 'Companyname SSP1', Catalog 'ProfileImport'

Details:
Unspecified error
(0x80004005)

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

Technical details:

• This can happen due to VERITAS backup software that we have.
• It has been documented on Symantec site.

Solution:

• To resolve this issue we have to either reboot the server or upgrade to latest backup edition of VERITAS.
• You can get more information on :
o http://support.veritas.com/docs/294181


Issue 7:

Description of the issue:

• On Production server , we get following event ID’s:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: User Profiles
Event ID: 5555
Date: 6/29/2010
Time: 2:00:01 AM
User: N/A
Computer: SERVER01
Description:
Failure trying to synch web application 6ae15e83-edc9-46ef-b263-ebe7b1f69d23, ContentDB dab31356-e005-4592-b488-3fcb27b27486 Exception message was Lock request time out period exceeded.

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

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server General
Event ID: 7888
Date: 6/29/2010
Time: 2:00:01 AM
User: N/A
Computer: SERVER01
Description:
A runtime exception was detected. Details follow.
Message: Lock request time out period exceeded.

Techinal Details:
System.Data.SqlClient.SqlException: Lock request time out period exceeded.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)
at Microsoft.Office.Server.UserProfiles.ProfileSynchLockContentDB..ctor(SharedDatabase dbShared, Guid contentDBID, Int32 nTimeout)
at Microsoft.Office.Server.UserProfiles.ProfileSynchLockContentDB.AttemptAcquireLock(ServerContext ctxt, Guid contentDBID, Int32 nTimeout, Boolean bThrow)
at Microsoft.Office.Server.UserProfiles.ProfileSynchLockContentDB.AttemptAcquireLock(ServerContext ctxt, Guid contentDBID, Boolean bThrow)
at Microsoft.Office.Server.UserProfiles.ContentDBSynchronizer.SynchContentDB()
at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)

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

Technical details:

• This event ID’s happens when we move the content database from one environment to another environment without running preparetomove command.
• This can also happens when SharePoint will not know that the web application has already been deleted and try to sync the database profiles.

Solution:
• To resolve this issue we have to follow these steps:
o stsadm- o preparetomove -Site http://siteurl -OldContentDb
o STSADM –o sync –listolddatabases 0
o STSADM –o sync –deleteolddatabases 0
o Stsadm –o sync
o Clear the config cache using following KB article:
1. http://support.microsoft.com/kb/939308

• To find out which GUID is associated to which SharePoint site we can use following tool :
o http://spm.codeplex.com/releases/view/22762#DownloadId=57473
o http://spi.codeplex.com/

(Note:
1. Warning!
This program enables you to update the data in SharePoint object model directly.
Therefore be very careful when changing the data.
2. Make sure that you are on the front-end server and is a server administrator.
3. This product is not fully supported by Microsoft; this is a “As-is” support tool. )
Issue 8:

Description of the issue:

• The “New query department” column is a Choice column in SharePoint pages library under http://intranet.companyname.us/GPEA/pages
• We have the default value set for that column which should display when we create a new page and try to edit that page
• However the default value for that column does not reflect at all

Technical details:

• This seems to be a by design behavior when our Content type where the column (New query department) is associated is not default.

Solution:

• The default content type in the pages document library was “Article page”.
• If we change the default content type from “article page” to “Companyname article page”, the default value displays fine after creating a page.
• You can change the default content type from available content types in following ways:
o Go to pages library \ settings \ document library settings
o Under the content type section, we have “Change new button order and default content type”
o When we go inside that, we can change the “Position from Top” option.
o By default, the first content type will be a Default content type.
• When we make those changes, it works as expected.


Issue 9:

Description of the issue:

Configuration of World clock web parts

Technical details:

• Would like to review available free world clock web part for SharePoint
• Download and configure the free world clock web part on http://dev.companyname.us

Solution:
• Download the free web parts from following location:
o http://worldclock.codeplex.com/
o http://sharepointworldclock.codeplex.com/
• Installed and configured both of the web parts on SharePoint site.
Issue 10:

Description of the issue:

While activating “Office SharePoint server publishing infrastructure” on http://dev.companyname.us site, we get following error message:

Access denied

Technical details:

• We were seeing following error message after enabling the call stack from the web.config file:

Access denied. at Microsoft.SharePoint.Administration.SPPersistedObject.Update()
at Microsoft.SharePoint.Administration.SPJobDefinition.Update()
at Microsoft.SharePoint.Administration.SPWorkItemJobDefinition.Update()
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.<>c__DisplayClass5.b__4()

at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state)
at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.b__2()

at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.AddSchedulingJobDefinitions(SPSite site)

• Also in event viewer we were seeing following:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Publishing Provisioning
Event ID: 4965
Date: 10/21/2008
Time: 10:05:00 AM
User: N/A
Computer: YOURSERVER
Description:
Event log message was: 'Failed to provision the scheduling job definitions. Page scheduling will not succeed.'. Exception was: 'System.Security.SecurityException: Access denied.
at Microsoft.SharePoint.Administration.SPPersistedObject.Update()
at Microsoft.SharePoint.Administration.SPJobDefinition.Update()
at Microsoft.SharePoint.Administration.SPWorkItemJobDefinition.Update()
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.<>c__DisplayClass5.b__4()
at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state)
at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.b__2()
at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)


at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.AddSchedulingJobDefinitions(SPSite site)
The Zone of the assembly that failed was:


Reason:

This error is happening because the account servicing the application pool for our site does not have sufficient access. When we are trying to enable the Publishing feature, it's creating a job definition that does not have access to the SharePoint_Config Database.

Solution/Workaround:
• As a workaround, we can change the application pool identity for the web application. Ni our scenario, I changed the app pool identity for http://dev.companyname.us web application to farm account. We can do that from :
o Central administration \ operations \ service accounts
• after changing the application pool , I was able to enable the publishing feature fine
• Again changed the app pool identity back to original.


Issue 11:

Issue:
The site is hosted over the internet as well, so the people who are accessing the Extranet site over the internet (https://extranet.companyname.us )will not be able to use the check-in/Check-out feature. It comes up with following error:
“Object reference not set to an instance of an object.”
Cause:
It is happening due to the incorrect AAM (Alternate access mappings) setting on SharePoint.
Resolution:
To resolve this issue we have to add following entry in AAM:
https://extranet.companyname.us
Current AAM:
Internal URL Zone Public URL
http://extranet.companyname.us
Default http://extranet.companyname.us


AAM after modification:
Internal URL Zone Public URL
http://extranet.companyname.us
Default http://extranet.companyname.us

https://extranet.companyname.us
Extranet https://extranet.companyname.us