none
ReportingProjectChangeMessageFailed (24006) - Queue service RRS feed

  • Question

  • Hello,

    Starting a few days ago we started getting random errors when attempting to check in/publish projects within PWA/PS2013

    • ReportingProjectChangeMessageFailed (24006) - Queue service identity does not have enough permissions to be able to write to the project server database. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='8947b6f6-58df-e611-9a96-005056812e21' QueueMessageBody='Project UID='60d130da-58df-e611-b0b5-0050b6c0de1b'. PublishType='ProjectPublish'' Error='Queue service identity does not have enough permissions to be able to write to the project server database'. 

    From what we can tell so far, it seems to happen to projects that have been using a specific project template. 

    In addition, these errors also contain a (26000) as well

    • Queue:
      • GeneralQueueJobFailed (26000) - ReportingSummaryPublish.ReportSummaryProjectPublishMessageEx. Details: id='26000' name='GeneralQueueJobFailed' uid='626d1030-51df-e611-9a96-005056812e21' JobUID='9cf29429-51df-e611-9a96-005056812e21' ComputerName='dcd53064-da1f-4eaf-a979-5c9af11d5561' GroupType='ReportingSummaryPublish' MessageType='ReportSummaryProjectPublishMessageEx' MessageId='1' Stage='' CorrelationUID='bffccc9d-0421-d055-d556-125ccb502546'. For more details, check the ULS logs on machine dcd53064-da1f-4eaf-a979-5c9af11d5561 for entries with JobUID 9cf29429-51df-e611-9a96-005056812e21

    I was hoping to get some possible direction and searching around hasn't netted much.

    Thank You in advance for the help.

    Friday, January 20, 2017 9:51 PM

Answers

  • Does the account under which the "Project Server Queue Service" have the correct permissions on the Reporting DB? that's what the error message seems to point to.


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    • Marked as answer by GJM777 Monday, January 23, 2017 9:52 PM
    Sunday, January 22, 2017 12:06 AM
    Moderator
  • I ended up giving the service account sysadmin role just to test, and also restarted the queue service, and it appeared to fix the issue.

    I'm not quite sure what happened here but hopefully this will help someone in the future. Thanks everyone for the help.

    • Marked as answer by GJM777 Monday, January 23, 2017 9:52 PM
    Monday, January 23, 2017 9:48 PM

All replies

  • Does the account under which the "Project Server Queue Service" have the correct permissions on the Reporting DB? that's what the error message seems to point to.


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    • Marked as answer by GJM777 Monday, January 23, 2017 9:52 PM
    Sunday, January 22, 2017 12:06 AM
    Moderator
  • Did the projects are made from other templates save and publish successfull? 

    maybe this is corrupt template, try to save a new one and publish a project from it.

    Maybe you somewhere used a sub-projects and then this option was denied? 

    Monday, January 23, 2017 9:14 AM
  • I will take a look at the perms, however I'm not sure how they would have suddenly changed.

    As for the template, yes our other templates seem to publish without issue, I've since deleted the existing(possibly corrupt) one for now to avoid issue.

    I'll post back with findings, thank you for the suggestions so far.

    Monday, January 23, 2017 5:57 PM
  • I ended up giving the service account sysadmin role just to test, and also restarted the queue service, and it appeared to fix the issue.

    I'm not quite sure what happened here but hopefully this will help someone in the future. Thanks everyone for the help.

    • Marked as answer by GJM777 Monday, January 23, 2017 9:52 PM
    Monday, January 23, 2017 9:48 PM