PPM Tricks

Today I came across a very strange problem. On a newly install server every queue job was failing. Project Create, Resource Change, Workflow submit, every reporting job and some project job was failing. Problem: I started looking into the queue to find an explanation. Here I found several errors, but could not make any sense of them. Resource Reporting Error: Generelt•Reporting message processor failed:◦ReportingResourceChangeMessageFailed (24008) - The value's length for key 'application name' exceeds it's limit of '128'.. Detaljer: id='24008' name='ReportingResourceChangeMessageFailed' uid='3f02fa38-f574-e411-93fd-00155d007817' QueueMessageBody='Resource UID: 'dc548543-3352-454e-a86b-96d1a4bf63d2'. ChangeType='Alter'. ResourceChangeType='All'' Error='The value's length for key 'application name' exceeds it's limit of '128'.'. ◦ReportingResourceChangeMessageFaile

Ever experienced the problem where you run a Powershell command and you cannot see the whole result because the result is truncated. Problem: If you for example run the Test-SPsite command you might see something like the following: Site : SPSite Url=http://atlas/pwa Results : { SPSiteHealthResult Status=Passed RuleName="Conflicting Content Types" RuleId=befe203b-a8c0-48c2-b5f0-27c10f9e1622, SPSiteHealthResult Status=FailedWarning RuleName="Customized Files" RuleId=cd839b0d-9707-4950-8fac-f306cb920f6c, SPSiteHealthResult Status=Passed RuleName="Missing Galleries" RuleId=ee967197-ccbe-4c00-88e4-e6fab81145e1, SPSiteHealthResult Status=Passed RuleName="Missing Parent Content Types" RuleId=a9a6769f-7289-4b9f-ae7f-5db4b997d284, SPSiteHealthResult Status=FailedError RuleName="Missing Site Templates" RuleId=5258ccf5-e7d6-4df7-b8ae-12fcc0513ebd,

Problem : When you access a SharePoint site collection, it keeps on prompting for authentication and eventually give you an Access Denied error. Reason : This is a feature that prevents access to a web application using a fully qualified domain name (FQDN) if an attempt to access it takes place from a machine that hosts that application. The end result is a 401.1 Access Denied from the web server and a logon failure in the event log. Solution: There are 2 ways to solve this,   ( 1 ) the correct way and  ( 2 ) the fast and easy way. 1 - The correct way (test/production servers) :  Specify the host names that needs to do loop back check in the registry – BackConnectionHostNames. This is the correct way and is more secure. http://support.microsoft.com/kb/896861  - Open regedit.exe  - Navigate to   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0  - Create a new multi-string value and name it " BackConnectionHostNames"  - Type the host name of sit

On my Contoso environment I was trying to create a sandboxed solution. I have already configured my app domain and app management services. But when I tried to validate the site I got the following error message. Error Cannot connect to the targeted site. This error can occur if the specified site is not hosted on the local system. SharePoint solutions work only with locally-installed versions of SharePoint Foundation or SharePoint Server. Remote development is supported only for apps for SharePoint 2013. If you search around the internet you will find many people suggesting to change your host file from 127.0.0.1 to the actual IP. Solution However the solution, at least on a Contoso environment, is to type in the actual IP address in the host file. (the IP 192.168.150.1 is the special IP for Contoso, I have 2 network adapters) And do not forget to clear/flush the DNS cache. Now the solution can be created and validates.

A new update to Visual Studio 2013 is out, and as always there are a lot of general improvements and some improvements targeted SharePoint/Project Server. The most noticeable changes for SharePoint development (and SharePoint App development) is:  - Better IntelliSense for JavaScript  - JSON improvements (Loading and IntelliSense)  - Better HTML IntelliSense  - #Region support in HTML  - Razor bugfix  - XAML Designer bugfix (Silverlight) (Download it from: http://support.microsoft.com/kb/2994375 ) Complete release notes Team Foundation Server You can create trend charts and aggregate data from work item queries. When a new work item chart is created, you can see three new chart types: Stacked Area , Area , and Line . You can move items in the backlog to the top position ( Move to Top ) or to any position you want to determine ( Move to Position ). You can enter the "full-screen mode" for all the pages in the Backlogs hub. You can search for an Area path

After Project Online and heavy use of the PWA-Schedule features in Project Server 2010/2013 I rarely get use for my VBA skills anymore. However today I needed to update a lot of resources in Resource Center with a value from a lookuptable. Therefore I needed a way to loop through all the lookuptable/custom field values and use the value. After a little digging I found a way to read out all the lookuptable values through VBA. And of cause I need to share this. VBA to read all lookuptable values from the RBS lookuptable  Sub ReadRBSLookuptable() 'Created by Christian Holse Fanning Dim lookupTableName As String lookupTableName = "RBS" Dim rbsLT As LookupTable Dim ltValue As LookupTableEntry For i = 1 To Application.GlobalOutlineCodes.Count If Application.GlobalOutlineCodes(i).Name = Trim(lookupTableName) Then Set rbsLT = Application.GlobalOutlineCodes(i).LookupTable End If Next i If Not IsNull(rbsLT) And Not (rbs

Received this error today when trying to create a SharePoint solution against a newly created site. My first problem was the site was configured to use a port which was already used by another web site. Therefore the site could not start at all. In my case both Default Web Site and SharePoint - 2000 was both using port 2000. Changing the port of Default Web Site and I was able to start the site. However now I still received the same error message. When browsing the site I realized I did not have access to the site. Giving access to my user and I was able to deploy the solution. To sum up this post:  - Check the site can start  - Check the site can be browsed  - Check your user have access to the site

If you are developing apps provider hosted apps for SharePoint (or Project Server) and want to deploy them to SharePoint Online you need to host your app's web site part somewhere. One good and obvious place is to host it on Azure, however I have found that in order to troubleshoot your app it is a lot easier if the app is hosted on a local IIS. In order to host your app on a local IIS you need to configure the DMZ for the app (in addition to the website, certificate, app secret and app id). Configure DMZ for a D-Link router DMZ tells the router that you allow a specific port to go to a specific computer. In the following I will explain how to configure DMZ for my D-Link DI-524 router. Other routers will have similar approhes. Log on to the router at IP address 192.168.0.1. Enter the admin user name and password (default password is "password"). Click on the Advanced tab. Choose  - Enable  - Your PC's IP address (the PC hosting the apps web site)  

If you are starting to develop Apps for SharePoint or Project Server and you encounter the problem where you get the following error message: Error 1 Error occurred in deployment step 'Install app for SharePoint': Sideloading of apps is not enabled on this site. 0 0 SharePointApp_01 It is usually because the site you are developing against is not a SharePoint development site. The easiest way to solve the problem is of cause to create a new SharePoint Development site. However this is not always possible and you might have a lot of content on your site you want to test against. Furthermore if you are creating a Project Server App I have not found a way to create a Project Server Development site. Convert SharePoint (and Project Server) site into a Development site This can simply be done through Powershell. To be able to run Powershell agains online you will need to download  SharePoint Online Management Shell . The Powershell s