SharePoint Social Rating Updates moreoften than once per hour

These two TimerJobs are responsible for Social Rating Updates: (http://technet.microsoft.com/en-us/library/cc678870.aspx) User Profile service application – social data maintenance Aggregates social tags and ratings and cleans the social data change log. User Profile service application proxy – social rating synchronization Synchronizes rating values between the social database and content database. Per default these Jobs are running…


Calculate and Set Distributed Cache Size

#calculation from: http://technet.microsoft.com/en-us/library/jj219613.aspx $membanks =get-wmiobject Win32_PhysicalMemory $sum = 0 $i=1 foreach ($membank in $membanks) {  write-host “Capacity Memory $i = ” ($membank.capacity/1024/1024)  $sum = ($membank.capacity/1024/1024) + $sum  $i=$i+1 }   write-host “Sum of Memory = ” $sum   $cachesize = ($sum – 2048)/2 if ($cachesize>16384)  {   $cachesize=16384 #not more than 16GB  }   write-host “Distributed…


The site is not valid. The ‘Pages’ document library is missing.

ULS Log tells me that: The site is not valid. The ‘Pages’ document library is missing. ……   Solution to this problem was really simple. I’ve found a blogentry on blogs.technet.com, which tells me to update the “PAGES ID”, and it worked well.     $web = get-spweb “http://site-collection/path-to-affected-site” $correctId = $web.Lists[“Pages”].ID $web.AllProperties[“__PagesListId”] = $correctId.ToString()…


UserProfileApplication.SynchronizeMIIS: Failed to configure ILM, will attempt during next rerun. Exception: System.Data.SqlClient.SqlException

RUN AS FARMADMIN!!!!!   $sync_db = “PROD_SA_UPS_Sync” $ups_service_app_name = “User Profile Service”       net stop sptimerv4 $syncdb=Get-SPDatabase | where {$_.Name -eq $sync_db} $syncdb.Unprovision() $syncdb.Status=’Offline’ $ups = Get-SPServiceApplication  | where {$_.Displayname -eq $ups_service_app_name } $ups.ResetSynchronizationMachine() $ups.ResetSynchronizationDatabase() $syncdb.Provision() net start sptimerv4   Start the UserProfileSyncService again


PowerPoint: Link within Email -> Check out do not work properly

This KB describes the problem exactly and brings up a solution: http://support.microsoft.com/kb/2661910   But in a few sentences. There are two ways to solve that problem: add a RegKey to all ClientsWindows Registry Editor Version 5.00[HKEY_CLASSES_ROOT\MIME\Database\Content Type\application/vnd.ms-powerpoint.presentation.12]”Extension”=”.pptx” Set the Browser File Handling setting within WebApplication settings to permissive instead of strict. Here’s a little more…


HTTP 400 – Bad Request (Request Header too long) — error in Internet Information Services (IIS)

http://support.microsoft.com/kb/2020943   MaxTokenSize: http://support.microsoft.com/kb/327825   By default, the MaxFieldLength registry entry is not present. This registry entry specifies the maximum size limit of each HTTP request header. The MaxRequestBytes registry entry specifies the upper limit for the total size of the Request line and the headers. Typically, this registry entry is configured together with the…


WebDav: Move Files between WebDav Folders

http://support.microsoft.com/kb/825522/en-us   It’s most of all only possible to “move” data between WebDav Folder per Copy/Paste. A REAL move is mostly not possible (just in special constellations)


Upgrade all Content DBs (after e.g. CU)

PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures Get-SPDatabase |?{$_.NeedsUpgrade –eq $true}|Select Name Get-SPContentDatabase |?{$_.NeedsUpgrade –eq $true}| Upgrade-SPContentDatabase


PeoplePicker -> Multiple Domains

$domain_trust = “mycompany.local”$pp_user_in_trusted_domain = “pp_username”$pp_pass_in_trusted_domain = “pp_password”$pp_password = “peoplepickerpassword”    $computer = Get-WmiObject -Class Win32_ComputerSystem$domain_local = $computer.domain stsadm.exe -o setapppassword -password $pp_passwordstsadm -o setproperty -pn “peoplepicker-onlysearchwithinsitecollection” -propertyvalue No$all_webapps = Get-SPWebApplication -IncludeCentralAdministration foreach ($webapp in $all_webapps){ stsadm -o setproperty -pn “peoplepicker-onlysearchwithinsitecollection” -propertyvalue No -url $webapp.url stsadm.exe -o setproperty -url $webapp.url -pn “peoplepicker-searchadforests” -pv “domain:$domain_local;domain:$domain_trust,$pp_user_in_trusted_domain@$domain_trust,$pp_pass_in_trusted_domain”}


Health Analyzer: Missing server side dependencies

[MissingWebPart] WebPart class [baf5274e-a800-8dc3-96d0-0003d9405663] is referenced [25] times in the database [SharePoint_AdminContent_bab358d6-0248-4b19-a354-c040dd311d81], but is not installed on the current farm. Please install any feature/solution which contains this web part. One or more web parts are referenced in the database [SharePoint_AdminContent_bab358d6-0248-4b19-a354-c040dd311d81], but are not installed on the current farm. Please install any feature or solution which…


Health Analyzer: InfoPath Forms Service Cannot be filled out….

$application_name = “Shared State Service Application”$application_db = “Shared_StateService_DB”  New-SPStateServiceApplication -Name $application_nameNew-SPStateServiceDatabase -Name $application_db -ServiceApplication $application_nameNew-SPStateServiceApplicationProxy -Name $application_name -ServiceApplication $application_name  –DefaultProxyGroup  


WarmUp Script

Add-PsSnapin Microsoft.SharePoint.PowerShell -erroraction silentlycontinue     foreach ($webApp in get-SPWebApplication)      {              foreach ($site in $webApp.Sites)          {              foreach ($web in get-SPWeb -site $site)              {                  $request = [System.Net.WebRequest]::Create($web.URL)                  $request.Credentials = [System.Net.CredentialCache]::DefaultNetworkCredentials                  $request.proxy = [System.Net.WebRequest]::DefaultWebProxy                  $request.ContentType = “application/x-www-form-urlencoded”                  $request.Method = “GET”          try{                      $request.GetResponse().StatusCode              WRITE-HOST $request.GetResponse().StatusCode                 …


Change Site Collection Administrator

$webappurl = “http://portal” $account1= “domainname\username” $account2= “domainname\username”   $webapp = Get-SPWebApplication $webappurl $allsites = $webapp | get-spsite -limit all     $allsites | foreach-object { Set-SPSite -owneralias $account1 -identity $_.url} $allsites | foreach-object { Set-SPSite -secondaryowneralias $account2 -identity $_.url}


List all Databases from your SQL Server via PowerShell

I’ve created this script, because some guys wanted to know which DBs are available. It can be used to e.g. mount some unmounted contentdatabases. ———– function ListAllSQLDBs {param ( $DatabaseServer) if ($DatabaseServer -eq $null)     $DatabaseName=   “master”     $QueryString = “EXEC sp_databases”     $SQLDBs = New-Object system.Data.DataTable     $col1 = New-Object system.Data.DataColumn DBName     $SQLDBs.columns.add($col1)    …


Add listitems using PowerShell

$weburl = “http://mysharepoint”$listname = “TestList”$a = “Text1″$b = “Text2″$c = “Text3” Add-PsSnapin Microsoft.SharePoint.PowerShell -erroraction silentlycontinue  $web = Get-SPWeb -Identity $webUrl$list = $web.Lists[$listname]$newItem = $list.items.add()$newitem[“Title”] = $a$newitem[“Custom_Column1”] = $b$newitem[“Custom_Column2”] = $c$newitem.update()


Clear SharePoint Config Cache with PowerShell

Add-PSSnapin -Name Microsoft.SharePoint.PowerShell –erroraction SilentlyContinue write-host “CLEAR CONFIG CACHE ON FARM” -fore green $servers = get-spserver | ?{$_.role -eq “Application”} foreach ($server in $servers) { $servername = $server.Address write-host “Stop Timer Service on server $servername” -fore yellow (Get-WmiObject Win32_Service -filter “name=’SPTimerV4′” -ComputerName $servername).stopservice() | Out-Null } foreach ($server in $servers) { $servername = $server.Address $folders…