none
Reporting (Project Sync) Job Failed -Failed But Not Blocking Correlation -Project Server 2013 RRS feed

  • Question

  • Hello Team, Need your Help to resolve the critical issue, due this reporting table not updating, so we are facing the reporting issue.

    To resolve the issue following Action has been performed :

    1. Delete Issue and Risk List from associated Project Site

    2. Save for Sharing in MS Project 2013

    3. Update the Assign to field in Issue and Risk list as Multiple Selection

    Still we are facing issue following issue,

    General
    • Reporting Wss list sync failed:
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='a5d5e7b3-88c7-e411-b142-0050568f3409' SPListType='01c8ecbc-9d01-427b-89e8-910e6940ef6b' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='b0d5e7b3-88c7-e411-b142-0050568f3409' SPListType='01c8ecbc-9d01-427b-89e8-910e6940ef6b' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='bbd5e7b3-88c7-e411-b142-0050568f3409' SPListType='01c8ecbc-9d01-427b-89e8-910e6940ef6b' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='6b2e19ba-88c7-e411-b142-0050568f3409' SPListType='01c8ecbc-9d01-427b-89e8-910e6940ef6b' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='762e19ba-88c7-e411-b142-0050568f3409' SPListType='01c8ecbc-9d01-427b-89e8-910e6940ef6b' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='812e19ba-88c7-e411-b142-0050568f3409' SPListType='01c8ecbc-9d01-427b-89e8-910e6940ef6b' Error='1100'.
    • Reporting message processor failed:
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='acd5e7b3-88c7-e411-b142-0050568f3409' QueueMessageBody='ProjectUID='01c8ecbc-9d01-427b-89e8-910e6940ef6b'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='b7d5e7b3-88c7-e411-b142-0050568f3409' QueueMessageBody='ProjectUID='01c8ecbc-9d01-427b-89e8-910e6940ef6b'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='c2d5e7b3-88c7-e411-b142-0050568f3409' QueueMessageBody='ProjectUID='01c8ecbc-9d01-427b-89e8-910e6940ef6b'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='722e19ba-88c7-e411-b142-0050568f3409' QueueMessageBody='ProjectUID='01c8ecbc-9d01-427b-89e8-910e6940ef6b'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='7d2e19ba-88c7-e411-b142-0050568f3409' QueueMessageBody='ProjectUID='01c8ecbc-9d01-427b-89e8-910e6940ef6b'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='882e19ba-88c7-e411-b142-0050568f3409' QueueMessageBody='ProjectUID='01c8ecbc-9d01-427b-89e8-910e6940ef6b'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
    • Queue:
      • GeneralQueueJobFailed (26000) - ReportingWSSSync.WSSSyncMessageEx. Details: id='26000' name='GeneralQueueJobFailed' uid='892e19ba-88c7-e411-b142-0050568f3409' JobUID='6851c2b1-88c7-e411-91e3-0050568f7433' ComputerName='c55a9e6d-aa36-4f8a-a929-78d900b74091' GroupType='ReportingWSSSync' MessageType='WSSSyncMessageEx' MessageId='1' Stage='' CorrelationUID='d187f19c-cc64-e048-e06e-32dfa6087669'. For more details, check the ULS logs on machine c55a9e6d-aa36-4f8a-a929-78d900b74091 for entries with JobUID 6851c2b1-88c7-e411-91e3-0050568f7433.
    
    
    <input accesskey="c" id="CancelButton" style="font-family:'Segoe UI', Segoe, Tahoma, Helvetica, Arial, sans-serif;font-size:11px;color:#444444;vertical-align:middle;min-width:6em;padding:7px 10px;border:1px solid rgb(171, 171, 171);margin-left:10px;background-color:#fdfdfd;" type="button" value="Close" />

    Friday, March 13, 2015 4:51 AM

All replies

  • Hello,

    Those issue / Risk changes you made will break the sync with reporting database. You will need to reset the Issue and Risk lists back to the default schemas. See the post below that might help:

    https://pwmather.wordpress.com/2011/06/20/project-server-2010-project-site-default-fields/

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Friday, March 13, 2015 9:35 AM
    Moderator
  • Hello Paul,

    As i have deleted the risk and Issue list itself, however Que Job throwing same error.

    Thanks,

    Friday, March 13, 2015 11:32 AM
  • It will do as it tries to sync those lists. Rather than delete them just remove the link to those lists from the Project Site quick launch menu.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Friday, March 13, 2015 11:33 AM
    Moderator
  • We can't hide the list form Site, PM are extensively using the issue and risk option.
    Friday, March 13, 2015 8:00 PM
  • The PM's are using the issue and risk lists? I thought you said you had deleted those lists? Paul

    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Friday, March 13, 2015 11:11 PM
    Moderator
  • You can also follow the below steps. However, please test this first in your Dev or test environment before you proceed with the production environment:

    1. Backup: Please take a full backup of the content database where the Project Site is hosted so that in case of any issues we can revert the changes
    2. Run the below query in the Content DB where the Project site is hosted

    select tp_Title,tp_ServerTemplate from AllLists where 
    tp_WebId IN (select Id from Webs where FullUrl = 'PWA/Test') -- replace the value for FullUrl with the <PWA name>/<Project Name>
    and tp_ServerTemplate in (101,1100,1101,1104)

    Issues 
    Risks   
    Team Discussions 
    Deliverables
    Documents
    Site Assets

    In case the lists and libraries displayed in the output aren’t only Deliverables, Risks, Issues, Project Documents and has some other values as well then we will have to migrate the content of these sites as well else we will not be able to activate the feature  Project Web App Connectivity

    3. Post this create a new project site 
    4. Now, navigate to affected Project Site and Go to Site Action > Site Settings > Content and structure
    5. Use the Content and Structure interface to copy the list data to the list in our newly created site

    Issues  4 Items
    Risks    4 Items
    Team Discussions  1 Item
    Project Documents [However for ,  I see that there are many documents, which you can open in explorer view and copy it to a temporary location. Later you can copy this documents back to Project documents folder  [Project Documents library gets created when you activate the feature]
    Deliverables 0 items
    Documents 0 items
    Site Assets 0 items

    6. Once the data has been copied delete Deliverables, Risks, Issues and Project Documents from the affected site
    7. In the affected Project Site go to Go to Site Action > Site Settings > Manage site features. Deactivate and Activate the ‘Project Web App Connectivity’
    8. Use the Content and Structure (Site Action > Site Settings > Content and structure ) to copy the data back from our temporary site to the affected site
    9. Verify the data and delete the temporary site


    Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.

    Saturday, March 14, 2015 4:29 PM