Loading...
Quick Links

PS2013 – Project Publish Failure – UpdateSRAMessage – SummaryResourceAssignment

Home Forums Discussion PS2013 – Project Publish Failure – UpdateSRAMessage – SummaryResourceAssignment

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #350107 Reply
    Paul Lor
    Guest

    Hi all,

    I’ve been battling a project publishing issue for a couple of months now and I’m desperately in need of help! I’ve seen very similar issue in 2010 while researching for a resolution.

    social.technet.microsoft.com/Forums/projectserver/en-US/0f56d5cc-20ec-404c-9b1b-8c7f1245b538/publish-failure-93?forum=projserv2010setup

    Initially in our first step, we had identified the resources who were causing errors in the ULS logs and deleted those records when we failed to publish a project schedule.

    E.g. Level: Product: Project Server, Category: Project Server & Level: Unexpected

    Message from ULS Log:
    Node Consistency Message: Exception Recreating Server Level Summary Resource Assignment. ResUid=bc1fe81c-1558-e311-93f7-005056a212ba
    Node Consistency Message: Error Updating Summary Resource Assignment. ProjUid=c0cf864b-8200-e411-93fc-005056a212ba, ResUid=625cf762-599e-e311-93f9-005056a212ba

    We ran a query to delete the associated resource (ResUID)

    DELETE *
    FROM PUB.MSP_ASSN_ENTERPRISE
    WHERE RES_UID = ‘####################################’

    Two types of messages that directly relate when a project fail to publish. This still did not resolve the publishing issue as more resources were identified as “corrupted” SRA records.

    Finally in our second step, we delete all SRA records, knowing that they would be recreated when a project schedule publishes. This has helped some project schedule to publish more successfully but there are a small handful that continue to fail even though the SRA records were deleted.

    General

    Microsoft.Office.Project.Server.BusinessLayer.Queue.Message:
    ProjectPublishFailure (23000). Details: id=’23000′ name=’ProjectPublishFailure’ uid=’c5f3ccc8-500a-e511-9408-005056a212ba’ projectuid=’f57a6790-3ab4-e311-93fa-005056a212ba’ messagetype=’Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.UpdateSRAMessage: projectUid = f57a6790-3ab4-e311-93fa-005056a212ba’ messageID=’33’ stage=” blocking=’Block’.

    Queue:
    GeneralQueueJobFailed (26000) – ProjectPublish.UpdateSRAMessage. Details: id=’26000′ name=’GeneralQueueJobFailed’ uid=’c6f3ccc8-500a-e511-9408-005056a212ba’ JobUID=’5da84ab8-500a-e511-953c-a4db3022301d’ ComputerName=’24871cfb-c910-4046-8964-595d7868d55c’ GroupType=’ProjectPublish’ MessageType=’UpdateSRAMessage’ MessageId=’33’ Stage=” CorrelationUID=’5ae20c9d-bb12-d007-8d55-c1dcf2cb0765′. For more details, check the ULS logs on machine 24871cfb-c910-4046-8964-595d7868d55c for entries with JobUID 5da84ab8-500a-e511-953c-a4db3022301d.

    Question: What can I do to resolve this publishing issue?

    Thank you, any recommendations or advice is greatly appreciated. Project Server 2013 – September 2014 CU

    #350269 Reply
    Larry Christofaro
    Participant

    Paul, difficult question for this forum. You seem like you’ve done a lot of research already with no success. If you don’t get an answer here I might suggest:
    1. Post it one of the TechNet project forums: https://social.technet.microsoft.com/Forums/projectserver/en-US/home?category=project. Maybe the Project Server – Setup, Upgrade, Administration and Operation forum.
    2. Submit help from Microsoft

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: PS2013 – Project Publish Failure – UpdateSRAMessage – SummaryResourceAssignment
Your information:




+ 61 = 64