none
Multiple 'Reporting (Project Sync)' entries in Queue Jobs RRS feed

  • Question

  • We have a Project Server 2013 implementation that includes around 30 projects. We found, that "randomly" several entries of the job type 'Reporting (Project Sync)' are submitted at the same time (within a few minutes) into the queue. The exact number seems to depend on the project, and varies typically between 20 and a few hundred entries. All of the entries are processed successfully, but I am not sure, if that behavior is by-design.

    If it is not, what can be the cause of the malfunction? I have not found any queue-related error in the ULS logs (that are rather large, > 100 MB even with standard logging settings, when these entries are processed) / Windows log.

    Note: If a project is published, only a single entry of the job type 'Reporting (Project Sync)' is submitted to the queue, and the job entry has an Owner. In the other, "random" cases, the entries have no Owner at all.

    We have a front end server and an application server in the farm, the queue runs on the application server. If I enable verbose logging, the ULS log of the front end server is full with these entries (Area: Project Server, Category: Queue) as the jobs being inserted in the queue:

    PWA:http://ProjectServer/PWA, ServiceApp:ProjectServerApplication, User:PROJECTSERVER\system, PSI: [QUEUE] [SENDER] queue id ProjectQ: BeginMessageGroup(group id 47463124-c2e8-e411-80e5-005056b44e34, correlation id 30eedb25-66d1-e411-80e4-005056b44e34, message type ReportingWSSSync, priority MediumLowPriority): JobUID: 43463124-c2e8-e411-80e5-005056b44e34 Project:30eedb25-66d1-e411-80e4-005056b44e34 Job:43463124-c2e8-e411-80e5-005056b44e34
    PWA:http://ProjectServer/PWA, ServiceApp:ProjectServerApplication, User:PROJECTSERVER\system, PSI: [QUEUE] [SENDER] ProjectQ: Send( ProjectUID='30eedb25-66d1-e411-80e4-005056b44e34'. ForceFullSync='False'. SynchronizationType='Documents' ): ID: 1 GroupUID: 47463124-c2e8-e411-80e5-005056b44e34 Project:30eedb25-66d1-e411-80e4-005056b44e34 Job:43463124-c2e8-e411-80e5-005056b44e34
    PWA:http://ProjectServer/PWA, ServiceApp:ProjectServerApplication, User:PROJECTSERVER\system, PSI: [QUEUE] [SENDER] ProjectQ: EndMessageGroup(): GroupUID: 47463124-c2e8-e411-80e5-005056b44e34 Project:30eedb25-66d1-e411-80e4-005056b44e34 Job:43463124-c2e8-e411-80e5-005056b44e34
    PWA:http://ProjectServer/PWA, ServiceApp:ProjectServerApplication, User:PROJECTSERVER\system, PSI: successfully sent 1 job notifications to queue for site a04adc6f-5a3f-4209-9549-e3b28389df43 Project:30eedb25-66d1-e411-80e4-005056b44e34 Job:43463124-c2e8-e411-80e5-005056b44e34

    Thanks a lot for any idea in advance!

    Regards,
    Peter


    • Edited by Peter Holpar Wednesday, April 22, 2015 9:44 AM Extended with furher details
    Tuesday, April 21, 2015 1:21 PM

Answers

  • I see that this is an oldish thread, but I think I figured out what's happening.

    The Reporting (Project Sync) job should be kicked off for Issues, Risks, and Documents (basically SharePoint Project Site items that publish to the PS Reporting Database) when you PUBLISH your schedule only.

    However, I've been able to repro the following scenario:

    Open the project associated with the site in Project Pro.  Publish.  Leave the project open.

    Until you check-in that project, all subsequent changes will kick off a Reporting (Project Sync) job in the queue.  I can tell that's what's causing it by refreshing the document data from the MSP_WssDocuments table in the reporting section of the database.

    This is a real problem when you have OneNote documents on the site which auto synchronize all pages as individual documents with new modified dates.  I will be submitting this to MS as a bug - and until then, working with our PMs to make sure they check in their projects once they have completed their updates.

    Hope this helps! 


    Elli J Project Solutions Specialist Blog: http://projectserverpants.wordpress.com/

    Tuesday, December 15, 2015 11:55 PM

All replies

  • We are seeing the same behavior and would like advice as well.

    Cheers,

    Garreth

    Thursday, June 4, 2015 3:48 PM
  • I see that this is an oldish thread, but I think I figured out what's happening.

    The Reporting (Project Sync) job should be kicked off for Issues, Risks, and Documents (basically SharePoint Project Site items that publish to the PS Reporting Database) when you PUBLISH your schedule only.

    However, I've been able to repro the following scenario:

    Open the project associated with the site in Project Pro.  Publish.  Leave the project open.

    Until you check-in that project, all subsequent changes will kick off a Reporting (Project Sync) job in the queue.  I can tell that's what's causing it by refreshing the document data from the MSP_WssDocuments table in the reporting section of the database.

    This is a real problem when you have OneNote documents on the site which auto synchronize all pages as individual documents with new modified dates.  I will be submitting this to MS as a bug - and until then, working with our PMs to make sure they check in their projects once they have completed their updates.

    Hope this helps! 


    Elli J Project Solutions Specialist Blog: http://projectserverpants.wordpress.com/

    Tuesday, December 15, 2015 11:55 PM
  • Afte further study, I think it's likely that in 2013 this job always runs when you make updates to a document on the site of a published project.  I was testing this in our test environment where we have a lot of projects that were not published after we upgraded to 2013.  In our prod environment, we only had one project which had a project site that wasn't published and it threw off my troubleshooting.

    We had a crash in the queue yesterday that brought this to my attention, but in general these jobs seem to go very quickly and do no harm.  I will continue to monitor in my environment and request informtation from MS as to whether this is expected behavior.

    Hope this helps!


    Elli J Project Solutions Specialist Blog: http://projectserverpants.wordpress.com/


    • Edited by ElliJ Wednesday, December 16, 2015 4:58 PM
    Wednesday, December 16, 2015 4:55 PM