PPM Tricks

I recently developed our first MS Project app and expirenced a problem where the app could not load. APP ERROR This app could not be started. Close this dialog to ignore the problem or click "Restart" to try again. Solution The solution is to enable Protective Mode in you version of Internet Explorer. After this, the app should load fine. According to Microsoft  it is a requirement that Protective Mode is enabled in Internet Explorer for Office Apps to work. The app shown is a MS Project App and is named Project Blog News. Download it here:  https://store.office.com/.../project-blog

Our company have a rather complex add-in to Project Server. For some time we have been struggling with performance issues and no matter how much we tuned the SQL procedures, after some time they would always become slow in a production environment.  Today I came across a tool in SQL Server Management Studio which very easily can pinpoint which queries are running slow. In our case we discovered that one query was very slow and slowed all other queries. This tool is called Activity Monitor and is build into most versions of Management Studio. Note: Activity Monitor requires SysAdmin permissions to be used. The tool is very simple to use. Simply open SQL Server Management Studio and connect to your database.   Click on the Activity Monitor icon. Here you will see a number of sections showing different information about the server.  Overview shows IO, wait time, etc. Processes shows information about which processes/connections is...

Today I got a support case where alerts in SharePoint was not triggered, I quickly realized the problem was that the email address on the users was wrong in SharePoint and the admins only updated the emails in Project Server. Why the emails were not correct i do not know and did not look further into it. To solve the difference between SharePoint and Project Server I created this small C# script/program which synchronize user emails from Project Server into SharePoint. You will typically need a tool like this when you are creating your users manually in Project Server and the emails are synchronized from a inconsistent Active Directory. The program can be found here: Project Server -> SharePoint Emails sync The code for the program/script is as follows: static void Main(string[] args) { string pwa = ""; string webApp = ""; if (args.Length <= 0) { WriteLine("WRONG ARGS, PWA"); return; } pwa = args...

Very nice little script i created to warmup all PWA pages and workspaces. Simply replace the SiteURL and the SitePages with your own values and place the code in a file named "SharePointWarmup.ps1". Run the script in Powershell or  Task Scheduler . $SiteURL = "http://intra/PWA/" $SitePages = "default.aspx", "projects.aspx", "ProjectBICenter/_layouts/15/xlviewer.aspx?id=/PWA/ProjectBICenter/Sample%20Reports/Projectum/DailyCommentsReport%20v7%20-%20PowerView.xlsx&Source=http%3A%2F%2Fintra%2FPWA%2FProjectBICenter%2FSample%2520Reports%2FForms%2FAllItems%2Easpx%3FRootFolder%3D%252FPWA%252FProjectBICenter%252FSample%2520Reports%252FProjectum%26FolderCTID%3D0x012000271EBEF22B819D4AA417BE3C68ADBA34%26View%3D%257B857402E5%252DF616%252D4DC2%252DA880%252D5CFC03D52EFA%257D", "Project%20Detail%20Pages/Project%20Information.aspx", "project%20detail%20pages/schedule.aspx", "project%20detail%20pa...

If you want to run a Powershell script against SharePoint on a timely schedule the Windows Task Scheduler is fast an simple approach. A simple example of this could be a SharePoint warm-up script which hits a number of sites on a regular schedule. However it is maybe not as straight forward to figure out the syntax for the Powershell command as you might think. Run in CMD The first step is to verify you can run the script from a command prompt. (you might want to start the command prompt as the account that is going to run the scheduled task). 1. Click start and type CMD, press enter. 2. Paste the following command and replace the script-path with the location of you own script.     Powershell -file "C:\PathToFile\SharePointWarmupScript.ps1" 3. Press enter and see the script being executed successfully. Create Task Schedule The next step is to create the scheduled task. 1. Click start and type Task Scheduler, press enter. 2. Left click Task Schedul...

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, ...