RoennesNet

Tag: SharePoint 2016

  • Get SharePoint 2013 Content Types

    , ,

    All of the available out-of-the-box content types and their related columns in SharePoint Server 2013 are listed here in a post @JKevinParker http://www.jkevinparker.com/2014/02/sharepoint-2013-content-types-and.html You can also find the xml for most of the built in content types at your SharePoint server under the 15 hive folder TEMPLATE\FEATURES\ctypes\   Here is the PowerShell to fetch all content…

  • Fixing SharePoint Unexpected SPAudienceValidator Audience URI is not valid for context

    ,

    Following up on a change of default URL for a WebAppllication on SharePoint 2013, the site did not respond correctly. Finding the a Unexpected SPAudienceValidator Audience URI ‘[OLDURL]’ is not valid for context in the ULS led me to this blog post https://gavinmckay.wordpress.com/2014/11/28/fixing-sharepoint-2013-unexpected-spaudiencevalidator-audience-uri-is-not-valid-for-context/ Indeed a caching issue, in my case a flush of the DNS…

  • Mount-SPContentDatabase throws permission was denied on the object sysobjects

    ,

    When using the PowerShell command Mount-SPContentDatabase or adding content database through the Central Admin you will receive this error message: The SELECT permission was denied on the object ‘sysobjects’, database ‘mssqlsystemresource’, schema ‘sys’. if the SharePoint Admin account has the deny permissions checked. The easy fix was to open SQL Server Management Studio and modify the…

  • SharePoint content type collection cannot be modified exception in PowerShell

    ,

    Got the error while scripting content type modifications with PowerShell and SharePoint 2010.     Error System.Management.Automation.MethodInvocationException: Exception calling “Update” with “1” argument(s): “The collection cannot be modified.” —> Microso ft.SharePoint.SPException: The collection cannot be modified.    at Microsoft.SharePoint.SPContentType.Update(Boolean updateChildren, Boolean ignoreSealedOrReadOnly, Boolean throwOnSealedOrReadOnly, IList`1 exceptions)    at Microsoft.SharePoint.SPContentType.Update(Boolean updateChildren)    at Update(Object , Object[]…

  • SharePoint column validation for only numbers with fixed length

    ,

    Here is how to set column validation formula for SharePoint field to contain only numbers and only two symbols (fixed length). You have to use a “single line of text” field because the number field won’t work this way. Here is the formula: =IF(LEN(CustomSortOrder)=2,ISNUMBER(CustomSortOrder+0),FALSE) This works for both SharePoint 2010 and 2013 and can be…