SharePoint Diary

Nintex Workflow Timeout Issue - Solutions

June 25, 2014 Nintex, SharePoint, SharePoint 2007, SharePoint 2010

Recently got these timeout related errors in Nintex workflow 2007 with MOSS 2007 environment: "Failed to report workflow progress. Failed to open a connection to a Nintex Workflow content database" "Failed to Start Workflow. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" Error: Timeout expired. The timeout period elapsed prior to completion of the server is not responding Here is some error screenshots: and the another one: Meanwhile, In Event Logs, Found these errors: Nintex Workflow; Build: 11201 (http://sharepoint.crescent.com/finance/approvals/default.aspx) System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateOb

Nintex Workflow Timeout Issue - Solutions

Reviewed by Salaudeen Rajack on June 25, 2014 Rating: 5

Open with Explorer Error: You might not have permission to use this network resource. Contact the administrator of this server to find out if you have access permissions. The file cannot be accessed by the system.

June 24, 2014 SharePoint, SharePoint 2013, Troubleshooting

Problem: In a SSL enabled SharePoint 2013 sites, "Open with Explorer" functionality didn't work! additionally, editing documents online did not work. It just opens the file in Temporary internet files folder and updates ONLY the local file but not the one in SharePoint. Open with Explorer resulted with an error message: \\ SharePointSiteURL@SSL\DavWWWRoot is not accessible. You might not have permission to use this network resource. Contact the administrator of this server to find out if you have access permissions. The file cannot be accessed by the system. Troubleshooting: Tried various solutions including hot-fixes, registry fixes, etc. Analyzed and concluded this problem is happening only on certain machines. Its not related to user permission on the client machine or on the SharePoint sites. Tried KBs: https://support.microsoft.com/en-us/kb/912152 , https://support.microsoft.com/en-us/kb/2629108 , with no luck Tried adding site to Trusted sites z

Open with Explorer Error: You might not have permission to use this network resource. Contact the administrator of this server to find out if you have access permissions. The file cannot be accessed by the system.

Reviewed by Salaudeen Rajack on June 24, 2014 Rating: 5

Remove Theme in SharePoint 2013 using PowerShell

June 23, 2014 Branding, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013

Requirement: To enforce consistency, We wanted to reset custom themes applied on SharePoint sites by end users in our SharePoint environment. Solution: Remove theme programmatically using PowerShell! Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Variable $WebAppURL = "http://intranet.crescent.com" Get-SPWebApplication $WebAppURL | Get-SPSite -Limit ALL | Get-SPWeb | ForEach-Object { #remove theme sharepoint 2013 $Theme = [Microsoft.SharePoint.Utilities.ThmxTheme]::RemoveThemeFromWeb($Web,$false) $Web.Update() } Write-host "Themes are removed from all sites!" This removes and reset to default SharePoint theme. Same script works for SharePoint 2010 also to remove theme.

Remove Theme in SharePoint 2013 using PowerShell

Reviewed by Salaudeen Rajack on June 23, 2014 Rating: 5

Export SharePoint List Item Version History to Excel using PowerShell

June 23, 2014 CSV, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, Version History

I wrote a PowerShell script and C# object model codes to generate SharePoint version history report in SharePoint document version history report , related to that, got a new requirement to export version history to excel. This version history report helps to compare what data is changed, who changed the list data, etc over time. just replace the values of WebURL, ListName variables with your Site/List values and run the script to export version history SharePoint 2013. PowerShell script to Export SharePoint List version history to excel: # ******* Variables Section ****************** #Define these variables $WebURL="http://sharepoint.crescent.com/sites/Sales/" $ListName ="Invoice" $ReportFile = "D:\Invoice_VersionHistory.csv" # ********************************************* #delete file if exists If (Test-Path $ReportFile) { Remove-Item $ReportFile } #Get the Web and List $Web = Get-SPWeb $WebURL $List = $web.Lists.TryGetList($ListName) #C

Export SharePoint List Item Version History to Excel using PowerShell

Reviewed by Salaudeen Rajack on June 23, 2014 Rating: 5

How to Disable Mobile Views in SharePoint 2013?

June 22, 2014 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

SharePoint 2013's new mobile features are definitely improved a lot from its previous versions. Now it provides support for a variety of mobile devices, Geo-location, Office Web Apps integration, Device Channels, etc. However there are certain shortfalls in SharePoint 2013 mobile view such as it doesn't provide responsive web sites, lack of menus and navigation, features like people picker, upload files doesn't work, calendar views are too difficult navigate, etc. SharePoint 2013 mobile example SharePoint 2013 disable mobile redirect In my case, we wanted to take control over mobile web sites and disable mobile view for our public SharePoint web sites, as it loads default mobile view with most of the features disabled. Here are the two methods that helped me to turn off mobile view in SharePoint 2013. Deactivate Mobile Browser View feature Disable Mobile redirect behavior in SharePoint 2013 Method 1: Deactivate SharePoint Mobile feature In Sha

How to Disable Mobile Views in SharePoint 2013?

Reviewed by Salaudeen Rajack on June 22, 2014 Rating: 5

Fix "The form submission cannot be processed because it exceeded the maximum length allowed by the web administrator." Error in SharePoint 2013

June 22, 2014 Central Administration, Known Issues, SharePoint, SharePoint 2013, SharePoint 2016

Getting "The form submission cannot be processed because it exceeded the maximum length allowed by the web administrator. Please resubmit the form with less data" error in SharePoint 2013 when trying to upload a file? Root cause: By default, SharePoint 2013 web applications have limitation on maximum upload size for documents. If you try to upload a file bigger than 250 MB, you will get this error message. Resolution : You need to increase maximum upload size in SharePoint 2013 central administration site: Go to Central Administration >> Application Management >> Select required web application Click on "Web Application General Settings" Change the "Maximum Upload Size" value Here is my article to configure maximum file size limit in SharePoint 2013: Increase Maximum File Upload Size in SharePoint 2013

Fix "The form submission cannot be processed because it exceeded the maximum length allowed by the web administrator." Error in SharePoint 2013

Reviewed by Salaudeen Rajack on June 22, 2014 Rating: 5

How to Enable Chart Web Part in SharePoint 2013?

June 17, 2014 SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Tips and Tricks

As per Microsoft, Chart web part in SharePoint 2013 has been discontinued, So, chart web part will be missing! Of course there are many 3rd party products available to bring Chart functionality in SharePoint 2013, is it possible to resurrect the same old chart Web part in SharePoint 2013? Yes! We can!! Here is how to enable chart web part in SharePoint 2013: Disclaimer: I'm not sure this is a fully supported method, but it serves the purpose! Step 1: Save this below chunk as a "Chart.Webpart" file <webParts> <webPart xmlns="http://schemas.microsoft.com/WebPart/v3"> <metaData> <type name="Microsoft.Office.Server.WebControls.ChartWebPart, Microsoft.Office.Server.Chart, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> <importErrorMessage>Cannot import Chart Web Part.</importErrorMessage> </metaData> <data> <properties> <property nam

How to Enable Chart Web Part in SharePoint 2013?

Reviewed by Salaudeen Rajack on June 17, 2014 Rating: 5

Add Alternate Access Mapping URL to Host Named Site Collection Zone

June 17, 2014 Host-named Site Collection, PowerShell, SharePoint

Requirement: Add new URL to Host named site collections alternate access mappings. In a SharePoint hosting Web application, once sites are provisioned from hosting control panel, We got to manually add a internet zone URL with "https" to make it available over Internet. Host named site collection alternate access mapping Host-named site collections are enhanced in SharePoint 2016 to allow you to add multiple URLs by using the Set-SPSite cmdlet. Set-SPSiteUrl - Adds new top-level URLs to a host named site collection Get-SPSiteUrl - Gets the list of all the top-level URLs assigned to a host named site collection. Remove-SPSiteUrl - This enables you to remove a top-level URL assigned to a host named site collection. How to Add AAM URL to Host Named Site Collection's Zone? Here is an example of adding alternate access mapping to a host named site collection. $Site = Get-SPSite "https://intranet.crescent.com" Set-SPSiteURL -Identity $Site -URL "ht

Add Alternate Access Mapping URL to Host Named Site Collection Zone

Reviewed by Salaudeen Rajack on June 17, 2014 Rating: 5

SharePoint 2013 Error: Unexpected response from server. The status code of response is '500'. The status text of response is 'System.ServiceModel.ServiceActivationException'.

June 16, 2014 Known Issues, Search, SharePoint, SharePoint 2013

SharePoint 2013 Search returned an error: Unexpected response from server. The status code of response is '500'. The status text of response is 'System.ServiceModel.ServiceActivationException'. In Event logs of SharePoint web front ends, it left an event: System.ServiceModel.ServiceHostingEnvironment+HostingManager/33228940 Exception: System.ServiceModel.ServiceActivationException: The service '/_vti_bin/client.svc' cannot be activated due to an exception during compilation. Solution: Either increase the Server Memory or Try closing some running applications in the SharePoint WFEs to freed up the memory in server! You can also try limiting the memory consumption on various services running on the server. Here are some: Limit the search service Set-SPEnterpriseSearchService -PerformanceLevel Reduced Limit the NodeRunner.exe's memory (NodeRunner is a SharePoint Search component) Open the configuration file at "C\Program Files\Micr

SharePoint 2013 Error: Unexpected response from server. The status code of response is '500'. The status text of response is 'System.ServiceModel.ServiceActivationException'.

Reviewed by Salaudeen Rajack on June 16, 2014 Rating: 5

Move Files Between Document Libraries with Metadata and Version History

June 16, 2014 PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Designer

Requirement: Move Files Between Document Libraries with Metadata and Version History We have a very large document library with more than 100,000 documents which is causing search crawl and latency issues. So, decided to archive old documents into separate document libraries year-wise. Stop: Before proceeding with any of the below method, Save your source list or library as a template without including content and create new list from the list template, So that your source and destination libraries will look a like! Solution 1 - Using Content and Structure page to move files with versions and Metadata: All SharePoint versions including MOSS 2007, SharePoint 2010 and SharePoint 2013 supports this functionality. Go to Site settings >> Click on "Content and structure" link under Site Administration section Pick the items/files to be moved, Click on Actions >> Move Select the target list or library and click "OK" to complete move operation. T

Move Files Between Document Libraries with Metadata and Version History

Reviewed by Salaudeen Rajack on June 16, 2014 Rating: 5

Enable Versioning for All Document Libraries in SharePoint

June 16, 2014 PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, Version History

SharePoint versioning feature tracks changes, so that you can View document or item's version history and audit/recover them if needed. How to enable versioning in SharePoint? Version feature is configured at list or library level. So, to enable version history: Go to your document library >> Click the Library tab on the Ribbon >> Click on Library Settings. Under general Settings, click Versioning Settings link. From the Versioning Settings page, choose "Create major versions". Optionally, you can set a limit on number of versions. This enables SharePoint version history. Once versioning feature is enabled, you can select a document and click on "Version History" icon from the Ribbon to view versions created. Enable Versioning on All Document Libraries of All Sites in SharePoint Well activating versioning is quite simpler as shown above! But you may want to enable versioning for all document libraries from all sites in your site collec

Enable Versioning for All Document Libraries in SharePoint

Reviewed by Salaudeen Rajack on June 16, 2014 Rating: 5

Remove All Users from SharePoint Site or List with PowerShell

June 14, 2014 Permission, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

Requirement: There is a SharePoint 2013 list lot of user permissions. Wanted to remove all user permissions from that SharePoint list. So tried removing all users, but SharePoint gave " You have chosen to delete too many groups at once. Select fewer groups and try again ." when choosing All users check box and Remove them from SharePoint site or group. So the problem here is: We can't delete users in bulk when it exceeds the maximum count by SharePoint. Here is my nifty PowerShell scripts to remove all users from SharePoint site or List. PowerShell script to remove all user permission from SharePoint list: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Variables $SiteUrl="http://your-sharepoint-site.com" $ListName="Your-List-Name" #get the Web $web = Get-SPWeb $SiteUrl #Get the List $list = $web.Lists[$ListName] #If the List is not using Unique permissions, Break inheritance if(!$list.HasUniqueRoleAssignments)

Remove All Users from SharePoint Site or List with PowerShell

Reviewed by Salaudeen Rajack on June 14, 2014 Rating: 5

Sync-Update User Display Name from Active Directory to SharePoint using PowerShell

June 12, 2014 Active Directory, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, User Profile

Problem: Discrepancies in User's properties in AD and SharePoint. Say for E.g. User''s display name property updated in Active Directory. But SharePoint still shows the old display name for the user. Solution: Ideally, a proper setup of SharePoint user profile sync should avoid these kind of issues. Use these PowerShell scripts to force update from AD to SharePoint.We can use PowerShell script to update display name of the user. E.g. Set-SPUser -Identity "i:0#.w|domain\username" -DisplayName "NewDisplayName" –Web http://sp-site The above cmdlet updates the given user's display name for the particular site. Lets do it for all users of the site (subsite). Sync All Users of a Site Collection from Active Directory: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Subsite URL $SiteURL = "https://portal.crescent.com/Teams/globalfunctions/compliance/" #Get all users of the subsite $UsersColl = Get-SPUser -

Sync-Update User Display Name from Active Directory to SharePoint using PowerShell

Reviewed by Unknown on June 12, 2014 Rating: 5

Get SharePoint Central Admin URL in PowerShell

June 08, 2014 Central Administration, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

In a PowerShell script writing, I had to get central admin URL of the SharePoint farm. Tried various approaches and found the below to get SharePoint 2010/SharePoint 2013 Central Administration site URL using PowerShell: #sharepoint 2010 powershell get central admin url Get-SPWebApplication -includecentraladministration | where ` {$_.IsAdministrationWebApplication} | Select -ExpandProperty URL Alternatively, you can use: [Microsoft.SharePoint.Administration.SPAdministrationWebApplication]::Local.URL

Get SharePoint Central Admin URL in PowerShell

Reviewed by Salaudeen Rajack on June 08, 2014 Rating: 5

Enable PDF Preview in SharePoint 2013 with Office Web Apps

June 04, 2014 Office Web Apps, Search, SharePoint, SharePoint 2013

PDF preview for SharePoint 2013 integrated with Office web apps isn't enabled by default. Use this below script to enable PDF previews in SharePoint 2013 search results. SharePoint 2013 office web apps PDF preview : Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue $TenantOwner = Get-SPEnterpriseSearchOwner -Level SSA #Search Service application name $ssa = "Search Service Application" $Rule = Get-SPEnterpriseSearchPropertyRule -PropertyName "FileType" -Operator "IsEqual" $Rule.AddValue("pdf") $RuleCollection = Get-SPEnterpriseSearchPropertyRuleCollection $RuleCollection.Add($rule) $Item = New-SPEnterpriseSearchResultItemType -Owner $TenantOwner -SearchApplication $ssa -Name "PDF Preview" -Rules $RuleCollection -RulePriority 1 -DisplayProperties "Title,Author,Size,Path,Description,EditorOWSUSER,LastModifiedTime,CollapsingStatus,DocId,HitHighlightedSummary,HitHighlightedProperties,FileExtension,V

Enable PDF Preview in SharePoint 2013 with Office Web Apps

Reviewed by Salaudeen Rajack on June 04, 2014 Rating: 5

How to Create Host Named Site Collections in SharePoint 2013?

June 04, 2014 Host-named Site Collection, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

In short, Host-named site collections allows you to have unique URL addresses for each site collection. Say for e.g. Instead of having a typical "Sales" site URL as: http://sharepoint.yourcompany.com/sites/sales , You can have it as http://sales.yourcompany.com and for HR, it can be http://hr.yourcompany.com and so on. As per Technet, HNSC as the preferred method for deploying site collections in SharePoint 2013. So, lets see how to create host named site collection in SharePoint 2013 using PowerShell. Host named site collections can be managed only through PowerShell as of today! Before heading into creating Host-named site collections, There are few Points to ponder: All necessary DNS entries must be created prior creating HNSC (Which is obvious!) You can create a Foward lookup zone in DNS with wildcard entry pointing to the Load balancer or Web Server's IP. The web application that houses host named site collection will be created without any host headers and l

How to Create Host Named Site Collections in SharePoint 2013?

Reviewed by Salaudeen Rajack on June 04, 2014 Rating: 5

Get User E-mail Address from List Item "Created By" using PowerShell

June 03, 2014 C#, PowerShell, SharePoint

For a PowerShell automation work, I had to retrieve the Email ID of the user who has created a particular list item. Here is the nifty PowerShell script to retrieve E-mail ID from created by field: Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue #Function to get User's Email from User ID Function GetUserEmail($UserValue) { #Uservalue: E.g: "1;#user name"; $arr = $UserValue.Split(";#"); $UserID = $arr[0]; $user = $web.SiteUsers.GetById($UserId); #the above line returns: SPUser Object return $user.Email } $WebURL ="http://sharepoint.crescent.com/SharePointSupport/" $ListName ="Site Requests" #Get the Web and List $Web = Get-SPWeb $WebURL $list = $web.Lists[$ListName] #Get an Item by id $item = $list.GetItemByID(1) #Get Created by User details #$item["Author"] Returns something like: 3;#Salaudeen $CreatorMail = GetUserEmail($item["Author"]) Write-Host $CreatorMail Same

Get User E-mail Address from List Item "Created By" using PowerShell

Reviewed by Salaudeen Rajack on June 03, 2014 Rating: 5

jQuery Image Rotator for SharePoint

June 03, 2014 jQuery, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013

Here is the quick and simple way to implement rotating image slider for SharePoint using jQuery.All you have do is: upload slider images to any SharePoint library and change the image paths in Slider section of the below code and place it in content editor web part or Script editor in SharePoint 2013: jQuery Rotating Banner code: <div class="im-brand-central-slider"> <ul class="slider"> <li><img src="/sites/teams/brandcentral/images1/Home_Rotator/Growth.jpg" /></li> <li><img src="/sites/teams/brandcentral/images1/Home_Rotator/ImproveTechOutcomes.jpg" /></li> <li><img src="/sites/teams/brandcentral/images1/Home_Rotator/NewEyes.jpg" /></li> <li><img src="/sites/teams/brandcentral/images1/Home_Rotator/NextGeneration.jpg" /></li> <li><img src="/sites/teams/brandcentral/images1/Home_Rotator/People

jQuery Image Rotator for SharePoint

Reviewed by Salaudeen Rajack on June 03, 2014 Rating: 5

SharePoint Site Detailed Storage Report using PowerShell

June 01, 2014 Admin Reports, CSV, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement: Generate a detailed report on all list and library sizes of a SharePoint site. Solution: PowerShell script! Here is the PowerShell script to generate detailed storage information with listing all list and library sizes. #Get Size of all lists and libraries in a SharePoint Site [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") #Get-SPWeb cmdlet for MOSS 2007 Function global:Get-SPWeb($url) { $site= New-Object Microsoft.SharePoint.SPSite($url) if($site -ne $null) { $web=$site.OpenWeb() } return $web } #Function to Get Storage Metrics for a list/library Function GetStorageMetrics($Folder) { $TotalSize=0 #Get the size of each file in the folder foreach ($File in $Folder.Files) { #Get File Size $FileSize = $File.TotalLength $VersionSize=0 #Get the Versions Size foreach ($FileVersion in $File.Versions

SharePoint Site Detailed Storage Report using PowerShell