Daniel Bell's avatar

posted by
201 views

Microsoft Project Server 2013 - Root Element is Missing

We were dealing with this issue today when attempting to save a rather large project schedule.  The project would create the getting queued message in the queue them immediately fail.  We knew that meant the informa ...


Daniel Bell's avatar

posted by
157 views

Microsoft Project Professional 2013 support with Project Online

Below is a communication from Microsoft regarding the version of Project Professional used to connect to Project Online.  Currently users may use version 2013 and 2016.  Beginning June 30, 2017, Project Online will ...


Daniel Bell's avatar

posted by
174 views

Creating a Microsoft Project Online Major Milestone report with Excel

Learn how to create a Major Milestone report for Microsoft Project Online using Excel and Power Pivot in this video.  We cover every step from creating the data source, adding a calculating field, to formatting the repor ...


Daniel Bell's avatar

posted by
287 views

Your queue job CreateWssSite failed: Microsoft Project Online

Upon publishing a project we were receiving an error in the queue with the title “Your queue job CreateWssSite failed. Please contact your administrator for assistance.”Embedded in the long error was the following:<?xml ve ...


Daniel Bell's avatar

posted by
374 views

PowerBI DAX: Create SUBTABLE with Filter

Today I was working with the Project Online Projects and ProjectWorkflowStageDataSet tables in PowerBI.  I wanted to created a chart that showed data points that involved workflow status, projects, tasks.  The many ...


Daniel Bell's avatar

posted by
455 views

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

Recently had a customer that was receiving an error when attempting to save a project.  The project had in excess of 5000 lines.  Project Professional produced the rather vague error you see below.


Daniel Bell's avatar

posted by
434 views

Change permission mode of Project Online instance

Navigate to the Office 365 portal as an administrator Navigate to the SharePoint Management area Click the checkbox on front of the PWA site collection you want to change the permissions mode for Click the Project Web App ...


Daniel Bell's avatar

posted by
483 views

Shrinking a SQL 2012 log file

This method works extremely well and quick!USE AdventureWorks2008R2;GO-- Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABASE AdventureWorks2008R2SET RECOVERY SIMPLE;GO-- Shrink the truncated log ...


Daniel Bell's avatar

posted by
795 views

WorkflowCheckinNotify Error Project Server 2013

I was receiving this error at a customer site recently.  They had no workflows setup in the system, although they did have all the necessary objects installed to deploy Project Server workflows.  In order to get aro ...


Daniel Bell's avatar

posted by
879 views

UpdateWSSCountersMessage

Encountered this issue.  The error message received by the Project Manager is not sufficient to troubleshoot.  Grab the message in the queue.  it’s the last message in this post.  The exact issue is highli ...


Daniel Bell's avatar

posted by
323 views

SRS SSRS Rotating color background

=iif(RunningValue(Fields!Client_Name.Value,CountDistinct,Nothing) Mod 2, "LightSteelBlue", "AliceBlue")


Daniel Bell's avatar

posted by
560 views

Want to learn how to leverage alerts for Documents, issues and risks?

Want to learn how to leverage alerts for Documents, issues and risks?  Then watch this new video we just posted to our YouTube channel! http://bit.ly/1NV0LXq