Cascade Skyline - with Microsoft Logo and Project Support header - author Brian Smith

September, 2010

  • Brian Smith's Microsoft Project Support Blog

    Project Server 2010: Business Intelligence Center–Common Errors

    • 22 Comments

    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 Project Server 2007 one of my most read, or at least “most viewed” and commented pages was Common Error Messages when Building Cubes with Project Server 2007.  I think with the architecture of 2010 we resolve many of those cube building difficulties, but the configuration or Excel Services Application and Secure Store Service will fill the gap that leaves.  I am preparing some internal training on this topic so thought I’d re-purpose many of my screenshots in this blog posting.  I start with no configuration or Excel Services or the Secure Store Service at all, as if I had never read or even heard of the excellent article at http://technet.microsoft.com/en-us/library/ee662106.aspx that describes how things should be configured and then hit one error after another until finally I have it all working.  I will attempt to run the SimpleProjectList sample report from the default English (United States) library.  I will number the errors, and then at the end of the posting I will list the ULS log entries you can expect to see for each error, along with the text from these error dialogs, and hopefully this will allow you to work backwards from the logs to the cause.  I want to include the logs so the search engines have something cool to read without breaking the flow of the story too much – and the text from the dialogs as the search engines may struggle with the pictures.

    image

    Error 1

    image

    The first error I see tells me that it will not open that report as the Data Connection file is not in a trusted location.  Well that’s an easy one to fix (referring to the TechNet document referenced above) so I add the right URL as a trusted location and move on…

    Error 2

    image

    Well at least this ones just a warning – and I can continue just by clicking “Yes”, but we should really fix that.  This is an interesting one as you might have wondered (if you know already what needs configuring) why we didn’t get an error about our file itself;f not being in a trusted location.  The reason is that by default there is a trusted location of http://.  And this is configured to trust children, and also to allow External Data.  In fact the only thing it is missing from our recommended configuration is that Refresh warning enabled is still checked – hence the warning we are getting at Error 2.  Best practice would probably be to delete the http:// location and then just explicitly set the locations as per the TechNet document.  So moving on…

    Error 3

    image

    Now we have Excel Services Application configured just right – so we start hitting the Secure Store Errors.  In a bid to hit most of the possible errors I created a Secure Store Service Target Application but didn’t set any credentials…

    Error 4

    image

    Hmm.  Same error, but the ULS logs distinguish between them (– see the section at the end of the blog for the differences.  So now I set some credentials, but put in a bad password…

    Error 5

    image

    Different error, and this makes sense.  We have some credentials, but they don’t work.  I’ll put that password right, but for the group that can make use of this target application I will use a group that I do not belong to…

    Error 6

    image

    Back to the generic error again, but ULS comes good and gives us a better idea what might be wrong. “Claims stored in the credentials did not match with the group claim for a group app.”  Put in the right group, of which I am a member and hey presto!  All that just for one project!

    image

    I’m sure there may be other combinations of issues that will give different errors, but I have been very impressed with the wording in the ULS logs (see below) which does make it quite easy to understand what might have gone wrong.

    Here are the details of the errors again, more for the search engines, but feel free to read on.  I haven’t listed all the lines associated with the failure – just the main ones that will help identify the failure mode.  As mentioned above I have also included the text from each of the dialogs above

    Error 1

    Dialog - The Data Connection File <url to odc file> used in the workbook is not in a trusted location.  
    The following connections failed to refresh:

    Project Server - Simple Projects List
    ULS - 
    • w3wp.exe (0x230C) 0x18DC Excel Services Application External Data 5647 Information The ODC file http://brismith8100. /PWA/ProjectBICenter/Data%20Connections%20for%20PerformancePoint/English%20(United%20States)/Project%20Server%20-%20Simple%20Projects%20List.odc is not in a DCL that is trusted by Excel Services Application. To fix this problem, add the DCL to the trusted DCL list in the administrator console.
    • w3wp.exe (0x230C) 0x18DC Excel Services Application Excel Calculation Services erw5 Medium ConnectionInfoManager.GetConnectionInfo: InitConnInfoFromOdcFile threw an exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException: Exception of type 'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException' was thrown. at Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.InitConnInfoFromOdcFile(ExtendedConnectionInfo extendedConnInfo) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request request, String externalSourceName, Int32 externalSourceIndex, Boolean& shouldReportFailure)
    Error 2
    Dialog - This workbook contains one or more queries that refresh external data. A malicious user can design a query to access
    confidential information and distribute it to other users or perform other harmful actions.
    If you trust the source of this workbook, click Yes to enable queries to external data in this workbook. If you are not sure, click No so that changes are not applied to your workbook.
    Do you want to enable queries to external data in this workbook?
    ULS – Not applicable – just a warning
    Error 3
    Dialog -  An error occurred while accessing application id ProjectServerApplication
    from Secure Store Service. The following connection failed to refresh:
    Project Server - Simple Projects List
    ULS -
    • w3wp.exe (0x230C) 0x2344 Secure Store Service Secure Store elm4 High SQL command failed: Sproc name: dbo.proc_sss_GetCredentials, Application Id: ProjectServerApplication, Error code: 80630490, Error message: Target application not found (application id: ProjectServerApplication).
    • w3wp.exe (0x230C) 0x2344 Secure Store Service Secure Store 7493 Critical The Microsoft Secure Store Service application Secure Store Service failed to retrieve credentials. The error returned was 'Target application not found (application id: ProjectServerApplication).'. For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK).
    • w3wp.exe (0x230C) 0x2344 Secure Store Service Secure Store efp4 Monitorable GetCredentials failed with the following exception: System.ServiceModel.FaultException`1[Microsoft.Office.SecureStoreService.Server.SecureStoreServiceTargetApplicationNotFoundFault]: Target application not found (application id: ProjectServerApplication). (Fault Detail is equal to Microsoft.Office.SecureStoreService.Server.SecureStoreServiceTargetApplicationNotFoundFault).
    • w3wp.exe (0x230C) 0x21C0 Excel Services Application Web Front End 4969 Warning SSS has failed with the following exception: Target application not found (application id: ProjectServerApplication). [Session stuff here...]
    Error 4
    Dialog - Same as Error 3.
    ULS -
    • w3wp.exe (0x1BF8) 0x09A8 Secure Store Service Secure Store elm4 High SQL command failed: Sproc name: dbo.proc_sss_GetCredentials, Application Id: ProjectServerApplication, Error code: 80630001, Error message: Credentials were not found for the current user within the target application 'ProjectServerApplication'. Please set the credentials for the current user.
    • w3wp.exe (0x1BF8) 0x09A8 Secure Store Service Secure Store 7493 Critical The Microsoft Secure Store Service application Secure Store Service failed to retrieve credentials. The error returned was 'Credentials were not found for the current user within the target application 'ProjectServerApplication'. Please set the credentials for the current user.'.
    • w3wp.exe (0x1BF8) 0x09A8 Secure Store Service Secure Store efp4 Monitorable GetCredentials failed with the following exception: System.ServiceModel.FaultException`1[Microsoft.Office.SecureStoreService.Server.SecureStoreServiceCredentialsNotFoundFault]: Credentials were not found for the current user within the target application 'ProjectServerApplication'. Please set the credentials for the current user. (Fault Detail is equal to Microsoft.Office.SecureStoreService.Server.SecureStoreServiceCredentialsNotFoundFault).
    • w3wp.exe (0x1BF8) 0x12A8 Excel Services Application Web Front End 4969 Warning SSS has failed with the following exception: Credentials were not found for the current user within the target application 'ProjectServerApplication'. Please set the credentials for the current user. [Session info here…]
    • w3wp.exe (0x1BF8) 0x12A8 Excel Services Application External Data 3238 Information Unable to establish a connection using credentials retrieved from SSS. This could be because the Unattended Service Account is not configured or because the credentials retrieved from SSS are not valid. [Session info here…]
    Error 5
    Dialog - Access was denied by the external data
    source. The following connections failed to refresh:
    Project Server - Simple Projects List
    ULS -
    • w3wp.exe (0x1BF8) 0x242C Secure Store Service Secure Store efr5 High ValidateCredentialClaims - Access Denied: Claims stored in the credentials did not match with the group claim for a group app.
    • w3wp.exe (0x1BF8) 0x242C Secure Store Service Secure Store 7493 Critical The Microsoft Secure Store Service application Secure Store Service failed to retrieve credentials. The error returned was 'Access is denied.'. For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK).
    • w3wp.exe (0x1BF8) 0x242C Secure Store Service Secure Store efp4 Monitorable GetCredentials failed with the following exception: System.ServiceModel.FaultException`1[Microsoft.Office.SecureStoreService.Server.SecureStoreServiceFault]: Access is denied. (Fault Detail is equal to Microsoft.Office.SecureStoreService.Server.SecureStoreServiceFault).
    • w3wp.exe (0x1BF8) 0x12A8 Excel Services Application Web Front End 4969 Warning SSS has failed with the following exception: Access is denied. [Session stuff here]
    • w3wp.exe (0x1BF8) 0x12A8 Excel Services Application External Data 3238 Information Unable to establish a connection using credentials retrieved from SSS. This could be because the Unattended Service Account is not configured or because the credentials retrieved from SSS are not valid. [Session stuff here...]

    Error 6
    Dialog – Same as Error 3.
    ULS -
    • w3wp.exe (0x230C) 0x2344 Excel Services Application Excel Calculation Services 7mor Medium TrustedLocationCacheNode.Find: Found a uri that does not belong to any defined trusted location: https://brismith8100.redmond.corp.microsoft.com/PWA/ProjectBICenter/Sample%20Reports/English%20(United%20States)/SimpleProjectsList.xlsx
    • w3wp.exe (0x230C) 0x2344 SharePoint Server Logging Correlation Data xmnv Medium Result=Id=OpenWorkbookLocationNotTrusted; Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. at Microsoft.Office.Excel.Server.CalculationServer.Session.OpenWorkbookAsync(AsyncHandler`1 callback, Object userState, Request request, Uri url, Boolean loadedOnDemand)…
    • w3wp.exe (0x230C) 0x2344 Excel Services Application Excel Calculation Services ech0 Medium ExcelService.PostProcessRequest: web method: OpenWorkbook, got exception Id=OpenWorkbookLocationNotTrusted; Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. at Microsoft.Office.Excel.Server.CalculationServer.Session.OpenWorkbookAsync(AsyncHandler`1 callback, Object userState, Request request, Uri url, Boolean loadedOnDemand)…
    • w3wp.exe (0x230C) 0x2344 Excel Services Application Excel Calculation Services 2017 Information Failed to load 'https://brismith8100.redmond.corp.microsoft.com/PWA/ProjectBICenter/Sample%20Reports/English%20(United%20States)/SimpleProjectsList.xlsx' with error: 'The workbook is not in a trusted location.'. [Session stuff here...]
  • Brian Smith's Microsoft Project Support Blog

    How to tell which Cumulative Update, Hotfix or Service Pack version of Project Server 2010 and Project 2010 you are running

    • 7 Comments

    I’ll get this information into a KB article too, and I’ll also try and keep this posting up to date as we release each cumulative update or service pack for Project Server 2010 and Project 2010.  If you are not reading this at http://blogs.msdn.com/b/brismith then you may be reading out of date information!

    The version can be different depending where you look, so I will tabulate the version you will see in Control Panel, Programs and Features (binary version) or on the individual binaries – which is also listed in Central Administration under Upgrade and Migration, Check Product and Patch Installation Status – and also the version you will see in the databases.  I’ll mention too various other components that might be of interest.  I have listed just the Project Server KB for the CU – but the DB Version noted for SharePoint assumes that either a SharePoint Server or Server rollup has also been installed.

    As a reminder to get the version from the database there is a table in each SharePoint DB, and each Project Server DB called Versions so a query such as the following will return the current version, which will be the highest Version next to the NULL GUID. 

    USE <PROJECTSERVERNAME>_Published

    SELECT * FROM Versions

    WHERE VersionId ='00000000-0000-0000-0000-000000000000'

    Project Server 2010

    Release Binary Version DB Version KB
    Initial Release 14.0.4763.1000 Project - 14.0.4750.1000
    SharePoint - 14.0.4762.1000
     
    June 2010 CU 14.0.5114.5003 – See KB for individual binary versions – KB will show in Installed Updates Project - 14.0.5114.5000
    SharePoint - 14.0.5114.5000
    KB 2075990
    August 2010 CU 14.0.5123.5000
    See KB for individual binary versions – KB will show in Installed Updates
    Project - 14.0.5114.5000 (no change from June)
    SharePoint – 14.0.5123.5000
    KB 2276341
     October 2010 CU  14.0.5126.5003 Re-released - See KB for individual binary versions – KB will show in Installed Updates Project - 14.0.5114.5000 (still no change from June)
    SharePoint – 14.0.5128.5000
     KB 2394322
     December 2010 CU  14.0.5130.5000  See KB for individual binary versions.  KB will show in installed updates

     Project - 14.0.5130.500

     SharePoint 14.0.5130.5002

     KB 2459258

    February 2011 CU

    14.0.5136.5000
    See KB for individual binary versions.  KB will show in installed updates

    Project – 14.0.5135.5000

    SharePoint -
    14.0.5136.5002

    KB 2475879

    April 2011 CU

    14.0.5138.5000
    See KB for individual binary versions.  KB will show in installed updates

    Project – 14.0.5137.5000

    SharePoint -
    14.0.5138.5001

    KB 2512801

    June 2011 CU

    14.0.6106.5002
    See KB for individual binary versions.  KB will show in installed updates

    Project – 14.0.6105.5000

    SharePoint -
    14.0.6106.5002

    KB 2536600

    If you load Service Pack 1 for Project Server 2010 then you will see Versions of 14.0.6027.1000 for Project and 14.0.6029.1000 for SharePoint.  If you loaded June CU at the same time and did not run the SharePoint Configuration Wizard between loading the SP and the CU then you will just see the latest - the 6105.5000 and 6106.5002 from the table above.

    Project 2010

    Details from Control Panel, Programs and Features, and also the Backstage (File, Help tab), both the main version displayed, and the additional version information.

    Release Binary Version KB
    Initial Release Control Panel - 14.0.4763.1000
    BackStage – 14.0.4760.1000
    Under Additional Versions and Copyright Information – Microsoft Project 2010 (14.0.4751.1000) MSO(14.0.4760.1000)
    MSO may be different depending on other Office KBs installed
     
    June 2010 CU KB 2075992 will show in installed updates
    BackStage – 14.0.4760.1000
    Under Additional Versions and Copyright Information – Microsoft Project 2010 (14.0.5112.5000) MSO(14.0.4760.1000)
    MSO may be different depending on other Office KBs installed
    KB 2075992
    August 2010 CU NA – No client release for August.  MSO may change if other Office updates loaded NA
     October 2010 CU

     KB 2413663 will show in installed updates.  Backstage 14.0.5128.5000.  Under Additional Versions and Copyright Information – Microsoft Project 2010 (14.0.5126.5000) MSO(14.0.5128.5000)
    MSO may be different depending on other Office KBs installed

     

     KB 2413663
     December 2010 CU  KB 2466263 will show in installed updates.  Backstage (File, Help) 14.0.5128.5000.  Under Additional Versions and Copyright Information – Microsoft Project 2010 (14.0.5130.5000) MSO(14.0.5128.5000)
    MSO may be different depending on other Office KBs installed
     KB 2466263
    February 2011 CU KB 2496946 will show in installed updates.  Backstage (File, Help) 14.0.5128.5000.  Under Additional Versions and Copyright Information – Microsoft Project 2010 (14.0.5130.5000) MSO(14.0.5128.5000)
    MSO may be different depending on other Office KBs installed
    KB 2496946
    April 2011 CU KB 2516479 will show in installed updates.  Backstage (File, Help) 14.0.5137.5000.  Under Additional Versions and Copyright Information – Microsoft Project 2010 (14.0.5137.5000) MSO(14.0.5128.5000)
    MSO may be different depending on other Office KBs installed
    KB 2516479
    June 2011 CU KB 2536590 will show in installed updates.  Backstage (File, Help) 14.0.6023.1000.  Under Additional Versions and Copyright Information – Microsoft Project 2010 (14.0.6106.5000) MSO(14.0.6023.1000)
    MSO may be different depending on other Office KBs installed - 6023.1000 relates to SP1 in this example.
    KB 2536590

    Cumulative Update Release Posts

    June 2010 - http://blogs.technet.com/b/projectadministration/archive/2010/07/22/microsoft-project-server-and-sharepoint-2010-june-cu-2010-are-live.aspx

    August 2010 - http://blogs.technet.com/b/projectadministration/archive/2010/09/02/microsoft-project-server-and-sharepoint-2007-and-2010-august-cu-2010-are-live.aspx

    October CU - http://blogs.technet.com/b/projectadministration/archive/2010/10/27/microsoft-project-server-and-sharepoint-2007-and-2010-october-cu-2010-are-live.aspx

    December CU - http://blogs.technet.com/b/projectadministration/archive/2010/12/15/microsoft-project-server-and-sharepoint-2007-and-2010-december-cu-2010-are-mostly-live.aspx 

    February 2011 CU - http://blogs.technet.com/b/projectadministration/archive/2011/02/24/microsoft-project-server-and-sharepoint-2007-and-2010-february-cu-2011-are-live.aspx

    April 2011 CU - http://blogs.technet.com/b/projectadministration/archive/2011/04/29/microsoft-project-server-and-sharepoint-2007-and-2010-april-cu-2011-are-live.aspx

    SP1 - http://blogs.msdn.com/b/project/archive/2011/06/28/announcing-the-release-of-service-pack-1-sp1-for-microsoft-project-and-project-server-2010.aspx

    June 2011 CU - http://blogs.technet.com/b/projectadministration/archive/2011/08/22/microsoft-project-server-and-sharepoint-2007-and-2010-june-cu-2011-announcement.aspx

    Links to all the Cumulative Update Webcasts, and other great update links can be found at http://technet.microsoft.com/en-US/projectserver/gg176680.aspx

  • Brian Smith's Microsoft Project Support Blog

    Project Server 2010: Applied August CU and having problems with JSGrid?

    • 13 Comments

    Thanks to Donald for his forum posting and Marius for his swift response highlighting the resolution to this one.  If you have loaded the August CU for Project Server 2010 – KB 2276341, but have not loaded either the SharePoint Foundation 2010 August CU (KB 2266423), or any of the rollup packages (KB 2352346, KB 2352342 or KB 2352345) then you will get an error loading the schedule web part and drilling down into a project - or other pages that us the JSGrid.  The error will be this one: “The view failed to load.  Press OK to reload this view with the default settings.  Press Cancel to select another view.”  Neither will resolve the problem.

    image

    As there can be many other potential reasons for this error you should also check the ULS logs – and confirmation of this problem is seeing this error:

    • w3wp.exe (0x14D8)                           0x11C0    Project Server                    General                           0000    Exception    Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.Project.ProjectGetProjectDetailsForGridJson System.MissingMethodException: Method not found: 'Void Microsoft.SharePoint.JSGrid.GridSerializer.ApplyPostViewIncrementalInsertsAndDeletes(System.Collections.Generic.IEnumerable`1<Microsoft.SharePoint.JSGrid.Change>, System.Func`2<System.Object,System.Collections.Generic.Dictionary`2<System.String,System.Object>>)'.     at Microsoft.Office.Project.Server.BusinessLayer.Project.GetProjectDetailsForGridJson(JsGridSerializerArguments gridSerializerArgs, Guid projUid, Guid[] subProjUids, Int32 storeId, String changesJson, String postViewInsertsAndDeletesJson, Boolean firstTaskViewLoad, Boolean showProjectSummaryTask, Guid viewUid, Nullable`1 expandSubprojects, Boolean clearPer...   

    The resolution is to load one of the August CUs that contains sts-x-none.msp, which would be any of the following.

    Although JSGrid is a component initially developed for Project Server 2010 it was shared with other teams for the “14” release and is also used by Access Services.  It is shipped as part of SharePoint Foundation, and this is where we slipped up in not also having the fix in the Project Server CU too.  Apologies for any inconvenience this may have caused, and we will ensure with future CUs that this dependency will be avoided. 

    Technorati Tags: ,
  • Brian Smith's Microsoft Project Support Blog

    How to determine if you have Project Standard or Project Professional

    • 5 Comments

    This is a question that often comes up internally, and is certainly easy to answer if you are looking at the software, particularly with the differences between Standard and Professional in 2010 (see the Version Comparison), but the question usually relates to software audits when companies are trying to find out what is deployed.  The project executable is always going to be winproj.exe so no clue there, but the registry will give the answer.  There is a KB article that documents the entries you need to look for and what they mean - http://support.microsoft.com/kb/928516 and this is the 2007 version (hopefully an update coming soon, but the codes for Project Standard and Professional are still applicable to 2010.

    As an example in the HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall on my machine I have 90140000-003B-0000-1000-0000000FF1CE} – where this can be broken down in to the following pieces - {BRMMmmmm-PPPP-LLLL-p000-D000000FF1CE}.  Open to KB if you want to follow along with my decoding:

    This would indicate that I have

    B is Release Version 9 (RTM),

    R is Release type 0 (Volume license)

    MM is the major version 14 (Office 2010)

    mmmm is the minor version - 0

    PPPP is my Product ID 003B, (Project Professional)

    LLLL is the language identifier 0000 (I might have expected 0409 there, which would be 1033 en-US – but perhaps this indicates the language neutral core of Office 2010…)

    p is 1 – which indicate x64

    000 is reserved for future use

    D is 0 which means a ship build rather than debug.

    000000FF1CE is the Office Family ID (lucky we can do that with the HEX codes!)

    Although the 2007 document suggested that these keys would be in the HKEY_LOCAL_MACHINE\Software\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall on an x64 operating system I am assuming this relates to non-x64 Office versions – as my Project keys were in HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall on my Windows 2008 R2 SP1 server.

    The only difference if I had x64 Standard would be 003A in place of 003B.  So using your audit tools of choice you would be able to count up your Standard and Professional desktops.

  • Brian Smith's Microsoft Project Support Blog

    Project Server 2010: Scheduling on the Web, the PSI and Project Professional

    • 1 Comments

    There is an excellent article on the Web-based capabilities of Project 2010 at http://www.microsoft.com/project/en/us/project-server-2010-editions.aspx which does a schedule management comparison of Project Web App (PWA) 2010 compared to Project Professional 2010.  The comparison chart is available as a download, and has six pages of bullet points detailing what works in both PWA and Project Professional, what has some limitations in PWA and what can only be done in Project Professional.

    image

    I wanted to give a couple of examples that relate to the limitations section, and some of the less obvious behaviors you can run in to.  You should also assume that many (but not all) of the limitations with PWA may also be limitations when using the PSI.  See the SDK for more detail at “What the PSI Does and Does Not Do”.

    First I’ll talk about cost resources.  From the document above we have this statement, which labels this feature as Limited or Read-Only for PWA:

    Cost and Material Resource Assignments
    Ability to assign Cost Resources or Material Resources to tasks (NOTE: assignments cannot be made in the web but previous
    assignments from Project Professional 2010 are available as Read-Only.)

    In PWA this is handled well, and if you try and assign a cost resource, or edit a task that has a cost resource assigned then you will get a message: “Scheduling Warning: You cannot edit tasks with cost, material or budget resources while using Project Web App.  If you wish to make this change, open your project using Project Professional. Your last edit has been undone.” Yours will probably be a different color – my current theme is “Laminate”.

    image

    However, the same issue can have other less expected consequences.  If you have a project template that contains an assignment to a cost resource, and this template is set as the template to be used for a specific Enterprise Project Type (EPT), then if you try and create a new project of this type through PWA it will fail to publish.  The message you get will be: “Your new EPTWithCostResource has been created successfully, but failed to publish and will not be listed in the Project Center.” where the phrase EPTWithCostResource will be the name of your EPT.

    image

    Going to the queue you will find a Project Create job with failed and blocking correlation.  The project name will be NA, as it cannot find it referenced in the database, and viewing the error details will give you:

      • Datasets:
      • ProjectDataSet
      • Table Assignment
      • Row: ASSN_UID='bf66c711-97a1-4a31-9d49-fa827763a483' PROJ_UID='4d09fd45-0eb3-4641-aedd-5e70fe539ee3'
      • Error AssignmentInvalidOwner (139) - column RES_UID_OWNER
    • General
    • Queue:
    • GeneralQueueJobFailed (26000) - ProjectCreate.ProjectAddToMessage. Details: id='26000' name='GeneralQueueJobFailed' uid='e97c84bb-d679-4958-b616-7f7782bc3cd3' JobUID='08991866-6a13-4639-9dd0-1770e57550b4' ComputerName='BRISMITH8100' GroupType='ProjectCreate' MessageType='ProjectAddToMessage' MessageId='1' Stage=''. For more details, check the ULS logs on machine <servername> for entries with JobUID 08991866-6a13-4639-9dd0-1770e57550b4.

    So it hasn’t just failed to publish, the Project Create job has failed. This project will not exist on the server.  This is because as well as the editing of cost resources in PWA being blocked, the creation through PWA of tasks with cost resources assigned will not work.  The workaround would be to create the project in Project Professional.  If you wanted to use a workflow with this project then you can use the Server Settings option to change or restart workflows.

    The SDK article referred to above has this to say about cost resources and the PSI:

    Cost Resources
    • Editing, creating, or deleting cost resources and assignments using the Project methods. The Resource methods can create cost resources but cannot edit them.

    One feature that is only supported using Project Professional is editing of assignment fields.  This has caught me out a couple of times when I have opened a plan to edit it in PWA and it has been read-only.  It was because I had the view set to Assignments Summary last time I was looking at a drill-down view in Project Center.  This screen-shot also helps to explain the “AssignmentInvalidOwner” error from the queue, as the Cost Resource has no Assignment Owner – and also shows this project has been submitted to the “Sample Proposal” workflow after being created in Project Professional.

    image

    Finally Inactive Tasks. 

    Inactive Tasks
    Mark a task as inactive. (Note: In PWA, tasks marked as inactive in Project Professional 2010 are Read-Only.)

    These display in PWA, but you cannot make a task inactive through PWA.  I have been recently playing around with inactive tasks and the PSI and found that it is possible to set a task to Inactive (setting TASK_IS_ACTIVE = false) but it is only reliable if this is the only change made.  If you also change the task name then the Inactivation doesn’t hold.  This is one consideration when using the PSI when scheduling changes will happen as a result – and this could relate to many of the items listed in the comparison document with the “Limited” icon.  If you are seeing some behavior that you are not expecting then try just making a change to a single property at a time (this appears to be the case for TASK_IS_INACTIVE at the task level and Assignment Owner – RES_UID_OWNER at the assignment level).  In Project Professional the changes you make are sequential and the scheduling engine works on them as such – even if recalculating later – but when you submit updates to the PSI in a QueueUpdateProject dataset there is not the same flow of changes so you can get results you might not expect.  If you do then take a step back and rather than trying to fight the server scheduling engine just feed the changes in a different way and you may get the results you are looking for.  Of course there may just be situations that are unsupported – and these are documented in the SDK link above.

    Technorati Tags: ,
Page 1 of 3 (11 items) 123