Search Results

For our Project Server 2007 folks out there:  This one is for you. Thanks to Brian and Microsoft for his blog:  http://projectserverblogs.com/?p=5272 Service Pack 3 (SP3) for Project and Project Server 2007 are now released and can be found at: 2007 Microsoft Office servers Service Pack 3 (SP3) and 2007 Microsoft Office servers Language Pack […]

Description of the Project 2010 hotfix package (Project-x-none.msp): October 25, 2011 http://support.microsoft.com/kb/2596495  Folks, this hotfix seems to address several issues that you may have seen and some that will save you heaps of time (and did not know about). Read on and let us know how your testing goes.   Also – Microsoft has let us […]

I was Performing an upgrade for a client recently when I encountered this error.  In the past when I received this error it was usually the result of my incorrectly typing the name of one of the four Project Server databases incorrectly.  This time, however, that was not the case.  Error message and resolution are […]

Quite often when writing reports that grab data from SharePoint lists, you have to deal with HTML tags showing up in your reports.  This function helps clean that garbage from the fields. Usage: ,dbo.DeHtmlize(MSP_EpmProject_UserView.[Current Status]) as [Current Status] USE [ProjectServer_Reporting] GO /****** Object:  UserDefinedFunction [dbo].[DeHtmlize]    Script Date: 03/22/2011 11:03:55 ******/ SET ANSI_NULLS ON GO SET […]

Folks – if you are a Project Server 2007 shop and your Data Analysis cube stops building – the following article will help you.  This may occur if you change your SharePoint server farm (servers or names).  Let us know if you have any additional questions. http://blogs.msdn.com/b/brismith/archive/2008/12/09/project-server-2007-has-your-cube-build-stopped-working-to-the-schedule.aspx Enjoy.

Folks there is a lot of buzz around Project Conference 2012.  We will be there will you?  Register today and secure your spot.  Get the most out of Microsoft Project and make sure to stop by and introduce yourself to the MS PROJECT NOW! team. -Jacques

When attempting to create a data source for performance point services I encountered this error.  The cause of this error has to do with setting up an unattended service account for PPS.  Do so as follows: Navigate to Central Administration Under Application Management, click Manage Service Applications Click on the PerformancePoint Service Application Click on […]

One of my clients asked if it was possible to make a shortcut of a Project Server project from the desktop.  Well by using command-line switches you can definitely open a project.mpp file.  I will let you know if it works for Project Server projects. For now, check out this information (provided by MSFT) on […]

Description of the Project Server 2010 cumulative update package (Project server-package): October 13, 2011 Cumulative Update link: http://support.microsoft.com/kb/2553049 Project Server 2010 hotfix package:  http://support.microsoft.com/kb/2553047 We recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new release contains all the hotfixes and security updates that were […]

Many of us use SSRS (SQL Server Reporting Services) to generate and display Project Server data.  Well now thanks to Cristian and the Microsoft BI Team, we can leverage the PivotViewer Extension to create some very impressive reports. http://www.microsoft.com/BI/en-us/Community/BILabs/Pages/PivotViewerForSSRS.aspx http://www.microsoft.com/silverlight/pivotviewer/ Happy Reporting. -Jacques

Use ProjectServer_Published SELECT * FROM Versions WHERE VersionId = '00000000-0000-0000-0000-000000000000' ORDER BY Id DESC

Note: This is a repost from Brian Smith’s Blog (thanks Brian).  I found it so helpful I wanted it close by. This follows on from the posting on the structure of the Business Intelligence Center in Project Server 2010 - http://blogs.msdn.com/b/brismith/archive/2010/08/24/project-server-2010-business-intelligence-center-behind-the-scenes.aspx and covers a few of the possible errors you might run in to. For […]

  When saving a project offline from Project Server 2010, I get the following errors when I try to open the schedule offline: "The copy of this project in the Local Project Cache may be damaged. Try the operation again. If the problem persists, some possible options to try include: use a backup copy of […]

In this case resetting the target applications via Set Credentials resolved my issue.  Sometimes the simplest route should be taken first.

Once you have your farm configured for SQL Reporting Services in SharePoint integrated mode, the next step is to create a document library that you will upload the .rdl files.  Do so as follows:   From within the Business Intelligence center in Project Server 2010   Navigate Site Actions –> View All Site Content   […]

  I will not go into what w3wp.exe is used for as there are many posts online on the topic.  I am only sharing my experience.  I have a client that makes heavy use of SharePoint 2010, with numerous web applications, each with it’s own application pool.  My concern was the memory use of the […]

  Recently a client of mine would receive this error when attempting to search within a SharePoint site collection.  This partcular issue was a bit more involved than I had originally expected.  Reason being, when I went to manage the configuration of the Service Application I received a error message stating there was an error […]