By installing the KB3114503 https://support.microsoft.com/en-us/kb/3114503 all the listview webparts on your SharePoint 2013 server displays this error repeatedly.

“TypeError: Cannot read property ‘replace’ of undefined”

With danish localization it looks like this:

“TypeError: Værdien af egenskaben ‘replace’ kan ikke hentes: Objektet er null eller ikke defineret”

image

image

Workaround

Apparently a workaround is this quickfix https://www.reddit.com/r/sysadmin/comments/40tvqn/quickfix_patch_kb3114503_causes_sharepoint_to/ where you modify the view to display the item title colounm (linked to item) instead of (linked to item with edit menu).

Some reports states that a solution is applying January 2016 CU. And that the KB3114503 update is unable to be removed after installation.

So remember to turn off automatic windows update and test any patch/CU before production!

clip_image005

 

More

To learn more about the vulnerabilities the KB3114503 fixes, see Microsoft Security Bulletin MS16-004.
Note To apply this security update, you must have the release version of Service Pack 1 for Microsoft SharePoint Foundation 2013 installed on the computer.

Sources

Tags: , , | Categories: Technical

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 and a reset of the web server was sufficient.

  1. ipconfig -flushdns
  2. iisreset -noforce

 

 

 

Tags: , , , | Categories: SharePoint Configuration | SharePoint

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 roles of the admin account on the content database.

  • db_denydatareader
  • db_denydatawriter

Make sure that db_denydatareader and db_denydatawriter are unchecked on the user. 

Thank you Steve! http://stevemannspath.blogspot.dk/2013/03/sharepoint-permission-error-when.html 

 

Tags: , , , | Categories:

Microsoft released the Service Pack 1 (SP1) for the 2013 set of Office products including Office 2013, SharePoint 2013 and Exchange Server 2013.

  • Office 2013 customers will begin to get notifications of SP1 availability through Windows Update within the next 30 days.
  • For Exchange Server 2013 and SharePoint 2013 you can use the links below.
  • If you are an Office 365 subscriber, you are always on the most up-to-date version

Here is an excel sheet of issues Fixed by Service Pack 1 (SP1) in Office and SharePoint 2013

Download_Symbol

SharePoint Server 2013

KB2817429

Service Pack 1 for Microsoft SharePoint Server 2013 (KB2817429)

Service Pack 1 for Microsoft SharePoint Server 2013 Language Pack (KB2817438)

SharePoint Foundation 2013

KB2817439

Service Pack 1 for Microsoft SharePoint Foundation 2013 (KB2817439)

Service Pack 1 for Microsoft SharePoint Foundation 2013 Language Pack (KB2817442)

SharePoint Designer 2013

Service Pack 1 for Microsoft SharePoint Designer 2013 (KB2817441) 64-Bit Edition

Service Pack 1 for Microsoft SharePoint Designer 2013 (KB2817441) 32-Bit Edition

Project Server 2013

KB2817434

Service Pack 1 for Microsoft Project Server 2013 (KB2817434)

Exchange Server 2013

Exchange Team Blog post on changes with the SP1

Microsoft Exchange Server 2013 Service Pack 1 (SP1)

 

Tags: , , , , | Categories: SharePoint

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 set in the user interface.

If you are creating a WSP:

Here is the xml for the field called “CustomSortOrder” is a required field with the deafult value set to “00”:

<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
  <Field
        ID="{[id]}"
        Name="CustomSortOrder"
        DisplayName="Sort Order"
        Type="Text"
        Required="TRUE"
        EnforceUniqueValues="FALSE"
        Indexed="FALSE"
        MaxLength="2"
        Group="CustomField">
    <Default>00</Default>
    <Validation Message="The value of this field must be between 01 and 99 and with 2 characters.">
=IF(LEN(CustomSortOrder)=2,ISNUMBER(CustomSortOrder+0),FALSE)
</Validation> </Field> </Elements>

 

In my search for this solution I found some other formulars at The Chris Kent blog:

 

Happy SharePointing.

 

Tags: , | Categories: SharePoint Development | SharePoint Configuration

Todd Klindt has made a very useful SumUp on how to create different SharePoint Admin Permissions.

For more information, take a look at Todds post Demystifying SharePoint Admin Permissions at Todd Klindt's SharePoint Admin Blog

Web Application Policy

How Do You Give It?

In Central Admin > Manage Web Applications > Policy for Users

Farm Administrators in Central Admin

How do you give it?

In Central Admin > Security > Farm Administrators

SPShellAdmin

How do you give it?

From PowerShell with the Add-SPShellAdmin cmdlet.

Service App Administrator

How do you give it?

Central Admin > Service Application Management. Highlight the service application and click “Administrators" in the ribbon. Add the user to the Administrators list.

Tags: , , | Categories: Tips and tricks | SharePoint Configuration

Trying to filter a list on its workflow status is pretty non-intuitive. You need the special status codes. Theese will work with all workflows in ShaePoint even Nintex workflows.

Status Code

Status Description

0

Not Started

1

Failed on Start

2

In Progress

3

Error Occurred

4

Cancelled (i.e. Stopped by User)

5

Completed

6

Failed on Start (retrying)

7

Error Occurred (retrying)

8

(unknown)

9

(unknown)

10

(unknown)

11

(unknown)

12

(unknown)

13

(unknown)

14

(unknown)

15

Cancelled

16

Approved

17

Rejected

Theese status codes can be used in editing list view query in both the user interface and the CAML in the list schema.xml

image005

 

image006

Another little special SharePoint speciality is that the workflow status field is referenced as the 8 first letters in the workflow instance name and the value type as WorkflowStatus

References:

Tags: , , , , , | Categories: Tips and tricks | SharePoint Development | SharePoint Configuration

Here is a list of web template features to use in your SharePoint 2013 web template projects.

Make sure that each of the features in the table beneath is contained in the WebFeatures section in your ONET.XML

DisplayName

Feature ID

AccSvcAddAccessApp

d2b9ec23-526b-42c5-87b6-852bd83e0364

AnnouncementsList

00bfea71-d1ce-42de-9c63-a44004ce0104

BaseWeb

99fe402e-89a0-45aa-9163-85342e865dc8

BizAppsListTemplates

065c78be-5231-477e-a972-14177cc5b3c7

ContactsList

00bfea71-7e6d-4186-9ba8-c047ac750105

ContactsList

00bfea71-7e6d-4186-9ba8-c047ac750105

CustomList

00bfea71-de22-43b2-a848-c05709900100

DataConnectionLibrary

00bfea71-dbd7-4f72-b8cb-da7ac0440130

DataSourceLibrary

00bfea71-f381-423d-b9d1-da7a54c50110

DiscussionsList

00bfea71-6a49-43fa-b535-d15c05500108

DocumentLibrary

00bfea71-e717-4e80-aa17-d0c71b360101

EventsList

00bfea71-ec85-4903-972d-ebe475780106

EventsList

00bfea71-ec85-4903-972d-ebe475780106

ExternalList

00bfea71-9549-43f8-b978-e47e54a10600

FollowingContent

a7a2793e-67cd-4dc1-9fd0-43f61581207a

GanttTasksList

00bfea71-513d-4ca0-96c2-6a47775c0119

GettingStarted

4aec7207-0d02-4f4f-aa07-b370199cd0c7

GridList

00bfea71-3a1d-41d3-a0ee-651d11570120

HierarchyTasksList

f9ce21f8-f437-4f7e-8bc6-946378c850f0

IPFSWebFeatures

f9ce21f8-f437-4f7e-8bc6-946378c850f0

IssuesList

00bfea71-5932-4f9c-ad71-1557e5751100

LinksList

00bfea71-5932-4f9c-ad71-1557e5751100

MBrowserRedirect

d95c97f3-e528-4da2-ae9f-32b3535fbb59

MDSFeature

87294c72-f260-42f3-a41b-981a2ffce37a

MobilityRedirect

f41cc668-37e5-4743-b4a8-74d1db3fd8a4

MySiteMicroBlog

ea23650b-0340-4708-b465-441a41c37af7

NoCodeWorkflowLibrary

00bfea71-f600-43f6-a895-40c0de7b0117

PictureLibrary

00bfea71-52d4-45b3-b544-b1c71b620109

PremiumWeb

0806d127-06e6-447a-980e-2e90b03101b8

PromotedLinksList

192efa95-e50c-475e-87ab-361cede5dd7f

ReportListTemplate

2510d73f-7109-4ccc-8a1c-314894deeb3a

SiteFeed

15a572c6-e545-4d32-897a-bab6f5846e18

SiteFeedController

5153156a-63af-4fac-b557-91bd8c315432

SurveysList

00bfea71-eb8a-40b1-80c7-506be7590102

TaskListNewsFeed

ff13819a-a9ac-46fb-8163-9d53357ef98d

TasksList

00bfea71-a83e-497e-9ba0-7a5c597d0107

TeamCollab

00bfea71-4ea5-48d4-a4ad-7ea5c011abe5

WebPageLibrary

00bfea71-c796-4402-9f2f-0eb9a6e71b18

WikiPageHomePage

00bfea71-d8fe-4fec-8dad-01c19a6e4053

WorkflowHistoryList

00bfea71-4ea5-48d4-a4ad-305cf7030140

workflowProcessList

00bfea71-2d77-4a75-9fca-76516689e21a

WorkflowServiceStore

2c63df2b-ceab-42c6-aeff-b3968162d4b1

WorkflowTask

57311b7a-9afd-4ff0-866e-9393ad6647b1

XmlFormLibrary

00bfea71-1e1d-4562-b56a-f05371bb0115

Tags: , | Categories: SharePoint Development

At last it is now possible to download a standalone SkyDrive Pro client.

The standalone SkyDrive Pro sync client allows users of SharePoint 2013 and SharePoint Online in Office 365 to sync their personal SkyDrive Pro and any SharePoint 2013 or Office 365 team site document libraries to their local machine for access to important content on and offline. The SkyDrive Pro sync client can be installed side-by-side with previous versions of Office (Office 2010, Office 2007, etc).

 Download SkyDrive Pro client for Windows

Tags: , , , , , | Categories: SharePoint related