Project Online: Connection string problem with Ukrainian reports

This issue is very specific to trying to load and refresh reports in Project Online when using the українська (Україна) (Ukrainian (Ukraine) document library but as I do have Ukrainian readers – and some of the workaround steps might also be useful for some other as-yet unknown issue so I thought this well worth sharing. …


Project Server 2016: Why does PSDataccess Deny Select on Tables?

In Project Server 2016 you can still make direct access to the database for reporting as long as each PWA site is in its own Content Database – but you may have noticed that the PSDataAccess role has an explicit Deny on Select for all tables in the database.  As an example lets take a…


Project Online: Where did the Last Connect column go?

We have had quite a few customer calls on this topic – so getting more information out there.  A while ago, due to some performance problems we dropped the Last Connect column from the Manage Users page on Project Online.  This field used to show the last connect time for the user.  To be honest…


Project Server 2013 and 2016 August 2016 PU

Yesterday saw the release of the August 2016 Public Update (PU) for Project Server 2013 and 2016. There is no update for Project and Project Server 2010 this month. The Project 2013 and 2016 client updates continued their new pattern this month, the Office client non-security updates released on the 1st Tuesday – August 2nd.  Any Office client…


Project Server: Where did all those Reporting Project Sync jobs come from?

This also applies to Project Online – and all versions of Project Server – 2010, 2013 and 2016.  The Reporting (Project Sync) job is a low priority job that moves data into the reporting schema following either a publish of the project – or any update to the contents of the SharePoint site associated with…


Project Server 2010, 2013 and 2016 July 2016 PU

Yesterday saw the release of the July 2016 Public Update (PU) for Project Server 2010, 2013 and 2016.  The Project 2013 and 2016 client updates continued their new pattern this month – and this will be the same for all future months – and the Office client non-security updates released on the 1st Tuesday –…


Project Server 2016: Missing some UserViews?

We are still hunting down the cause of this issue but we are seeing either fresh Project Server 2016 Project Web App instances or updates to Project Server 2016 causing some of the usual views in the pjrep schema used for reporting to be dropped. One example of a missing view is the pjrep.MSP_EpmProject_UserView.  If…


Project Server 2010, 2013 and 2016 June 2016 PU

Yesterday saw the release of the June 2016 Public Update (PU) for Project Server 2010, 2013 and 2016.  The Project 2013 and 2016 client updates continued their new pattern this month – and this will be the same for all future months – and the Office client non-security updates released on the 1st Tuesday –…


Project Server 2010, 2013 and 2016 May 2016 PU Announcement

Yesterday saw the release of the May 2016 Public Update (PU) for Project Server 2010, 2013 and 2016.  The Project 2013 and 2016 client updates continued their new pattern this month – and this will be the same for all future months – and the Office client non-security updates released on the 1st Tuesday –…