Project Server Queue Errors

Project Server Consulting – Project Server 2013 – Project Server Support – Project Server Queue

Folks,

Here are a few Project Server Queue Errors related to Generic Resources on Templates that either are local and duplicates or have a Default Assignment Owner value and they should not.  We hope you find this helpful.  Let us know your thoughts.  This is how PPM Works…

Sample Error #1: 
Job State:  Failed And Blocking Correlation
Error:  rsResourceCannotAddLocalWithSameNameAsEnterprise (2058) – column RES_UID
Screenshot:

Resolution:  Make sure that your project and your project template do not have local and enterprise resources with the same name.  This particular issue had local resources in a Project Template with the same name as an Enterprise Generic Resource.

The Why:  This scenario occurs when a user tries to create a project based on a template that has a local resource with the same name as an Enterprise Work Resource.  Be careful when creating Enterprise templates and use the best practice steps while Building the Team.  Note you should not have Local Resources in Enterprise Templates.

Queue Error:
Datasets:

• ProjectDataSet
  • Table ProjectResource
    • Row: RES_UID=’0e247469-7d81-e411-80dd-0050569b1b2d’ PROJ_UID=’8c237469-7d81-e411-80dd-0050569b1b2d’

• Error rsResourceCannotAddLocalWithSameNameAsEnterprise (2058) – column RES_UID
• Table Assignment
  • Row: ASSN_UID=’64247469-7d81-e411-80dd-0050569b1b2d’ PROJ_UID=’8c237469-7d81-e411-80dd-0050569b1b2d’
    • Error AssignmentInvalidOwner (139) – column RES_UID_OWNER
• Table TaskCustomFields
  • Row: CUSTOM_FIELD_UID=’fe247469-7d81-e411-80dd-0050569b1b2d’
    • Error TaskNotFound (7021) – column

General

• GeneralQueueException:
  • GeneralQueueException (9131). Details: id=’9131′ name=’GeneralQueueException’

Sample Error #2: 

Job State:   Failed And Blocking Correlation
Error:  AssignmentInvalidOwner (139) – column RES_UID_OWNER
Screen shot:

Resolution:  Confirm that all Generic Resources do not have a Default Assignment Owner and/or Timesheet Manager.  If they have either a Default Assignment Owner or Timesheet Manager – try opening and deleting these values and then save the generic resource.  If you can not change the values for the Default Assignment Owner and/or the Timesheet Manager then you will need to delete the resource and recreate it.  I recommend that you go into the Template and Copy the Resource Names Column into a Text Column and then delete the resource from the template and the Enterprise.  Make sure when creating the generic resource to mark it as generic BEFORE you save the resource.

The Why:  This scenario occurs when a user tries to create a project based on a template that has an Enterprise Work Resource(s) with a value for either the Default Assignment Owner or the Timesheet Manager.  This scenario make occur if a resource is created first as non-generic and then set to Generic.  This could have happened accidentally.  Be careful when creating generic resources using the Global Enterprise Template.  Make Sure to set the resource as generic BEFORE you hit save.  Do this for all generic resources that you are created PRIOR to saving.

Queue Error:
Datasets:

• ProjectDataSet
  • Table Assignment
    • Row: ASSN_UID=’2ae0397d-7d81-e411-80dd-0050569b1b2d’ PROJ_UID=’52df397d-7d81-e411-80dd-0050569b1b2d’

• Error AssignmentInvalidOwner (139) – column RES_UID_OWNER

General

• Queue:
  • GeneralQueueJobFailed (26000) – ProjectCreate.ProjectAddToMessage. Details: id=’26000′ name=’GeneralQueueJobFailed’

Open each job that is in the state ‘Failed and Blocking Correlation’ – if they are one of the two errors and you have fixed your template and successful run a test, then you should cancel these jobs.  Screen shot below:

A good reference for Project Server 2013 Error Codes is:  http://msdn.microsoft.com/en-us/library/office/ms508961(v=office.15).aspx

Are you experiencing this issue and the above did not help?  If so you may want to read Brian Smith’s post:  http://blogs.msdn.com/b/brismith/archive/2010/09/10/project-server-2010-scheduling-on-the-web-the-psi-and-project-professional.aspx?wa=wsignin1.0

PPM Works is a full service Microsoft Project and Portfolio Management consultancy, focused on Microsoft Project Server and Microsoft SharePoint platforms.  We believe in partnering with our clients to exceed expectations and build long lasting rewarding partnerships. We are continuously building a knowledge base of multiple tips, tricks and solutions to make your use of Microsoft Project Pro as quick and easy as possible. Contact us for more information.

Stay updated with the latest of Project Online/Server 2013 with us: Subscribe. Check our future events!

Subscribe to our webcast email list for updates on our upcoming webinars! 

Visit our FAQ Page for access to our tool box.