1. Permission control.
2. Too many items in one list/library.
So, if there is choices, go for metadata!
Showing posts with label SharePoint 2010. Show all posts
Showing posts with label SharePoint 2010. Show all posts
Thursday, May 30, 2019
When to use folder in SharePoint list/library?
Just read a nice article. I agree with Joanne Klein, but I only see two practical reasons to use folder.
1. Permission control.
2. Too many items in one list/library.
1. Permission control.
2. Too many items in one list/library.
Monday, July 2, 2018
The confusion when a user just moved from Shared Folder to SharePoint
Traditionally, how a user write a document?
One option is to map a SharePoint document library to local network mapped folder:
For SharePoint On-Premise:
For SharePoint Online:
Then users can save the document to that Shared Drive directly, just like what they did with "Shared Folder".
That works, but then we lost most of the benefit from SharePoint.
"SharePoint" means team work. So if a user wants to write a document, below are the steps.
SharePoint cannot do that by itself.
PS: Thanks for the reminding from my colleague Andrew Warland, nowadays, users can save the document to SharePoint sites with the help from the latest MS Office. That saves a lot of trouble.
It's still better to think more for other team members at the very beginning.
- Launch a MS Office Program, such as MS Word;
- Give the document a topic;
- Put content into it;
- Save.
One option is to map a SharePoint document library to local network mapped folder:
For SharePoint On-Premise:
For SharePoint Online:
Then users can save the document to that Shared Drive directly, just like what they did with "Shared Folder".
That works, but then we lost most of the benefit from SharePoint.
"SharePoint" means team work. So if a user wants to write a document, below are the steps.
- Ask themselves the question: Where should I store this document, so other users can find it easily?
- Who should have rights to view it, and who should be able to modify it?
- What kind of metadata should this document has? So users can get the basic information without opening it, such as "due date, document owner, project name, etc.".
- Go to the SharePoint document library in web browser (IE 11 is recommended at the moment), then click "new" button.
SharePoint cannot do that by itself.
PS: Thanks for the reminding from my colleague Andrew Warland, nowadays, users can save the document to SharePoint sites with the help from the latest MS Office. That saves a lot of trouble.
It's still better to think more for other team members at the very beginning.
Wednesday, October 18, 2017
Change DocumentID prefix through PowerShell script
Four and a half years ago, I submitted a post about how to change DocumentID prefix manually for a single document.
Eventually I realised it's convenient to use site collection path name as the DocumentID prefix. However, if users want to change the site collection name, then we have to refresh the DocumentID for all documents.
Here is about how to do that through PowerShell for multiple site collections.
$ver = $host | select version
if ($ver.Version.Major -gt 1) {$Host.Runspace.ThreadOptions = "ReuseThread"}
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.Office.DocumentManagement -ErrorAction SilentlyContinue
Set-StrictMode -Version Latest
$ErrorActionPreference="Continue"
# https://gallery.technet.microsoft.com/scriptcenter/Write-Log-PowerShell-999c32d0
# Write-Log -Message 'Log message'
# Write-Log -Message 'Restarting Server.'
# Write-Log -Message 'Folder does not exist.' -Level Error
$Global:LogFile = "E:\DailyBackup\Log\ResetDocumentID." + (Get-Date).ToString("yyyyMMdd-HHmmss") + ".txt"
function Write-Log{
[CmdletBinding()]
Param
(
[Parameter(Mandatory=$true, ValueFromPipelineByPropertyName=$true)]
[ValidateNotNullOrEmpty()]
[Alias("LogContent")]
[string]$Message,
[Parameter(Mandatory=$false)]
[ValidateSet("Error","Warn","Info","HighLight")]
[string]$Level="Info"
)
Begin{
$VerbosePreference = 'Continue'
}
Process{
#if (!(Test-Path $LogFile)) {
# Write-Verbose "Creating $LogFile."
# $NewLogFile = New-Item $LogFile -Force -ItemType File
#}
$FormattedDate = Get-Date -Format "yyyy-MM-dd HH:mm:ss"
switch ($Level) {
'Error' {
$LevelText = 'ERROR:'
$MessageColor = [System.ConsoleColor]::Red
}
'Warn' {
$LevelText = 'WARNING:'
$MessageColor = [System.ConsoleColor]::Yellow
}
'Info' {
$LevelText = 'INFO:'
$MessageColor = [System.ConsoleColor]::DarkGreen
}
'HighLight' {
$LevelText = 'HIGHLIGHT:'
$MessageColor = [System.ConsoleColor]::Green
}
}
Write-Host $Message -f $MessageColor
$MessageContent = "$FormattedDate $LevelText $Message"
$MessageContent | Out-File -FilePath $Global:LogFile -Append
#$opts = @{ForegroundColor=$MessageColor; BackgroundColor="black"; object=$MessageContent}
#Write-Log $opts
}
End{
}
}
function GetWebAppUrlFromSiteUrl([string]$SiteUrl){
#Write-Log -Message "GetWebAppUrlFromSiteUrl(), start......SiteUrl=$SiteUrl" -Level HighLight
$site = Get-SPSite -Identity $SiteUrl
$WebAppUrl = $site.WebApplication.GetResponseUri([Microsoft.SharePoint.Administration.SPUrlZone]::Default).AbsoluteUri
if ($WebAppUrl.EndsWith("/","CurrentCultureIgnoreCase")){
$WebAppUrl = $WebAppUrl.Substring(0, $WebAppUrl.Length - 1)
}
$site.Dispose()
#Write-Log -Message "GetWebAppUrlFromSiteUrl(), complete. WebAppUrl=$WebAppUrl" -Level HighLight
return $WebAppUrl
}
function GetSiteNameFromSiteUrl([string]$SiteUrl){
# Write-Log -Message "GetSiteNameFromSiteUrl(), start......SiteUrl=$SiteUrl"
if ($SiteUrl.EndsWith("/","CurrentCultureIgnoreCase")){
$SiteUrl = $SiteUrl.Substring(0, $SiteUrl.Length - 1)
}
$iPos = $SiteUrl.LastIndexOf('/')
$SiteUrl = $SiteUrl.Substring($iPos + 1)
# Write-Log -Message "GetSiteNameFromSiteUrl(), complete. SiteUrl=$SiteUrl"
return $SiteUrl
}
function StartTimerJob([string]$WebAppUrl, [string]$JobName){
Write-Log -Message "StartTimerJob(), start......WebAppUrl=$WebAppUrl, JobName=$JobName"
$job = Get-SPTimerJob -WebApplication $WebAppUrl $JobName
if (!$job){
Write-Log -Message "StartTimerJob(), No valid timer job found, WebAppUrl=$WebAppUrl, JobName=$JobName" -Level Error
return
}
$startTime = $job.LastRunTime
Start-SPTimerJob $job
while (($startTime) -eq $job.LastRunTime)
{
Write-Host -NoNewLine "."
Start-Sleep -Seconds 2
}
Write-Log "Timer Job '$JobName' has completed on $WebAppUrl."
# Write-Log -Message "StartTimerJob(), complete. SiteUrl=$SiteUrl"
return
}
# https://blogs.perficient.com/microsoft/2015/01/set-up-document-id-prefix-in-sharepoint-2013-programmatically/
function ResetDocumentID([string]$startSPSiteUrl){
Write-Log -Message "ResetDocumentID(), startSPSiteUrl=$startSPSiteUrl"
$SiteUrlPrevious = ""
$SiteUrl = ""
$WebAppUrl = ""
$WebAppUrlPrevious = ""
$rootweb = $null
$SiteCount = 0
$i = 0
$sites = @(Get-SPSite -Limit ALL | ?{$_.ServerRelativeUrl -notmatch "Office_Viewing_Service_Cache" `
-and $_.Url.Startswith($startSPSiteUrl, "CurrentCultureIgnoreCase") `
-and $_.Url -notmatch "SearchCenter" `
-and $_.Url -notmatch "IPForm " `
-and $_.Url -notmatch "SPTest" `
-and $_.Url -notmatch "mysite"})
$SiteCount = $sites.count
if ($SiteCount -eq 0){
Write-Log -Message "No valid SPSite found, startSPSiteUrl=$startSPSiteUrl" -Level Error
return
}
else{
Write-Log -Message "sites.count=$SiteCount"
}
$progressBarTitle = "ResetDocumentID(), Scan SPSites, SiteCount=$SiteCount, startSPSiteUrl=$startSPSiteUrl"
foreach ($site in $sites){
$i++
Write-Progress -Activity $progressBarTitle -PercentComplete (($i/$SiteCount)*100) -Status "Working"
$SiteUrl = $site.Url
$WebApplicationUrl =
Write-Log "ResetDocumentID(), SiteUrl=$SiteUrl"
if ($site.ReadOnly){
Write-Log "ResetDocumentID(), Site($SiteUrl) is read-only. Skip." -Level Warn
Continue
}
$WebAppUrl = GetWebAppUrlFromSiteUrl $SiteUrl
if ($WebAppUrl.EndsWith(".local","CurrentCultureIgnoreCase") -eq $false){
Write-Log -Message "ResetDocumentID(), skip web application: WebAppUrl=$WebAppUrl"
continue
}
Try{
$SiteName = GetSiteNameFromSiteUrl $SiteUrl
Write-Log "ResetDocumentID(), DocumentID=$SiteName"
[Microsoft.Office.DocumentManagement.DocumentID]::EnableAssignment($site,$false) #First disable, then enable DocID assignment
[Microsoft.Office.DocumentManagement.DocumentID]::EnableAssignment($site,$true)
$rootweb=$site.rootweb
$rootweb.properties["docid_msft_hier_siteprefix"]= $SiteName # This is the property holding the Document ID Prefix which we use to ensure uniqueness
$rootweb.properties.Update()
$rootweb.Update()
[Microsoft.Office.DocumentManagement.DocumentID]::EnableAssignment($site,$true,$true,$true) # now we can force all Document IDs to be reissued
}
Catch [system.exception]{
$strTmp = [string]::Format("ResetDocumentID(), startSPSiteUrl={0}, SiteUrl={1}, ex.Message={2}", $startSPSiteUrl, $SiteUrl, $Error[0].Exception.Message)
Write-Log $strTmp -Level Error
Write-Log $_.Exception -Level Error
}
Finally{
if ($rootweb){
$rootweb.Dispose()
}
if ($site){
$site.Dispose()
}
}
if ([string]::IsNullOrEmpty($SiteUrlPrevious)){
$SiteUrlPrevious = $SiteUrl
$WebAppUrlPrevious = $WebAppUrl
}
if ($WebAppUrl.Equals($WebAppUrlPrevious, [StringComparison]::InvariantCultureIgnoreCase) -eq $false){
StartTimerJob $WebAppUrl "DocIdEnable"
StartTimerJob $WebAppUrl "DocIdAssignment"
$WebAppUrlPrevious = $WebAppUrl
}
Write-Log -Message "ResetDocumentID(), completed"
}
StartTimerJob $WebAppUrl "DocIdEnable"
StartTimerJob $WebAppUrl "DocIdAssignment"
}
cls
# $_SiteNameSuffix = '2016DEV'
# $_SiteNameSuffix = '2013DEV'
$_SiteNameSuffix = ''
# $_SiteUrl = ""
$_SiteUrl = "http://team$_SiteNameSuffix.SharePointServer.local/sites/SiteCollectionName"
ResetDocumentID $_SiteUrl
Write-Log -Message "Finished! Press enter key to exit."
#Read-Host
Eventually I realised it's convenient to use site collection path name as the DocumentID prefix. However, if users want to change the site collection name, then we have to refresh the DocumentID for all documents.
Here is about how to do that through PowerShell for multiple site collections.
$ver = $host | select version
if ($ver.Version.Major -gt 1) {$Host.Runspace.ThreadOptions = "ReuseThread"}
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.Office.DocumentManagement -ErrorAction SilentlyContinue
Set-StrictMode -Version Latest
$ErrorActionPreference="Continue"
# https://gallery.technet.microsoft.com/scriptcenter/Write-Log-PowerShell-999c32d0
# Write-Log -Message 'Log message'
# Write-Log -Message 'Restarting Server.'
# Write-Log -Message 'Folder does not exist.' -Level Error
$Global:LogFile = "E:\DailyBackup\Log\ResetDocumentID." + (Get-Date).ToString("yyyyMMdd-HHmmss") + ".txt"
function Write-Log{
[CmdletBinding()]
Param
(
[Parameter(Mandatory=$true, ValueFromPipelineByPropertyName=$true)]
[ValidateNotNullOrEmpty()]
[Alias("LogContent")]
[string]$Message,
[Parameter(Mandatory=$false)]
[ValidateSet("Error","Warn","Info","HighLight")]
[string]$Level="Info"
)
Begin{
$VerbosePreference = 'Continue'
}
Process{
#if (!(Test-Path $LogFile)) {
# Write-Verbose "Creating $LogFile."
# $NewLogFile = New-Item $LogFile -Force -ItemType File
#}
$FormattedDate = Get-Date -Format "yyyy-MM-dd HH:mm:ss"
switch ($Level) {
'Error' {
$LevelText = 'ERROR:'
$MessageColor = [System.ConsoleColor]::Red
}
'Warn' {
$LevelText = 'WARNING:'
$MessageColor = [System.ConsoleColor]::Yellow
}
'Info' {
$LevelText = 'INFO:'
$MessageColor = [System.ConsoleColor]::DarkGreen
}
'HighLight' {
$LevelText = 'HIGHLIGHT:'
$MessageColor = [System.ConsoleColor]::Green
}
}
Write-Host $Message -f $MessageColor
$MessageContent = "$FormattedDate $LevelText $Message"
$MessageContent | Out-File -FilePath $Global:LogFile -Append
#$opts = @{ForegroundColor=$MessageColor; BackgroundColor="black"; object=$MessageContent}
#Write-Log $opts
}
End{
}
}
function GetWebAppUrlFromSiteUrl([string]$SiteUrl){
#Write-Log -Message "GetWebAppUrlFromSiteUrl(), start......SiteUrl=$SiteUrl" -Level HighLight
$site = Get-SPSite -Identity $SiteUrl
$WebAppUrl = $site.WebApplication.GetResponseUri([Microsoft.SharePoint.Administration.SPUrlZone]::Default).AbsoluteUri
if ($WebAppUrl.EndsWith("/","CurrentCultureIgnoreCase")){
$WebAppUrl = $WebAppUrl.Substring(0, $WebAppUrl.Length - 1)
}
$site.Dispose()
#Write-Log -Message "GetWebAppUrlFromSiteUrl(), complete. WebAppUrl=$WebAppUrl" -Level HighLight
return $WebAppUrl
}
function GetSiteNameFromSiteUrl([string]$SiteUrl){
# Write-Log -Message "GetSiteNameFromSiteUrl(), start......SiteUrl=$SiteUrl"
if ($SiteUrl.EndsWith("/","CurrentCultureIgnoreCase")){
$SiteUrl = $SiteUrl.Substring(0, $SiteUrl.Length - 1)
}
$iPos = $SiteUrl.LastIndexOf('/')
$SiteUrl = $SiteUrl.Substring($iPos + 1)
# Write-Log -Message "GetSiteNameFromSiteUrl(), complete. SiteUrl=$SiteUrl"
return $SiteUrl
}
function StartTimerJob([string]$WebAppUrl, [string]$JobName){
Write-Log -Message "StartTimerJob(), start......WebAppUrl=$WebAppUrl, JobName=$JobName"
$job = Get-SPTimerJob -WebApplication $WebAppUrl $JobName
if (!$job){
Write-Log -Message "StartTimerJob(), No valid timer job found, WebAppUrl=$WebAppUrl, JobName=$JobName" -Level Error
return
}
$startTime = $job.LastRunTime
Start-SPTimerJob $job
while (($startTime) -eq $job.LastRunTime)
{
Write-Host -NoNewLine "."
Start-Sleep -Seconds 2
}
Write-Log "Timer Job '$JobName' has completed on $WebAppUrl."
# Write-Log -Message "StartTimerJob(), complete. SiteUrl=$SiteUrl"
return
}
# https://blogs.perficient.com/microsoft/2015/01/set-up-document-id-prefix-in-sharepoint-2013-programmatically/
function ResetDocumentID([string]$startSPSiteUrl){
Write-Log -Message "ResetDocumentID(), startSPSiteUrl=$startSPSiteUrl"
$SiteUrlPrevious = ""
$SiteUrl = ""
$WebAppUrl = ""
$WebAppUrlPrevious = ""
$rootweb = $null
$SiteCount = 0
$i = 0
$sites = @(Get-SPSite -Limit ALL | ?{$_.ServerRelativeUrl -notmatch "Office_Viewing_Service_Cache" `
-and $_.Url.Startswith($startSPSiteUrl, "CurrentCultureIgnoreCase") `
-and $_.Url -notmatch "SearchCenter" `
-and $_.Url -notmatch "IPForm " `
-and $_.Url -notmatch "SPTest" `
-and $_.Url -notmatch "mysite"})
$SiteCount = $sites.count
if ($SiteCount -eq 0){
Write-Log -Message "No valid SPSite found, startSPSiteUrl=$startSPSiteUrl" -Level Error
return
}
else{
Write-Log -Message "sites.count=$SiteCount"
}
$progressBarTitle = "ResetDocumentID(), Scan SPSites, SiteCount=$SiteCount, startSPSiteUrl=$startSPSiteUrl"
foreach ($site in $sites){
$i++
Write-Progress -Activity $progressBarTitle -PercentComplete (($i/$SiteCount)*100) -Status "Working"
$SiteUrl = $site.Url
$WebApplicationUrl =
Write-Log "ResetDocumentID(), SiteUrl=$SiteUrl"
if ($site.ReadOnly){
Write-Log "ResetDocumentID(), Site($SiteUrl) is read-only. Skip." -Level Warn
Continue
}
$WebAppUrl = GetWebAppUrlFromSiteUrl $SiteUrl
if ($WebAppUrl.EndsWith(".local","CurrentCultureIgnoreCase") -eq $false){
Write-Log -Message "ResetDocumentID(), skip web application: WebAppUrl=$WebAppUrl"
continue
}
Try{
$SiteName = GetSiteNameFromSiteUrl $SiteUrl
Write-Log "ResetDocumentID(), DocumentID=$SiteName"
[Microsoft.Office.DocumentManagement.DocumentID]::EnableAssignment($site,$false) #First disable, then enable DocID assignment
[Microsoft.Office.DocumentManagement.DocumentID]::EnableAssignment($site,$true)
$rootweb=$site.rootweb
$rootweb.properties["docid_msft_hier_siteprefix"]= $SiteName # This is the property holding the Document ID Prefix which we use to ensure uniqueness
$rootweb.properties.Update()
$rootweb.Update()
[Microsoft.Office.DocumentManagement.DocumentID]::EnableAssignment($site,$true,$true,$true) # now we can force all Document IDs to be reissued
}
Catch [system.exception]{
$strTmp = [string]::Format("ResetDocumentID(), startSPSiteUrl={0}, SiteUrl={1}, ex.Message={2}", $startSPSiteUrl, $SiteUrl, $Error[0].Exception.Message)
Write-Log $strTmp -Level Error
Write-Log $_.Exception -Level Error
}
Finally{
if ($rootweb){
$rootweb.Dispose()
}
if ($site){
$site.Dispose()
}
}
if ([string]::IsNullOrEmpty($SiteUrlPrevious)){
$SiteUrlPrevious = $SiteUrl
$WebAppUrlPrevious = $WebAppUrl
}
if ($WebAppUrl.Equals($WebAppUrlPrevious, [StringComparison]::InvariantCultureIgnoreCase) -eq $false){
StartTimerJob $WebAppUrl "DocIdEnable"
StartTimerJob $WebAppUrl "DocIdAssignment"
$WebAppUrlPrevious = $WebAppUrl
}
Write-Log -Message "ResetDocumentID(), completed"
}
StartTimerJob $WebAppUrl "DocIdEnable"
StartTimerJob $WebAppUrl "DocIdAssignment"
}
cls
# $_SiteNameSuffix = '2016DEV'
# $_SiteNameSuffix = '2013DEV'
$_SiteNameSuffix = ''
# $_SiteUrl = ""
$_SiteUrl = "http://team$_SiteNameSuffix.SharePointServer.local/sites/SiteCollectionName"
ResetDocumentID $_SiteUrl
Write-Log -Message "Finished! Press enter key to exit."
#Read-Host
Monday, December 12, 2016
Best simple guide about SharePoint search
Found an excellent post about SharePoint Search
It covers all major parts, and can be read through in a few minutes.
Strongly recommend it!
All credit goes to icansharepoint
It covers all major parts, and can be read through in a few minutes.
Strongly recommend it!
All credit goes to icansharepoint
Wednesday, February 17, 2016
How to generate new Visual Studio Solution from existing solution?
Most of posts on Internet suggest to create a new solution and feature in Visual Studio, then copy/attach the files to the new project. (such as this one)
I find another opotion.
After copying the whole Visual Studio solution/project to new folder, there are 4 parts we need to replace.
1. DLL new key
2. Solution ID
3. Feature ID
4. Change the Solution name, Feature name, Assembly name (and webpart / workflow action name if needed).
The first two steps are easy. Open the project in Visual Studio, then do the change straight away.
But the third step is tricky: we cannot just go to "Feature Designer" and replace the GUID in "Feature Id" property. This ID is used in 7 different places and we cannot change them all in Visual Studio.
I did that through the famous freeware "Notepad++", go to "Search", then "Find in Files"
Below is the search result after clicking "Find All" button. We can click "Replace in Files" button to replace all old Feature Id with new GUID.
Step 4 is similar to step 3.
That's it.
Now we can compile and publish the new solution file (.wsp) in Visual Studio, and then deploy it SharePoint.
PS:
To use new solution and feature to replace old solution and feature in farm, don't forget to uninstall the old feature and solution first, if you don't want to change the solution name or feature name.
Below is the PowerShell script.
Get-SPSite -Limit ALL | ForEach-Object {Disable-SPFeature -identity "FeatureName" -URL $_.URL -confirm:$false -ErrorAction SilentlyContinue}
Get-SPFeature | ?{$_.DisplayName -eq "FeatureName"} | Uninstall-SPFeature -confirm:$false -force
Get-SPSolution | ?{$_.DisplayName -like "SolutionName"} | Remove-SPSolution -confirm:$false -force
You can go to SharePoint system folder "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions" on all SharePoint servers, then search for the feature name, to confirm the feature is removed from farm completely.
I find another opotion.
After copying the whole Visual Studio solution/project to new folder, there are 4 parts we need to replace.
1. DLL new key
2. Solution ID
3. Feature ID
4. Change the Solution name, Feature name, Assembly name (and webpart / workflow action name if needed).
The first two steps are easy. Open the project in Visual Studio, then do the change straight away.
But the third step is tricky: we cannot just go to "Feature Designer" and replace the GUID in "Feature Id" property. This ID is used in 7 different places and we cannot change them all in Visual Studio.
I did that through the famous freeware "Notepad++", go to "Search", then "Find in Files"
Below is the search result after clicking "Find All" button. We can click "Replace in Files" button to replace all old Feature Id with new GUID.
Step 4 is similar to step 3.
That's it.
Now we can compile and publish the new solution file (.wsp) in Visual Studio, and then deploy it SharePoint.
PS:
To use new solution and feature to replace old solution and feature in farm, don't forget to uninstall the old feature and solution first, if you don't want to change the solution name or feature name.
Below is the PowerShell script.
Get-SPSite -Limit ALL | ForEach-Object {Disable-SPFeature -identity "FeatureName" -URL $_.URL -confirm:$false -ErrorAction SilentlyContinue}
Get-SPFeature | ?{$_.DisplayName -eq "FeatureName"} | Uninstall-SPFeature -confirm:$false -force
Get-SPSolution | ?{$_.DisplayName -like "SolutionName"} | Remove-SPSolution -confirm:$false -force
You can go to SharePoint system folder "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions" on all SharePoint servers, then search for the feature name, to confirm the feature is removed from farm completely.
Wednesday, July 29, 2015
How to remove Document ID after disabling "Document ID Service" feature?
After disabling "Document ID Service" site collection feature, the field "Document ID" is still in the "Display Form". That's annoying.
However, it's easy to remove/hide it, with the help from the famous freeware "SharePoint Manager".
Go to the library, then expand "Fields", then change the property "Sealed" from True to False, click "Save"; then change the property "ShowInDisplayForm" from True to False, then click "Save" again.
Done.
PS: we cannot do the same change with this field in list content type or site content type.
However, it's easy to remove/hide it, with the help from the famous freeware "SharePoint Manager".
Go to the library, then expand "Fields", then change the property "Sealed" from True to False, click "Save"; then change the property "ShowInDisplayForm" from True to False, then click "Save" again.
Done.
PS: we cannot do the same change with this field in list content type or site content type.
Tuesday, April 21, 2015
Problem: Workflow is not started by the first event
The workflow is not started by the first event ("item created" or "item changed"), after that it works well.
It only happens in one site collection.
Soon I found the error message in ULS: "The requested workflow task content type was not found on the SPWeb"
Google search leads to this post. But re-creating Tasks list didn't resolve the problem in my case. The other posts all recommend to reactivate "OffWFCommon" feature. But it still didn't help.
Then I realized where the problem is.
SharePoint structure is based on "template". From the error message in ULS, it's easy to guess that the site content type "Tasks" is corrupted somewhere. Reactivating "OffWFCommon" feature only fixes the site content type template, not the content type instance in the Tasks list.
So the solution is simple.
1. Reactivate "OffWFCommon" feature
stsadm -o deactivatefeature -filename OffWFCommon\feature.xml -url http://sp.domain.local/sites/site1
stsadm -o activatefeature -filename OffWFCommon\feature.xml -url http://sp.domain.local/sites/site1
Any comments welcome!
[update, 2016-07-21]
PowerShell script:
$siteUrl = "http://sp.domain.local/sites/site"
disable-spfeature -identity "OFFWfCommon" –url $siteUrl
enable-spfeature –identify "OffWfCommon" –url $siteUrl
https://blogs.technet.microsoft.com/sharepoint_scott/2012/10/05/intermittent-workflow-failures-the-workflow-failed-to-start-due-to-an-internal-error/
It only happens in one site collection.
Soon I found the error message in ULS: "The requested workflow task content type was not found on the SPWeb"
Google search leads to this post. But re-creating Tasks list didn't resolve the problem in my case. The other posts all recommend to reactivate "OffWFCommon" feature. But it still didn't help.
Then I realized where the problem is.
SharePoint structure is based on "template". From the error message in ULS, it's easy to guess that the site content type "Tasks" is corrupted somewhere. Reactivating "OffWFCommon" feature only fixes the site content type template, not the content type instance in the Tasks list.
So the solution is simple.
1. Reactivate "OffWFCommon" feature
stsadm -o deactivatefeature -filename OffWFCommon\feature.xml -url http://sp.domain.local/sites/site1
stsadm -o activatefeature -filename OffWFCommon\feature.xml -url http://sp.domain.local/sites/site1
2. Rebuild "Tasks" list
Any comments welcome!
[update, 2016-07-21]
PowerShell script:
$siteUrl = "http://sp.domain.local/sites/site"
disable-spfeature -identity "OFFWfCommon" –url $siteUrl
enable-spfeature –identify "OffWfCommon" –url $siteUrl
Wednesday, April 1, 2015
How to enable "Asset library" template
After creating a new site collection based on "Blank" site template, I noticed that "Asset library" template is not there. Then I enabled "SharePoint Server Standard Site Collection features" and "SharePoint Server Standard Site features", with no luck. Then "Wiki Page Home Page" feature, still no luck.
Internet search brings me to this post, and a few other similar posts, which all says that we need to enable "SharePoint Server Publishing Infrastructure". I am pretty sure that would work. However, "Publishing" feature is really a big chunk of stuff, and we lose "save as template" functionality after enabling it. I don't want to do that.
Thanks for the post All SharePoint Features, we can simply enable "Asset Library" feature, through the PowerShell script below.
# 4bcccd62-dcaf-46dc-a7d4-e38277ef33f4
Enable-SPFeature -identity "AssetLibrary" -URL "http://SiteCollectionUrl.company.local"
Internet search brings me to this post, and a few other similar posts, which all says that we need to enable "SharePoint Server Publishing Infrastructure". I am pretty sure that would work. However, "Publishing" feature is really a big chunk of stuff, and we lose "save as template" functionality after enabling it. I don't want to do that.
Thanks for the post All SharePoint Features, we can simply enable "Asset Library" feature, through the PowerShell script below.
# 4bcccd62-dcaf-46dc-a7d4-e38277ef33f4
Enable-SPFeature -identity "AssetLibrary" -URL "http://SiteCollectionUrl.company.local"
Monday, March 30, 2015
The main causes of failing to enable publishing feature
Last year I submitted a post regrading how to properly disable/re-enable publishing feature. That's not the silver bullet, however.
Recently I got some more trouble shooting tasks. The error message appeared (attached below), when site collection administrators failed to enable publishing feature. After some investigation, I found there were a few possible problems.
1. Some (hidden) OOTB site columns are missing.
2. Some (hidden) OOTB site content types are missing.
3. Some (hidden) content types which are part of publishing feature are assigned to hidden document library, before enabling publishing feature.
4. Some (hidden) document libraries or lists are missing.
These are all caused by disabling publishing feature improperly. I recommend to rebuild the site collection. But, if really necessary, it's still possible to fix the problem manually.
ULS log:
SPContentTypeBindingElement.ElementActivated(). An error occurred binding content type '0x01010007FF3E057FA8AB4AA42FCB67B453FFC100E214EEE741181F4E9F7ACC43278EE811' to list '/sites/ONEBRAND/_catalogs/masterpage' on web 'http://projectsqa.domain.local/sites/ONEBRAND'. Exception 'A duplicate content type "Page Layout" was found.'.
Publishing Resources Feature activation failed. Exception: Microsoft.SharePoint.SPException: Provisioning did not succeed. Details: Failed to create the '_catalogs/masterpage' library. OriginalException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.SharePoint.Publishing.PublishingSite.GetPageLayouts(Boolean excludeObsolete)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.ConfigureMasterPageGallery(SPList cacheProfiles) -
-- End of inner exception stack trace ---
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.ConfigureMasterPageGallery(SPList cacheProfiles)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.b__0()
at Microsoft.Office.Server.Utilities.Security.SecurityUtilities.RunWithAllowUnsafeUpdates(SPWeb web, Action secureCode)
at Microsoft.SharePoint.Publishing.CmsSecurityUtilities.RunWithAllowUnsafeUpdates(SPWeb web, CodeToRun secureCode)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.Provision()
at Microsoft.SharePoint.Publishing.PublishingResourcesFeatureHandler.<>c__DisplayClass3.b__0()
at Microsoft.Office.Server.Utilities.CultureUtility.RunWithCultureScope(CodeToRunWithCultureScope code)
at Microsoft.SharePoint.Publishing.CmsSecurityUtilities.RunWithWebCulture(SPWeb web, CodeToRun webCultureDependentCode)
at Microsoft.SharePoint.Publishing.PublishingResourcesFeatureHandler.FeatureActivated(SPFeatureReceiverProperties receiverProperties).
Feature receiver assembly 'Microsoft.SharePoint.Publishing, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c', class 'Microsoft.SharePoint.Publishing.PublishingResourcesFeatureHandler', method 'FeatureActivated' for feature 'aebc918d-b20f-4a11-a1db-9ed84d79c87e' threw an exception: Microsoft.SharePoint.SPException: Provisioning did not succeed. Details: Failed to create the '_catalogs/masterpage' library. OriginalException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.SharePoint.Publishing.PublishingSite.GetPageLayouts(Boolean excludeObsolete)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.ConfigureMasterPageGallery(SPList cacheProfiles) -
-- End of inner exception stack trace ---
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.ConfigureMasterPageGallery(SPList cacheProfiles)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.b__0()
at Microsoft.Office.Server.Utilities.Security.SecurityUtilities.RunWithAllowUnsafeUpdates(SPWeb web, Action secureCode)
at Microsoft.SharePoint.Publishing.CmsSecurityUtilities.RunWithAllowUnsafeUpdates(SPWeb web, CodeToRun secureCode)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.Provision()
at Microsoft.SharePoint.Publishing.PublishingResourcesFeatureHandler.<>c__DisplayClass3.b__0()
at Microsoft.Office.Server.Utilities.CultureUtility.RunWithCultureScope(CodeToRunWithCultureScope code)
at Microsoft.SharePoint.Publishing.CmsSecurityUtilities.RunWithWebCulture(SPWeb web, CodeToRun webCultureDependentCode)
at Microsoft.SharePoint.Publishing.PublishingResourcesFeatureHandler.FeatureActivated(SPFeatureReceiverProperties receiverProperties)
at Microsoft.SharePoint.SPFeature.DoActivationCallout(Boolean fActivate, Boolean fForce)
Windows events log:
Event log message was: 'Failed to create the '_catalogs/masterpage' library.'. Exception was: 'System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.SharePoint.Publishing.PublishingSite.GetPageLayouts(Boolean excludeObsolete)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.ConfigureMasterPageGallery(SPList cacheProfiles)'
Recently I got some more trouble shooting tasks. The error message appeared (attached below), when site collection administrators failed to enable publishing feature. After some investigation, I found there were a few possible problems.
1. Some (hidden) OOTB site columns are missing.
2. Some (hidden) OOTB site content types are missing.
3. Some (hidden) content types which are part of publishing feature are assigned to hidden document library, before enabling publishing feature.
4. Some (hidden) document libraries or lists are missing.
These are all caused by disabling publishing feature improperly. I recommend to rebuild the site collection. But, if really necessary, it's still possible to fix the problem manually.
ULS log:
SPContentTypeBindingElement.ElementActivated(). An error occurred binding content type '0x01010007FF3E057FA8AB4AA42FCB67B453FFC100E214EEE741181F4E9F7ACC43278EE811' to list '/sites/ONEBRAND/_catalogs/masterpage' on web 'http://projectsqa.domain.local/sites/ONEBRAND'. Exception 'A duplicate content type "Page Layout" was found.'.
Publishing Resources Feature activation failed. Exception: Microsoft.SharePoint.SPException: Provisioning did not succeed. Details: Failed to create the '_catalogs/masterpage' library. OriginalException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.SharePoint.Publishing.PublishingSite.GetPageLayouts(Boolean excludeObsolete)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.ConfigureMasterPageGallery(SPList cacheProfiles) -
-- End of inner exception stack trace ---
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.ConfigureMasterPageGallery(SPList cacheProfiles)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.
at Microsoft.Office.Server.Utilities.Security.SecurityUtilities.RunWithAllowUnsafeUpdates(SPWeb web, Action secureCode)
at Microsoft.SharePoint.Publishing.CmsSecurityUtilities.RunWithAllowUnsafeUpdates(SPWeb web, CodeToRun secureCode)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.Provision()
at Microsoft.SharePoint.Publishing.PublishingResourcesFeatureHandler.<>c__DisplayClass3.
at Microsoft.Office.Server.Utilities.CultureUtility.RunWithCultureScope(CodeToRunWithCultureScope code)
at Microsoft.SharePoint.Publishing.CmsSecurityUtilities.RunWithWebCulture(SPWeb web, CodeToRun webCultureDependentCode)
at Microsoft.SharePoint.Publishing.PublishingResourcesFeatureHandler.FeatureActivated(SPFeatureReceiverProperties receiverProperties).
Feature receiver assembly 'Microsoft.SharePoint.Publishing, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c', class 'Microsoft.SharePoint.Publishing.PublishingResourcesFeatureHandler', method 'FeatureActivated' for feature 'aebc918d-b20f-4a11-a1db-9ed84d79c87e' threw an exception: Microsoft.SharePoint.SPException: Provisioning did not succeed. Details: Failed to create the '_catalogs/masterpage' library. OriginalException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.SharePoint.Publishing.PublishingSite.GetPageLayouts(Boolean excludeObsolete)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.ConfigureMasterPageGallery(SPList cacheProfiles) -
-- End of inner exception stack trace ---
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.ConfigureMasterPageGallery(SPList cacheProfiles)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.
at Microsoft.Office.Server.Utilities.Security.SecurityUtilities.RunWithAllowUnsafeUpdates(SPWeb web, Action secureCode)
at Microsoft.SharePoint.Publishing.CmsSecurityUtilities.RunWithAllowUnsafeUpdates(SPWeb web, CodeToRun secureCode)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.Provision()
at Microsoft.SharePoint.Publishing.PublishingResourcesFeatureHandler.<>c__DisplayClass3.
at Microsoft.Office.Server.Utilities.CultureUtility.RunWithCultureScope(CodeToRunWithCultureScope code)
at Microsoft.SharePoint.Publishing.CmsSecurityUtilities.RunWithWebCulture(SPWeb web, CodeToRun webCultureDependentCode)
at Microsoft.SharePoint.Publishing.PublishingResourcesFeatureHandler.FeatureActivated(SPFeatureReceiverProperties receiverProperties)
at Microsoft.SharePoint.SPFeature.DoActivationCallout(Boolean fActivate, Boolean fForce)
Windows events log:
Event log message was: 'Failed to create the '_catalogs/masterpage' library.'. Exception was: 'System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.SharePoint.Publishing.PublishingSite.GetPageLayouts(Boolean excludeObsolete)
at Microsoft.SharePoint.Publishing.Internal.RootProvisioner.ConfigureMasterPageGallery(SPList cacheProfiles)'
Customize Access Denied page for all Web Application Alternative Urls
We can customize Access Denied page for a web application through PowerShell script below.
$site = get-spsite "http://intranet.company.local"
$webApp = $site.WebApplication
$webApp.UpdateMappedPage(1, "/_layouts/MyAccessDenied.aspx")
$webApp.Update()
However, there is one problem.
Users may access the site without domain name, such as "http://intranet". In that case, the customized Access Denied page is ignored, and users will see the OOTB page.
How to fix this issue? We have two options.
1. Create a separate zone for the web application, specify "intranet" in Host Header.
2. In IIS Site Bindings, add "Intranet" to the site.
Which one is better? It depends on how many WFE servers are there, and how much RAM a WFE server has, and, whether the SharePoint Administrator want to modify IIS settings manually.
$site = get-spsite "http://intranet.company.local"
$webApp = $site.WebApplication
$webApp.UpdateMappedPage(1, "/_layouts/MyAccessDenied.aspx")
$webApp.Update()
However, there is one problem.
Users may access the site without domain name, such as "http://intranet". In that case, the customized Access Denied page is ignored, and users will see the OOTB page.
How to fix this issue? We have two options.
1. Create a separate zone for the web application, specify "intranet" in Host Header.
2. In IIS Site Bindings, add "Intranet" to the site.
Which one is better? It depends on how many WFE servers are there, and how much RAM a WFE server has, and, whether the SharePoint Administrator want to modify IIS settings manually.
Wednesday, February 18, 2015
SharePoint 2010 - User Profile Synchronization - "Unable to process Put message"
I got this error quite a few times before, when trying to configure User Profile Synchronization Connection. Normally it's caused by permission issue, as this post explained.
This time it's different.
After some investigation, I think that resetting Sync DB may fix the problem. But what's wrong with that database?
In windows events log, I found the error message attached at the end of this post. The highlight part says, "Cannot insert duplicate key row in object 'dbo.mms_partition' with unique index 'IX_mms_partitionma_idpartition_name'. The duplicate key value is (f6faef68-af32-4387-ad64-aed58ba98394, DC=pw2,DC=local)"
I cannot believe that I missed it at the very beginning!
Run SQL Query "SELECT * FROM [SP_SyncDB].[dbo].[mms_partition]" on SharePoint database server, it's clear that "f6faef68-af32-4387-ad64-aed58ba98394" is already there in the field "ma_id".
My guess is, for some unknown reason, SharePoint User Profile Service tries to create a new "Connection" instead of utilizing existing one.
So I deleted the existing User Profile Synchronization Connection through Central Admin site, then recreated it.
It works well. :-)
============= Error message in windows events log ==============
The server encountered an unexpected error while performing an operation for a management agent.
"ERR: MMS(4596): sql.cpp(5714): Query (insert into [mms_partition] ([ma_id],[partition_id],[partition_name],[version_number],[ma_custom_data_xml],[is_selected],[filter_xml],[filter_hints_xml],[creation_date],[modification_date],[allowed_operations_flag],[current_export_batch_number],[current_export_sequence_number],[last_successful_export_batch_number]) values ( 'F6FAEF68-AF32-4387-AD64-AED58BA98394','F54CA4AE-2FFA-4517-BF61-7173795CE0B5',N'DC=pw2,DC=local',1,N'DC=pw2,DC=local pw2.local {901bed2e-5007-4849-8904-1b868995a6b6} 1 1 0 1
contact
container
domainDNS
group
inetOrgPerson
user
crossRef
organizationalUnit
CN=Computers,DC=pw2,DC=local
OU=Domain Controllers,DC=pw2,DC=local
CN=ForeignSecurityPrincipals,DC=pw2,DC=local
CN=Managed Service Accounts,DC=pw2,DC=local
OU=Microsoft Exchange Security Groups,DC=pw2,DC=local
CN=Microsoft Exchange System Objects,DC=pw2,DC=local
CN=Program Data,DC=pw2,DC=local
CN=System,DC=pw2,DC=local
CN=Builtin,DC=pw2,DC=local
CN=Infrastructure,DC=pw2,DC=local
CN=LostAndFound,DC=pw2,DC=local
CN=NTDS Quotas,DC=pw2,DC=local
CN=TPM Devices,DC=pw2,DC=local
DC=ForestDnsZones,DC=pw2,DC=local
DC=DomainDnsZones,DC=pw2,DC=local
CN=Configuration,DC=pw2,DC=local
CN=Users,DC=pw2,DC=local
',N'
contact
top
person
organizationalPerson
contact
1
container
top
container
1
domainDNS
top
domain
domainDNS
1
group
top
group
1
inetOrgPerson
top
person
organizationalPerson
user
inetOrgPerson
1
user
top
person
organizationalPerson
user
1
crossRef
top
crossRef
1
organizationalUnit
top
organizationalUnit
1
msExchTransportSettings
top
container
msExchTransportSettings
0
msImaging-PSPs
top
container
msImaging-PSPs
0
msExchProtocolCfgProtocolContainer
top
container
msExchProtocolCfgProtocolContainer
0
msExchMDBContainer
top
container
msExchMDBContainer
0
msExchProtocolCfgHTTPFilters
top
container
msExchProtocolCfgHTTPFilters
0
msExchAddressListServiceContainer
top
container
msExchAddressListServiceContainer
0
msExchInformationStore
top
container
msExchInformationStore
0
msExchOmaDeviceType
top
container
msExchOmaDeviceType
0
msExchContainer
top
container
msExchContainer
0
msExchAvailabilityConfig
top
container
msExchAvailabilityConfig
0
msExchOmaConfigurationContainer
top
container
msExchOmaConfigurationContainer
0
msExchAdvancedSecurityContainer
top
container
msExchAdvancedSecurityContainer
0
msExchPublicFolderTreeContainer
top
container
msExchPublicFolderTreeContainer
0
msExchStorageGroup
top
container
msExchStorageGroup
0
msExchAddressRewriteConfiguration
top
container
msExchAddressRewriteConfiguration
0
msExchOmaContainer
top
container
msExchOmaContainer
0
msExchOmaDataSource
top
container
msExchOmaDataSource
0
msExchOmaDeliveryProvider
top
container
msExchOmaDeliveryProvider
0
msExchChatVirtualNetwork
top
container
msExchChatVirtualNetwork
0
msExchContentConfigContainer
top
container
msExchContentConfigContainer
0
msExchTransportRuleCollection
top
container
msExchTransportRuleCollection
0
rpcContainer
top
container
rpcContainer
0
msExchReplicationConnectorContainer
top
container
msExchReplicationConnectorContainer
0
msExchChatNetwork
top
container
msExchChatNetwork
0
msExchServersContainer
top
container
msExchServersContainer
0
msExchRoutingGroupContainer
top
container
msExchRoutingGroupContainer
0
msExchPoliciesContainer
top
container
msExchPoliciesContainer
0
msExchConnectors
top
container
msExchConnectors
0
msExchMDBAvailabilityGroupContainer
top
container
msExchMDBAvailabilityGroupContainer
0
msExchProtocolCfgSMTPIPAddressContainer
top
container
msExchProtocolCfgSMTPIPAddressContainer
0
msExchMonitorsContainer
top
container
msExchMonitorsContainer
0
msExchIMGlobalSettingsContainer
top
container
msExchIMGlobalSettingsContainer
0
msExchConfigurationContainer
top
container
msExchConfigurationContainer
0
msExchOmaCarrier
top
container
msExchOmaCarrier
0
msExchOmaDeviceCapability
top
container
msExchOmaDeviceCapability
0
msExchProtocolCfgSharedContainer
top
container
msExchProtocolCfgSharedContainer
0
msExchSystemObjectsContainer
top
container
msExchSystemObjectsContainer
0
msExchAdminGroupContainer
top
container
msExchAdminGroupContainer
0
msExchRoutingGroup
top
container
msExchRoutingGroup
0
groupPolicyContainer
top
container
groupPolicyContainer
0
msExchOrganizationContainer
top
container
msExchOrganizationContainer
0
msExchConferenceContainer
top
container
msExchConferenceContainer
0
computer
top
person
organizationalPerson
user
computer
0
msPKI-Key-Recovery-Agent
top
person
organizationalPerson
user
msPKI-Key-Recovery-Agent
0
msExchDepartment
top
organizationalUnit
msExchDepartment
0
','2015-02-17 23:23:17.924','2015-02-17 23:23:17.924',1073741854,1,0,0)) performed with error
ERR: MMS(4596): sql.cpp(5767): The statement has been terminated.
ERR: MMS(4596): sql.cpp(5775): hrError: 0x80040e2f, dwMinor: 3621
ERR: MMS(4596): sql.cpp(5930): SQL error: 01000, native: 3621
ERR: MMS(4596): sql.cpp(5767): Cannot insert duplicate key row in object 'dbo.mms_partition' with unique index 'IX_mms_partitionma_idpartition_name'. The duplicate key value is (f6faef68-af32-4387-ad64-aed58ba98394, DC=pw2,DC=local).
ERR: MMS(4596): sql.cpp(5775): hrError: 0x80040e2f, dwMinor: 2601
ERR: MMS(4596): sql.cpp(5930): SQL error: 23000, native: 2601
BAIL: MMS(4596): sql.cpp(3742): 0x80040e2f
BAIL: MMS(4596): sql.cpp(3639): 0x80040e2f
BAIL: MMS(4596): partition.cpp(2095): 0x80040e2f
BAIL: MMS(4596): mastate.cpp(4605): 0x80040e2f
BAIL: MMS(4596): ma.cpp(1521): 0x80040e2f
Forefront Identity Manager 4.0.2450.49"
This time it's different.
After some investigation, I think that resetting Sync DB may fix the problem. But what's wrong with that database?
In windows events log, I found the error message attached at the end of this post. The highlight part says, "Cannot insert duplicate key row in object 'dbo.mms_partition' with unique index 'IX_mms_partitionma_idpartition_name'. The duplicate key value is (f6faef68-af32-4387-ad64-aed58ba98394, DC=pw2,DC=local)"
I cannot believe that I missed it at the very beginning!
Run SQL Query "SELECT * FROM [SP_SyncDB].[dbo].[mms_partition]" on SharePoint database server, it's clear that "f6faef68-af32-4387-ad64-aed58ba98394" is already there in the field "ma_id".
My guess is, for some unknown reason, SharePoint User Profile Service tries to create a new "Connection" instead of utilizing existing one.
So I deleted the existing User Profile Synchronization Connection through Central Admin site, then recreated it.
It works well. :-)
============= Error message in windows events log ==============
The server encountered an unexpected error while performing an operation for a management agent.
"ERR: MMS(4596): sql.cpp(5714): Query (insert into [mms_partition] ([ma_id],[partition_id],[partition_name],[version_number],[ma_custom_data_xml],[is_selected],[filter_xml],[filter_hints_xml],[creation_date],[modification_date],[allowed_operations_flag],[current_export_batch_number],[current_export_sequence_number],[last_successful_export_batch_number]) values ( 'F6FAEF68-AF32-4387-AD64-AED58BA98394','F54CA4AE-2FFA-4517-BF61-7173795CE0B5',N'DC=pw2,DC=local',1,N'
',N'
','2015-02-17 23:23:17.924','2015-02-17 23:23:17.924',1073741854,1,0,0)) performed with error
ERR: MMS(4596): sql.cpp(5767): The statement has been terminated.
ERR: MMS(4596): sql.cpp(5775): hrError: 0x80040e2f, dwMinor: 3621
ERR: MMS(4596): sql.cpp(5930): SQL error: 01000, native: 3621
ERR: MMS(4596): sql.cpp(5767): Cannot insert duplicate key row in object 'dbo.mms_partition' with unique index 'IX_mms_partitionma_idpartition_name'. The duplicate key value is (f6faef68-af32-4387-ad64-aed58ba98394, DC=pw2,DC=local).
ERR: MMS(4596): sql.cpp(5775): hrError: 0x80040e2f, dwMinor: 2601
ERR: MMS(4596): sql.cpp(5930): SQL error: 23000, native: 2601
BAIL: MMS(4596): sql.cpp(3742): 0x80040e2f
BAIL: MMS(4596): sql.cpp(3639): 0x80040e2f
BAIL: MMS(4596): partition.cpp(2095): 0x80040e2f
BAIL: MMS(4596): mastate.cpp(4605): 0x80040e2f
BAIL: MMS(4596): ma.cpp(1521): 0x80040e2f
Forefront Identity Manager 4.0.2450.49"
Friday, January 9, 2015
ProfileSubtypeProperty, CoreProperty, ProfileTypeProperty and syncConnection PropertyMapping
Some attributes belong to ProfileSubtypeProperty object, some belong to CoreProperty, and some belong to ProfileTypeProperty.
It would be nice to see which one belongs to which one.
Below is the script I built to help.
======== list user profile properties and syncConnection PropertyMapping ========
# https://gallery.technet.microsoft.com/office/SP2010-PowerShell-to-0fda04f7
# http://phadnisblog.com/2012/03/13/how-do-i-add-custom-user-profile-properties-with-powershell/
# http://sharepoint.stackexchange.com/questions/56972/delete-sharepoint-userprofile-property-using-powershell
# http://msdn.microsoft.com/en-us/library/office/ms496130(v=office.14).aspx
# http://blogs.msdn.com/b/chandru/archive/2011/09/17/powershell-script-to-create-a-new-user-profile-property.aspx
# http://sp2007hut.wordpress.com/2012/02/11/creating-sharepoint-2010-upa-properties-via-powershell/
cls
$connectionName="user profile sync connection Name"
function Get-SPServiceContext([Microsoft.SharePoint.Administration.SPServiceApplication] $profileApp)
{
$profileApp = @(Get-SPServiceApplication | ? {$_.TypeName -eq "User Profile Service Application"})[0]
return [Microsoft.SharePoint.SPServiceContext]::GetContext($profileApp.ServiceApplicationProxyGroup, [Microsoft.SharePoint.SPSiteSubscriptionIdentifier]::Default)
}
$serviceContext = Get-SPServiceContext
$userProfileConfigManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileConfigManager($serviceContext)
Write-Host "PropertyMapping, connectionName="$connectionName -ForegroundColor Yellow
$syncConnectionManager = $userProfileConfigManager.ConnectionManager[$connectionName]
$syncConnectionPropertyMapping = $syncConnectionManager.PropertyMapping
foreach ($itemPropertyMapping in $syncConnectionPropertyMapping.GetEnumerator())
{
#if ($itemPropertyMapping.ProfileProperty.Name -NotMatch "SPS")
#{
#$itemPropertyMapping | fl *
$itemPropertyMapping | select-object @{Name="Property Name"; Expression={$_.ProfileProperty.Name}}, DataSourcePropertyName, IsImport, IsExport
break
#}
}
$userProfilePropertyManager = $userProfileConfigManager.ProfilePropertyManager
$defaultSubType = [Microsoft.Office.Server.UserProfiles.ProfileSubtypeManager]::GetDefaultProfileName([Microsoft.Office.Server.UserProfiles.ProfileType]::User)
$coreProperties = $userProfilePropertyManager.GetCoreProperties()
Write-Host "coreProperties.Count="$coreProperties.Count -ForegroundColor Yellow
$userProfileTypeProperties = $userProfilePropertyManager.GetProfileTypeProperties([Microsoft.Office.Server.UserProfiles.ProfileType]::User)
$userProfileSubTypeManager = [Microsoft.Office.Server.UserProfiles.ProfileSubTypeManager]::Get($serviceContext)
$userProfileSubtype = $global:userProfileSubTypeManager.GetProfileSubtype($defaultSubType)
Write-Host "userProfileTypeProperties.Count="$userProfileTypeProperties.Count -ForegroundColor Yellow
Write-Host "userProfileSubtype.PropertiesWithSection.Count="$userProfileSubtype.PropertiesWithSection.Count -ForegroundColor Yellow
Write-Host "userProfileSubtype.Properties.Count="$userProfileSubtype.Properties.Count -ForegroundColor Yellow
Write-Host "Display first coreProperty" -ForegroundColor Green
foreach ($profileCoreProperty in $coreProperties)
{
$profileCoreProperty | fl *
break
}
foreach ($profileSubtypeProperty in $userProfileSubtype.Properties)
{
Write-Host "Display first SubtypeProperty" -ForegroundColor Green
$profileSubtypeProperty | fl *
Write-Host "Display first TypeProperty" -ForegroundColor Green
$profileSubtypeProperty.TypeProperty | fl *
break
}
Write-Host "Display first coreProperty with no TypeProperty" -ForegroundColor Green
foreach ($profileCoreProperty in $coreProperties)
{
$profileSubtypeProperty = $userProfileSubtype.Properties.GetPropertyByName($profileCoreProperty.Name)
if ($profileSubtypeProperty -eq $null)
{
$profileCoreProperty | fl *
break
}
}
It would be nice to see which one belongs to which one.
Below is the script I built to help.
======== list user profile properties and syncConnection PropertyMapping ========
# https://gallery.technet.microsoft.com/office/SP2010-PowerShell-to-0fda04f7
# http://phadnisblog.com/2012/03/13/how-do-i-add-custom-user-profile-properties-with-powershell/
# http://sharepoint.stackexchange.com/questions/56972/delete-sharepoint-userprofile-property-using-powershell
# http://msdn.microsoft.com/en-us/library/office/ms496130(v=office.14).aspx
# http://blogs.msdn.com/b/chandru/archive/2011/09/17/powershell-script-to-create-a-new-user-profile-property.aspx
# http://sp2007hut.wordpress.com/2012/02/11/creating-sharepoint-2010-upa-properties-via-powershell/
$connectionName="user profile sync connection Name"
function Get-SPServiceContext([Microsoft.SharePoint.Administration.SPServiceApplication] $profileApp)
{
$profileApp = @(Get-SPServiceApplication | ? {$_.TypeName -eq "User Profile Service Application"})[0]
return [Microsoft.SharePoint.SPServiceContext]::GetContext($profileApp.ServiceApplicationProxyGroup, [Microsoft.SharePoint.SPSiteSubscriptionIdentifier]::Default)
}
$serviceContext = Get-SPServiceContext
$userProfileConfigManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileConfigManager($serviceContext)
Write-Host "PropertyMapping, connectionName="$connectionName -ForegroundColor Yellow
$syncConnectionManager = $userProfileConfigManager.ConnectionManager[$connectionName]
$syncConnectionPropertyMapping = $syncConnectionManager.PropertyMapping
foreach ($itemPropertyMapping in $syncConnectionPropertyMapping.GetEnumerator())
{
#if ($itemPropertyMapping.ProfileProperty.Name -NotMatch "SPS")
#{
#$itemPropertyMapping | fl *
$itemPropertyMapping | select-object @{Name="Property Name"; Expression={$_.ProfileProperty.Name}}, DataSourcePropertyName, IsImport, IsExport
break
#}
}
$userProfilePropertyManager = $userProfileConfigManager.ProfilePropertyManager
$defaultSubType = [Microsoft.Office.Server.UserProfiles.ProfileSubtypeManager]::GetDefaultProfileName([Microsoft.Office.Server.UserProfiles.ProfileType]::User)
$coreProperties = $userProfilePropertyManager.GetCoreProperties()
Write-Host "coreProperties.Count="$coreProperties.Count -ForegroundColor Yellow
$userProfileTypeProperties = $userProfilePropertyManager.GetProfileTypeProperties([Microsoft.Office.Server.UserProfiles.ProfileType]::User)
$userProfileSubTypeManager = [Microsoft.Office.Server.UserProfiles.ProfileSubTypeManager]::Get($serviceContext)
$userProfileSubtype = $global:userProfileSubTypeManager.GetProfileSubtype($defaultSubType)
Write-Host "userProfileTypeProperties.Count="$userProfileTypeProperties.Count -ForegroundColor Yellow
Write-Host "userProfileSubtype.PropertiesWithSection.Count="$userProfileSubtype.PropertiesWithSection.Count -ForegroundColor Yellow
Write-Host "userProfileSubtype.Properties.Count="$userProfileSubtype.Properties.Count -ForegroundColor Yellow
Write-Host "Display first coreProperty" -ForegroundColor Green
foreach ($profileCoreProperty in $coreProperties)
{
$profileCoreProperty | fl *
break
}
foreach ($profileSubtypeProperty in $userProfileSubtype.Properties)
{
Write-Host "Display first SubtypeProperty" -ForegroundColor Green
$profileSubtypeProperty | fl *
Write-Host "Display first TypeProperty" -ForegroundColor Green
$profileSubtypeProperty.TypeProperty | fl *
break
}
Write-Host "Display first coreProperty with no TypeProperty" -ForegroundColor Green
foreach ($profileCoreProperty in $coreProperties)
{
$profileSubtypeProperty = $userProfileSubtype.Properties.GetPropertyByName($profileCoreProperty.Name)
if ($profileSubtypeProperty -eq $null)
{
$profileCoreProperty | fl *
break
}
}
Tuesday, November 11, 2014
How to dispose SPWeb and SPSite objects in PowerShell
Whenever we get the message below from ULS log, we need to monitor it carefully. If the highlighted number("16") keeps growing and rarely goes down, then it's pretty clear that there is some SPWeb or SPSite objects not been disposed properly.
Potentially excessive number of SPRequest objects (16) currently unreleased on thread 10. Ensure that this object or its parent (such as an SPWeb or SPSite) is being properly disposed. This object is holding on to a separate native heap.This object will not be automatically disposed.
Some objects, such as SPWeb.ParentWeb and SPSite.RootWeb don't need to be disposed manually. But in loop statement such as "foreach($site in $allSites)" or "foreach($web in $allWebs)", we have to call "Dispose()".
Another case is the objects created by "Get-SPSite" or "Get-SPWeb". I have to say it's quite easy (for me) to forget releasing them. Thanks for the post from Dave Wyatt, we get the "Using" feature just like what we have in C#.
Below is how I implemented it, and happy to share it here.
function UsingObject
{
[CmdletBinding()]
param (
[Parameter(Mandatory = $true)]
[AllowEmptyString()]
[AllowEmptyCollection()]
[AllowNull()]
[Object]
$InputObject,
[Parameter(Mandatory = $true)]
[scriptblock]
$ScriptBlock
)
try
{
. $ScriptBlock
}
finally
{
if ($null -ne $InputObject -and $InputObject -is [System.IDisposable])
{
$InputObject.Dispose()
}
}
}
function DisposeSPSite([REF]$site)
{
if ($site.Value -ne $null)
{
$site.Value.Dispose()
}
}
function DisposeSPWeb([REF]$web)
{
if ($web.Value -ne $null)
{
$web.Value.Dispose()
}
}
One more question: Can we only use "Start-SPAssignment" and "Stop-SPAssignment" to release the resources? For small farm, maybe all right. But, it's definitely not recommended. With more and more resources occupied by one PowerShell session, the farm will slow down eventually, and it also generates huge ULS log files.
Potentially excessive number of SPRequest objects (16) currently unreleased on thread 10. Ensure that this object or its parent (such as an SPWeb or SPSite) is being properly disposed. This object is holding on to a separate native heap.This object will not be automatically disposed.
Some objects, such as SPWeb.ParentWeb and SPSite.RootWeb don't need to be disposed manually. But in loop statement such as "foreach($site in $allSites)" or "foreach($web in $allWebs)", we have to call "Dispose()".
Another case is the objects created by "Get-SPSite" or "Get-SPWeb". I have to say it's quite easy (for me) to forget releasing them. Thanks for the post from Dave Wyatt, we get the "Using" feature just like what we have in C#.
Below is how I implemented it, and happy to share it here.
function UsingObject
{
[CmdletBinding()]
param (
[Parameter(Mandatory = $true)]
[AllowEmptyString()]
[AllowEmptyCollection()]
[AllowNull()]
[Object]
$InputObject,
[Parameter(Mandatory = $true)]
[scriptblock]
$ScriptBlock
)
try
{
. $ScriptBlock
}
finally
{
if ($null -ne $InputObject -and $InputObject -is [System.IDisposable])
{
$InputObject.Dispose()
}
}
}
function DisposeSPSite([REF]$site)
{
if ($site.Value -ne $null)
{
$site.Value.Dispose()
}
}
function DisposeSPWeb([REF]$web)
{
if ($web.Value -ne $null)
{
$web.Value.Dispose()
}
}
UsingObject ($site = Get-SPSite -Identity $siteURL) {
$objSPWebApplication = $site.WebApplication
$siteCollections = $objSPWebApplication.Sites
foreach($itemSPSite in $siteCollections)
{
if ($itemSPSite.Url.IndexOf("Office_Viewing_Service_Cache") -ge 0)
{
DisposeSPSite ([REF]$itemSPSite)
continue
}
Blah, blah....
DisposeSPSite ([REF]$itemSPSite)
}
}
We still get the message below in ULS;
An SPRequest object was reclaimed by the garbage collector instead of being explicitly freed. To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it.
It seems that after calling "Dispose()", the SPRequest resource is not released immediately. They are done by .Net garbage collection soon after.
One more question: Can we only use "Start-SPAssignment" and "Stop-SPAssignment" to release the resources? For small farm, maybe all right. But, it's definitely not recommended. With more and more resources occupied by one PowerShell session, the farm will slow down eventually, and it also generates huge ULS log files.
Any comments welcome!
References:
http://msdn.microsoft.com/en-us/library/aa973248(v=office.12).aspx#sharepointobjmodel__findingundisposedobjects
http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.administration.eventseverity(v=office.15).aspx
http://davewyatt.wordpress.com/2014/04/11/using-object-powershell-version-of-cs-using-statement/
http://msdn.microsoft.com/en-us/library/aa973248(v=office.12).aspx#sharepointobjmodel__findingundisposedobjects
http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.administration.eventseverity(v=office.15).aspx
http://davewyatt.wordpress.com/2014/04/11/using-object-powershell-version-of-cs-using-statement/
Wednesday, October 1, 2014
How to stop duplicate entries based on two or more columns in a SharePoint list?
Well, there is no OOTB support of that.
Quick search leads to two solutions: coding (event receiver) or InfoPath rule.
The cost of "coding" is high. We need developer to build it, need someone to manage the source code, and need to upgrade the assembly when upgrading SharePoint. And, the deployment will cause farm outage!
InfoPath solution also has its own problem: it is always with expensive "license" fee.
So, is there simple approach to resolve the problem? Below is how I did it, with a simple declarative workflow.
The workflow doesn't prevent "duplicate entries", but can generate warning message, so users can fix the invalid data after the remind. That's good enough in most of the cases.
Any comments are welcome!
Quick search leads to two solutions: coding (event receiver) or InfoPath rule.
The cost of "coding" is high. We need developer to build it, need someone to manage the source code, and need to upgrade the assembly when upgrading SharePoint. And, the deployment will cause farm outage!
InfoPath solution also has its own problem: it is always with expensive "license" fee.
So, is there simple approach to resolve the problem? Below is how I did it, with a simple declarative workflow.
The workflow doesn't prevent "duplicate entries", but can generate warning message, so users can fix the invalid data after the remind. That's good enough in most of the cases.
- The structure of the test list (CombinedKey = Title & ProjectCode)
- Declarative workflow triggered by "new item" and "edit item" event
- Test result
Friday, August 29, 2014
The substitute of farm solutions
We all know SharePoint 2013 provides "Apps mode". Microsoft encourages all developers to build "Apps" instead of classic solutions. However, there are many jobs Apps can't do. (Andrew Connell has some brilliant thoughts about that.)
In my opinion, there is one tool been seriously underestimated: PowerShell.
PowerShell helps administrators to automate jobs. It helps developers to manage SharePoint environment. Besides that, it can replace all routinely triggered customized workflows and timer jobs!
I didn't build any SharePoint Timer Job for production (but have two open source projects for fun: Simple Reminder and Workflow Timer). Comparing to a scheduled windows task (see the screenshot below), it's not easy. Really.
How about workflow or workflow activity/action? They also need SharePoint developer to build it. I can build them, but unless the business requirement is extremely complex, I prefer to build something even normal administrators can maintain and do simple modification.
In my experience, most of the business requirements are small, simple but urgent. Besides, non-software company don't want to manage the source code of hundreds of visual studio projects!
PowerShell script doesn't include any unnecessary xml or definition file. It simply focuses on business logic, which make it short and easy understand.
One of the complain about PowerShell is about the supporting tools, such as Visual Studio and ISE. There is no full intellisense during editing at the moment(Auguest 2014). Comparing to C#, the debugging is hard.
However, in my opinion, the critical issue is the lack of client side API. Like "Apps", we don't want to run PS scripts on SharePoint server. Is it possible to run the script on an application server with no SharePoint installed? Currently, CSOM and Restful API are supported, but, comparing to server object model, there are too much restriction. Actually we can only do basic read/write (CRUD) operations at client side.
That's far from enough. Any thing we can do through "server object model", we need to be able to do through "client object model".
This sounds like a balance between "security" and "functionality", and Microsoft needs to find a way to meet the ends.
[update, 2014-10-09]
To configure Task Scheduler in Failover Cluster, we can follow this one for Windows Server 2012. Only Windows Server 2012+ support "Clustered Tasks".
In my opinion, there is one tool been seriously underestimated: PowerShell.
PowerShell helps administrators to automate jobs. It helps developers to manage SharePoint environment. Besides that, it can replace all routinely triggered customized workflows and timer jobs!
I didn't build any SharePoint Timer Job for production (but have two open source projects for fun: Simple Reminder and Workflow Timer). Comparing to a scheduled windows task (see the screenshot below), it's not easy. Really.
How about workflow or workflow activity/action? They also need SharePoint developer to build it. I can build them, but unless the business requirement is extremely complex, I prefer to build something even normal administrators can maintain and do simple modification.
In my experience, most of the business requirements are small, simple but urgent. Besides, non-software company don't want to manage the source code of hundreds of visual studio projects!
PowerShell script doesn't include any unnecessary xml or definition file. It simply focuses on business logic, which make it short and easy understand.
One of the complain about PowerShell is about the supporting tools, such as Visual Studio and ISE. There is no full intellisense during editing at the moment(Auguest 2014). Comparing to C#, the debugging is hard.
However, in my opinion, the critical issue is the lack of client side API. Like "Apps", we don't want to run PS scripts on SharePoint server. Is it possible to run the script on an application server with no SharePoint installed? Currently, CSOM and Restful API are supported, but, comparing to server object model, there are too much restriction. Actually we can only do basic read/write (CRUD) operations at client side.
That's far from enough. Any thing we can do through "server object model", we need to be able to do through "client object model".
This sounds like a balance between "security" and "functionality", and Microsoft needs to find a way to meet the ends.
[update, 2014-10-09]
To configure Task Scheduler in Failover Cluster, we can follow this one for Windows Server 2012. Only Windows Server 2012+ support "Clustered Tasks".
Tuesday, July 29, 2014
What is SPListItem/SPFile anyway?
When I started to touch SharePoint years ago, it's natural to treat "List" as "SQL table". They have so many similar features:
Apart from the exciting SharePoint features, such as versioning, soon I noticed two differences.
Definitely NOT!
This is the conclusion I got after seven years of development and administration on SharePoint platform. Believe it or not, I feel that SPListItem/SPFile is actually Message, and SPList/SPContentType is Queue.
Let me show an example here.
If there are millions of items in a SPList, and we need to update the "Title" field of all data based on some rules, how should we do it? We cannot update data in batch, instead, we have to do the update one by one. This is how we process messages, not records.
Once we understand this point, then it's easy to understand why all SPListItems are stored in one SQL table, why the modification is so slow, and how we can utilize SharePoint in better way.
What do you think? Any comments are welcome!
| Features in common | SQL Server | SharePoint |
| Container | Database | Site |
| Operations | Insert,Update,Delete,Query | Insert,Update,Delete,Query |
| Metadata | Columns | Columns |
| Data volume | Billions of records | Millions of records |
| Event trigger | Yes | Yes |
| Query language | SQL | CAML |
Apart from the exciting SharePoint features, such as versioning, soon I noticed two differences.
- All SPListItems are stored in one SQL table;
- Compare to SQL Server, "Insert,Update,Delete" operations of SPListItem are extremely slow;
Definitely NOT!
This is the conclusion I got after seven years of development and administration on SharePoint platform. Believe it or not, I feel that SPListItem/SPFile is actually Message, and SPList/SPContentType is Queue.
Let me show an example here.
If there are millions of items in a SPList, and we need to update the "Title" field of all data based on some rules, how should we do it? We cannot update data in batch, instead, we have to do the update one by one. This is how we process messages, not records.
Once we understand this point, then it's easy to understand why all SPListItems are stored in one SQL table, why the modification is so slow, and how we can utilize SharePoint in better way.
What do you think? Any comments are welcome!
Friday, July 18, 2014
How to start workflow in PowerShell after sp2010 sp2
To start workflow in PowerShell script should be easy. Below is the one I used for long time.
$itemCurrent = $list.GetItemById($itemId)
$wfRunOption = [Microsoft.SharePoint.Workflow.SPWorkflowRunOptions]::Synchronous
$wf = $manager.StartWorkFlow($itemCurrent,$assoc,$data,$wfRunOption)
However, after installing SP2010 SP2, it stopped working with "Failed on Start" workflow status.
I know "system account" cannot trigger workflow. So, it should be easy to fix: we can get the SPSite object under another user's token. Below is the script
$web = Get-SPWeb -Identity $webURL
$user=$web.EnsureUser("domainName\anotherUser")
$token = $user.UserToken;
$impSite= New-Object Microsoft.SharePoint.SPSite($webURL, $token);
$web.Dispose()
$web = $impSite.OpenWeb()
$manager = $web.Site.WorkFlowManager
$list = $web.Lists[$listName]
[update 20140718]
If still got error "Failed on Start", please check ULS log. If the error message is similar to the one below, you need to grant windows local admin rights to "domainName\SomeUser", which is used to run "SharePoint 2010 Management Shell".
Errors in ULS:
Workflow Compile Failed while loading AuthorizedTypes from config: An error occurred creating the configuration section handler for System.Workflow.ComponentModel.WorkflowCompiler/authorizedTypes: Could not find file 'C:\Users\0efang\AppData\Local\Temp\qklxfvr3.dll'. (C:\inetpub\wwwroot\wss\VirtualDirectories\appsdev.unitingcare.local80\web.config line 654)
RunWorkflow: Microsoft.SharePoint.SPException: An error occurred creating the configuration section handler for System.Workflow.ComponentModel.WorkflowCompiler/authorizedTypes: Could not find file 'C:\Users\0efang\AppData\Local\Temp\qklxfvr3.dll'. (C:\inetpub\wwwroot\wss\VirtualDirectories\appsdev.unitingcare.local80\web.config line 654)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.SubCompiler.DoCompile(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.SubCompiler.DoCompile(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.<>c__DisplayClasse.b__c()
at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.DoCompileNewAppDomain(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, SPWeb web, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.CompileBytes(Byte[] xomlBytes, Byte[] rulesBytes, Boolean doTestCompilation, String assemblyName, SPWeb web, Boolean forceNewAppDomain)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.LoadXomlAssembly(SPWorkflowAssociation association, SPWeb web)
at Microsoft.SharePoint.Workflow.SPWinOeHostServices.LoadDeclarativeAssembly(SPWorkflowAssociation association, Boolean fallback)
at Microsoft.SharePoint.Workflow.SPWinOeHostServices.CreateInstance(SPWorkflow workflow)
at Microsoft.SharePoint.Workflow.SPWinOeEngine.RunWorkflow(SPWorkflowHostService host, SPWorkflow workflow, Collection`1 events, TimeSpan timeOut)
at Microsoft.SharePoint.Workflow.SPWorkflowManager.RunWorkflowElev(SPWorkflow workflow, Collection`1 events, SPWorkflowRunOptionsInternal runOptions)
Microsoft.SharePoint.SPException: An error occurred creating the configuration section handler for System.Workflow.ComponentModel.WorkflowCompiler/authorizedTypes: Could not find file 'C:\Users\0efang\AppData\Local\Temp\qklxfvr3.dll'. (C:\inetpub\wwwroot\wss\VirtualDirectories\appsdev.unitingcare.local80\web.config line 654)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.SubCompiler.DoCompile(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.SubCompiler.DoCompile(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.<>c__DisplayClasse.b__c()
at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.DoCompileNewAppDomain(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, SPWeb web, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.CompileBytes(Byte[] xomlBytes, Byte[] rulesBytes, Boolean doTestCompilation, String assemblyName, SPWeb web, Boolean forceNewAppDomain)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.LoadXomlAssembly(SPWorkflowAssociation association, SPWeb web)
at Microsoft.SharePoint.Workflow.SPWinOeHostServices.LoadDeclarativeAssembly(SPWorkflowAssociation association, Boolean fallback)
at Microsoft.SharePoint.Workflow.SPWinOeHostServices.CreateInstance(SPWorkflow workflow)
at Microsoft.SharePoint.Workflow.SPWinOeEngine.RunWorkflow(SPWorkflowHostService host, SPWorkflow workflow, Collection`1 events, TimeSpan timeOut)
at Microsoft.SharePoint.Workflow.SPWorkflowManager.RunWorkflowElev(SPWorkflow workflow, Collection`1 events, SPWorkflowRunOptionsInternal runOptions)
$itemCurrent = $list.GetItemById($itemId)
$wfRunOption = [Microsoft.SharePoint.Workflow.SPWorkflowRunOptions]::Synchronous
$wf = $manager.StartWorkFlow($itemCurrent,$assoc,$data,$wfRunOption)
However, after installing SP2010 SP2, it stopped working with "Failed on Start" workflow status.
I know "system account" cannot trigger workflow. So, it should be easy to fix: we can get the SPSite object under another user's token. Below is the script
$web = Get-SPWeb -Identity $webURL
$user=$web.EnsureUser("domainName\anotherUser")
$token = $user.UserToken;
$impSite= New-Object Microsoft.SharePoint.SPSite($webURL, $token);
$web.Dispose()
$web = $impSite.OpenWeb()
$manager = $web.Site.WorkFlowManager
$list = $web.Lists[$listName]
However, nothing is changed. Still the same error: "Failed on Start".
I did some searching on Internet, which leads to pages like here and here. None of them resolve the problem.
Then I RDP to SharePoint server desktop as another user which has enough rights of database and site collection, and run PowerShell script manually. Still same. This is weird.
As last resort, I RDP to SharePoint server as a farm admin and then run the "SharePoint 2010 Management Shell" as a different user (which has enough rights, such as "domainName\SomeUser"). It worked!
I don't understand it although feel quite happy.
(I would really appreciate it if you can explain that in comments)
[update 20140718]
If still got error "Failed on Start", please check ULS log. If the error message is similar to the one below, you need to grant windows local admin rights to "domainName\SomeUser", which is used to run "SharePoint 2010 Management Shell".
Errors in ULS:
Workflow Compile Failed while loading AuthorizedTypes from config: An error occurred creating the configuration section handler for System.Workflow.ComponentModel.WorkflowCompiler/authorizedTypes: Could not find file 'C:\Users\0efang\AppData\Local\Temp\qklxfvr3.dll'. (C:\inetpub\wwwroot\wss\VirtualDirectories\appsdev.unitingcare.local80\web.config line 654)
RunWorkflow: Microsoft.SharePoint.SPException: An error occurred creating the configuration section handler for System.Workflow.ComponentModel.WorkflowCompiler/authorizedTypes: Could not find file 'C:\Users\0efang\AppData\Local\Temp\qklxfvr3.dll'. (C:\inetpub\wwwroot\wss\VirtualDirectories\appsdev.unitingcare.local80\web.config line 654)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.SubCompiler.DoCompile(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.SubCompiler.DoCompile(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.<>c__DisplayClasse.
at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.DoCompileNewAppDomain(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, SPWeb web, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.CompileBytes(Byte[] xomlBytes, Byte[] rulesBytes, Boolean doTestCompilation, String assemblyName, SPWeb web, Boolean forceNewAppDomain)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.LoadXomlAssembly(SPWorkflowAssociation association, SPWeb web)
at Microsoft.SharePoint.Workflow.SPWinOeHostServices.LoadDeclarativeAssembly(SPWorkflowAssociation association, Boolean fallback)
at Microsoft.SharePoint.Workflow.SPWinOeHostServices.CreateInstance(SPWorkflow workflow)
at Microsoft.SharePoint.Workflow.SPWinOeEngine.RunWorkflow(SPWorkflowHostService host, SPWorkflow workflow, Collection`1 events, TimeSpan timeOut)
at Microsoft.SharePoint.Workflow.SPWorkflowManager.RunWorkflowElev(SPWorkflow workflow, Collection`1 events, SPWorkflowRunOptionsInternal runOptions)
Microsoft.SharePoint.SPException: An error occurred creating the configuration section handler for System.Workflow.ComponentModel.WorkflowCompiler/authorizedTypes: Could not find file 'C:\Users\0efang\AppData\Local\Temp\qklxfvr3.dll'. (C:\inetpub\wwwroot\wss\VirtualDirectories\appsdev.unitingcare.local80\web.config line 654)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.SubCompiler.DoCompile(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.SubCompiler.DoCompile(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.<>c__DisplayClasse.
at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.DoCompileNewAppDomain(WorkflowCompilerParameters parameters, String xomlSource, String assemblyName, SPWeb web, CompilationPacket& packet, DirectoryInfo& tempDir)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.CompileBytes(Byte[] xomlBytes, Byte[] rulesBytes, Boolean doTestCompilation, String assemblyName, SPWeb web, Boolean forceNewAppDomain)
at Microsoft.SharePoint.Workflow.SPNoCodeXomlCompiler.LoadXomlAssembly(SPWorkflowAssociation association, SPWeb web)
at Microsoft.SharePoint.Workflow.SPWinOeHostServices.LoadDeclarativeAssembly(SPWorkflowAssociation association, Boolean fallback)
at Microsoft.SharePoint.Workflow.SPWinOeHostServices.CreateInstance(SPWorkflow workflow)
at Microsoft.SharePoint.Workflow.SPWinOeEngine.RunWorkflow(SPWorkflowHostService host, SPWorkflow workflow, Collection`1 events, TimeSpan timeOut)
at Microsoft.SharePoint.Workflow.SPWorkflowManager.RunWorkflowElev(SPWorkflow workflow, Collection`1 events, SPWorkflowRunOptionsInternal runOptions)
Tuesday, June 10, 2014
Interesting error message caused by SharePoint cumulative update
Not sure the problem starts from which CU.
After installing CU April, 2014, I got the error below from SharePoint log when trying to open personal site.
And so, users could not open their personal sites.
It's new to me. As a quick fix, I granted access right of database SP_EnterpriseSearch to the application pool service account, which fixed the problem.
But, why do we need that?
One day later, when got some spare time, I decided to do some further investigation. However, all work well even if I revoke the access rights from the application pool service account!
So, my guess is, after running "SharePoint 2010 Products Configuration Wizard", we need to wait for a while so SharePoint Timer can run some job to reset some data initialization.
How long is the "a while"? I don't know the exact number, but 24 hours should be enough.
============
06/08/2014 00:25:34.18 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880i High System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 tim... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880i High ...erExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProvid... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880i High ...erInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.S... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880i High ...erver.Data.SqlSession.OpenConnection() ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.Co... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High ...reProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenI... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High ...nternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTex... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High ...tWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.PERSON_ASPX__1056203612.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Bool... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High ...ean& completedSynchronously) at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 ... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High ...flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880j High SqlError: 'Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed.' Source: '.Net SqlClient Data Provider' Number: 4060 State: 1 Class: 11 Procedure: '' LineNumber: 65536 Server: 'DB_SharepointPRD\SHAREPOINT' ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880j High SqlError: 'Login failed for user 'DomainName\_SPAppPool'.' Source: '.Net SqlClient Data Provider' Number: 18456 State: 1 Class: 14 Procedure: '' LineNumber: 65536 Server: 'DB_SharepointPRD\SHAREPOINT' ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database tzku High ConnectionString: 'Data Source=sp2010db;Initial Catalog=SP_EnterpriseSearch;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.20 w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pm5 High Url Path: "/person.aspx" ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.20 w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pm6 High ********** SQL exception happens - Start dump ********** ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.20 w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pm7 High SqlException Info, Source: .Net SqlClient Data Provider Number: 4060 State: 1 Class: 11 Server: DB_SharepointPRD\SHAREPOINT Message: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. Procedure: Line: 65536 ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.20 w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pm8 High ********** SQL exception happens - End dump ********** ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21 w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception Unhandled exception caught during execution of Microsoft.SharePoint.Portal.PageBase::ErrorHandler(). Exception information: Exception information: System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) a... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...t System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boo... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...lean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnecti... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...on(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChil... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...drenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInte... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...rnal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at Syst... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...em.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.Sq... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...lInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConne... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...ction owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ... retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase ob... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...jManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ....RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Bo... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...olean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Source: .Net SqlClient Data Provider Server: DB_SharepointPRD\SHAREPOINT LineNumber: 65536 ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Unified Logging Service c91s Monitorable Watson bucket parameters: SharePoint Server 2010, ULSException14, 06d8f9f3 "sharepoint portal server", 0e001b67 "14.0.7015.0", ea364808 "system.data", 0200c627 "2.0.50727.0", 4ca2ba0b "wed sep 29 14:01:15 2010", 00002745 "00002745", 00000011 "00000011", 54cb9616 "sqlexception:4060:1", 37706d61 "7pma" ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21 w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 time... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ...rExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProvide... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ...rInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Se... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ...rver.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at ... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ...Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) a... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ...t System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) ... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ... at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:42.63 w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Monitoring b4ly High Leaving Monitored Scope (PostResolveRequestCacheHandler). Execution Time=7.6224771584098 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Server Database tzku High ConnectionString: 'Data Source=sp2010db;Initial Catalog=SP_EnterpriseSearch;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pm5 High Url Path: "/person.aspx" 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pm6 High ********** SQL exception happens - Start dump ********** 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pm7 High SqlException Info, Source: .Net SqlClient Data Provider Number: 4060 State: 1 Class: 11 Server: DB_SharepointPRD\SHAREPOINT Message: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. Procedure: Line: 65536 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pm8 High ********** SQL exception happens - End dump ********** 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception Unhandled exception caught during execution of Microsoft.SharePoint.Portal.PageBase::ErrorHandler(). Exception information: Exception information: System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) a... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...t System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boo... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...lean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnecti... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...on(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChil... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...drenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInte... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...rnal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at Syst... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...em.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.Sq... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...lInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConne... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...ction owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ... retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase ob... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...jManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ....RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Bo... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...olean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Source: .Net SqlClient Data Provider Server: DB_SharepointPRD\SHAREPOINT LineNumber: 65536 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Server Unified Logging Service c91s Monitorable Watson bucket parameters: SharePoint Server 2010, ULSException14, 06d8f9f3 "sharepoint portal server", 0e001b67 "14.0.7015.0", ea364808 "system.data", 0200c627 "2.0.50727.0", 4ca2ba0b "wed sep 29 14:01:15 2010", 00002745 "00002745", 00000011 "00000011", 54cb9616 "sqlexception:4060:1", 37706d61 "7pma" 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 time... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ...rExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProvide... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ...rInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Se... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ...rver.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at ... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ...Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) a... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ...t System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) ... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ... at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:43.96 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:http://mysite.DomainName.local:80/person.aspx) 8ce4bc37-3df1-4ed3-b559-e2f7133254ef
06/08/2014 00:25:43.98 w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:http://mysite.DomainName.local:80/person.aspx) fec51a94-96dd-4e16-9142-8c68a87de278
06/08/2014 00:25:43.98 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:http://mysite.DomainName.local:80/person.aspx) 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:43.98 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:43.98 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Monitoring b4ly High Leaving Monitored Scope (PostResolveRequestCacheHandler). Execution Time=7.79735972029965 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Server Database tzku High ConnectionString: 'Data Source=sp2010db;Initial Catalog=SP_EnterpriseSearch;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pm5 High Url Path: "/person.aspx" 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pm6 High ********** SQL exception happens - Start dump ********** 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pm7 High SqlException Info, Source: .Net SqlClient Data Provider Number: 4060 State: 1 Class: 11 Server: DB_SharepointPRD\SHAREPOINT Message: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. Procedure: Line: 65536 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pm8 High ********** SQL exception happens - End dump ********** 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception Unhandled exception caught during execution of Microsoft.SharePoint.Portal.PageBase::ErrorHandler(). Exception information: Exception information: System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String pr... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...opertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection chi... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...ldren) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Po... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...rtal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.S... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...qlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContai... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...nerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPa... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...rtPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Source: .Net SqlClient Data Provider Server: DB_SharepointPRD\SHAREPOINT LineNumber: 65536 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Server Unified Logging Service c91s Monitorable Watson bucket parameters: SharePoint Server 2010, ULSException14, 06d8f9f3 "sharepoint portal server", 0e001b67 "14.0.7015.0", ea364808 "system.data", 0200c627 "2.0.50727.0", 4ca2ba0b "wed sep 29 14:01:15 2010", 000020f4 "000020f4", 0000012a "0000012a", 54cb9616 "sqlexception:4060:1", 37706d61 "7pma" 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Runtime tkau Unexpected System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Da... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Runtime tkau Unexpected ...ta.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.Profil... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Runtime tkau Unexpected ...ePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWr... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Runtime tkau Unexpected ...iter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter ... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Runtime tkau Unexpected ...writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
After installing CU April, 2014, I got the error below from SharePoint log when trying to open personal site.
And so, users could not open their personal sites.
It's new to me. As a quick fix, I granted access right of database SP_EnterpriseSearch to the application pool service account, which fixed the problem.
But, why do we need that?
One day later, when got some spare time, I decided to do some further investigation. However, all work well even if I revoke the access rights from the application pool service account!
So, my guess is, after running "SharePoint 2010 Products Configuration Wizard", we need to wait for a while so SharePoint Timer can run some job to reset some data initialization.
How long is the "a while"? I don't know the exact number, but 24 hours should be enough.
============
06/08/2014 00:25:34.18 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880i High System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 tim... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880i High ...erExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProvid... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880i High ...erInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.S... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880i High ...erver.Data.SqlSession.OpenConnection() ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.Co... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High ...reProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenI... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High ...nternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTex... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High ...tWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.PERSON_ASPX__1056203612.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Bool... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High ...ean& completedSynchronously) at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 ... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18* w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880k High ...flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880j High SqlError: 'Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed.' Source: '.Net SqlClient Data Provider' Number: 4060 State: 1 Class: 11 Procedure: '' LineNumber: 65536 Server: 'DB_SharepointPRD\SHAREPOINT' ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database 880j High SqlError: 'Login failed for user 'DomainName\_SPAppPool'.' Source: '.Net SqlClient Data Provider' Number: 18456 State: 1 Class: 14 Procedure: '' LineNumber: 65536 Server: 'DB_SharepointPRD\SHAREPOINT' ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.18 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Database tzku High ConnectionString: 'Data Source=sp2010db;Initial Catalog=SP_EnterpriseSearch;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.20 w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pm5 High Url Path: "/person.aspx" ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.20 w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pm6 High ********** SQL exception happens - Start dump ********** ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.20 w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pm7 High SqlException Info, Source: .Net SqlClient Data Provider Number: 4060 State: 1 Class: 11 Server: DB_SharepointPRD\SHAREPOINT Message: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. Procedure: Line: 65536 ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.20 w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pm8 High ********** SQL exception happens - End dump ********** ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21 w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception Unhandled exception caught during execution of Microsoft.SharePoint.Portal.PageBase::ErrorHandler(). Exception information: Exception information: System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) a... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...t System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boo... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...lean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnecti... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...on(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChil... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...drenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInte... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...rnal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at Syst... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...em.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.Sq... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...lInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConne... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...ction owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ... retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase ob... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...jManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ....RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Bo... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Portal Server Runtime 7pma Exception ...olean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Source: .Net SqlClient Data Provider Server: DB_SharepointPRD\SHAREPOINT LineNumber: 65536 ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21 w3wp.exe (0x0AF0) 0x1F98 SharePoint Server Unified Logging Service c91s Monitorable Watson bucket parameters: SharePoint Server 2010, ULSException14, 06d8f9f3 "sharepoint portal server", 0e001b67 "14.0.7015.0", ea364808 "system.data", 0200c627 "2.0.50727.0", 4ca2ba0b "wed sep 29 14:01:15 2010", 00002745 "00002745", 00000011 "00000011", 54cb9616 "sqlexception:4060:1", 37706d61 "7pma" ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21 w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 time... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ...rExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProvide... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ...rInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Se... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ...rver.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at ... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ...Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) a... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ...t System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) ... ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:34.21* w3wp.exe (0x0AF0) 0x1F98 SharePoint Foundation Runtime tkau Unexpected ... at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) ccbafe59-38a6-443a-b4a9-4ea83f7576a1
06/08/2014 00:25:42.63 w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Monitoring b4ly High Leaving Monitored Scope (PostResolveRequestCacheHandler). Execution Time=7.6224771584098 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Server Database tzku High ConnectionString: 'Data Source=sp2010db;Initial Catalog=SP_EnterpriseSearch;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pm5 High Url Path: "/person.aspx" 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pm6 High ********** SQL exception happens - Start dump ********** 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pm7 High SqlException Info, Source: .Net SqlClient Data Provider Number: 4060 State: 1 Class: 11 Server: DB_SharepointPRD\SHAREPOINT Message: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. Procedure: Line: 65536 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pm8 High ********** SQL exception happens - End dump ********** 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception Unhandled exception caught during execution of Microsoft.SharePoint.Portal.PageBase::ErrorHandler(). Exception information: Exception information: System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) a... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...t System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boo... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...lean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnecti... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...on(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChil... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...drenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInte... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...rnal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at Syst... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...em.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.Sq... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...lInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConne... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...ction owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ... retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase ob... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...jManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ....RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Bo... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Portal Server Runtime 7pma Exception ...olean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Source: .Net SqlClient Data Provider Server: DB_SharepointPRD\SHAREPOINT LineNumber: 65536 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Server Unified Logging Service c91s Monitorable Watson bucket parameters: SharePoint Server 2010, ULSException14, 06d8f9f3 "sharepoint portal server", 0e001b67 "14.0.7015.0", ea364808 "system.data", 0200c627 "2.0.50727.0", 4ca2ba0b "wed sep 29 14:01:15 2010", 00002745 "00002745", 00000011 "00000011", 54cb9616 "sqlexception:4060:1", 37706d61 "7pma" 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67 w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.SqlClient.SqlInternalConnection.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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 time... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ...rExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProvide... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ...rInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Se... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ...rver.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at ... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ...Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) a... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ...t System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) ... 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:42.67* w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Runtime tkau Unexpected ... at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 8aeb36d2-4bc2-4b3c-9454-75f62f5ce4ab
06/08/2014 00:25:43.96 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:http://mysite.DomainName.local:80/person.aspx) 8ce4bc37-3df1-4ed3-b559-e2f7133254ef
06/08/2014 00:25:43.98 w3wp.exe (0x0AF0) 0x193C SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:http://mysite.DomainName.local:80/person.aspx) fec51a94-96dd-4e16-9142-8c68a87de278
06/08/2014 00:25:43.98 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:http://mysite.DomainName.local:80/person.aspx) 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:43.98 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:43.98 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Monitoring b4ly High Leaving Monitored Scope (PostResolveRequestCacheHandler). Execution Time=7.79735972029965 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Server Database tzku High ConnectionString: 'Data Source=sp2010db;Initial Catalog=SP_EnterpriseSearch;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pm5 High Url Path: "/person.aspx" 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pm6 High ********** SQL exception happens - Start dump ********** 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pm7 High SqlException Info, Source: .Net SqlClient Data Provider Number: 4060 State: 1 Class: 11 Server: DB_SharepointPRD\SHAREPOINT Message: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. Procedure: Line: 65536 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pm8 High ********** SQL exception happens - End dump ********** 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception Unhandled exception caught during execution of Microsoft.SharePoint.Portal.PageBase::ErrorHandler(). Exception information: Exception information: System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String pr... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...opertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection chi... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...ldren) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Po... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...rtal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.S... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...qlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContai... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...nerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPa... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Portal Server Runtime 7pma Exception ...rtPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Source: .Net SqlClient Data Provider Server: DB_SharepointPRD\SHAREPOINT LineNumber: 65536 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Server Unified Logging Service c91s Monitorable Watson bucket parameters: SharePoint Server 2010, ULSException14, 06d8f9f3 "sharepoint portal server", 0e001b67 "14.0.7015.0", ea364808 "system.data", 0200c627 "2.0.50727.0", 4ca2ba0b "wed sep 29 14:01:15 2010", 000020f4 "000020f4", 0000012a "0000012a", 54cb9616 "sqlexception:4060:1", 37706d61 "7pma" 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01 w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Runtime tkau Unexpected System.Data.SqlClient.SqlException: Cannot open database "SP_EnterpriseSearch" requested by the login. The login failed. Login failed for user 'DomainName\_SPAppPool'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Office.Server.Data.SqlSession.OpenConnection() at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.Office.Server.Da... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Runtime tkau Unexpected ...ta.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.Office.Server.Search.Administration.SchemaDatabase.GetSchemaHighLevelInfo() at Microsoft.Office.Server.Search.Administration.Schema.get_LastChangeTime() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.SynchronizeManagedPropertyMappings(Guid partitionID, SearchServiceApplicationProxy searchAppProxy) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.GetManagedPropertyMapping(Guid partitionID, String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.GetManagedPropertyMapping(String propertyName) at Microsoft.Office.Server.UserProfiles.CoreProperty.get_ManagedPropertyName() at Microsoft.SharePoint.Portal.WebControls.Profil... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Runtime tkau Unexpected ...ePropertyLoader.ApplyFormattingEx(ProfileManagerBase objManager, Dictionary`2 highlightedProperties, Property prop, Object[] propValue, Boolean ignoreFormat, Boolean allowLinkToSearch) at Microsoft.SharePoint.Portal.WebControls.ProfileDetailsViewer.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWr... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Runtime tkau Unexpected ...iter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.WebPartPage.Render(HtmlTextWriter writer) at Microsoft.SharePoint.Portal.WebControls.PersonalWebPartPage.Render(HtmlTextWriter ... 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
06/08/2014 00:25:44.01* w3wp.exe (0x0AF0) 0x0EA4 SharePoint Foundation Runtime tkau Unexpected ...writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 6a7dd15e-7a33-4e05-8cb2-0c602edac0ec
Subscribe to:
Comments (Atom)