none
Project gets published successfully the data fails to stored in reporting tables. RRS feed

  • Question

  • Hi All

    The following issue occurs in Project server 2013.

    I have a project plan in PWA. When I edit this project from professional and modify some data in it and save. After the click the button save, I see the status indicates Save project successfully. Then I click publish button, after processing, I see publish job complete successfully too. So I check in this project. Now I can see the data in PWA well, it is accurate as I modified. Here is my problem, when I try to query the tasks of this project from the Project Server Reporting DB, I get nothing. I don't know why.

    When i look into the Manage Queue Job found the below error message

    General

    • Reporting Wss list sync failed:
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='02327dab-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1101. Details: id='24018' name='ReportingWssSyncListFailed' uid='05327dab-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1101'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='0c327dab-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1101. Details: id='24018' name='ReportingWssSyncListFailed' uid='0f327dab-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1101'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='16327dab-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1101. Details: id='24018' name='ReportingWssSyncListFailed' uid='19327dab-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1101'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='13347dab-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1101. Details: id='24018' name='ReportingWssSyncListFailed' uid='1e347dab-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1101'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='abf8dbb1-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1101. Details: id='24018' name='ReportingWssSyncListFailed' uid='aef8dbb1-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1101'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='b5f8dbb1-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1101. Details: id='24018' name='ReportingWssSyncListFailed' uid='b8f8dbb1-e920-e311-93fd-00155d44aac4' SPListType='736967e2-321c-e311-93fc-00155d44aac4' Error='1101'.
    • 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='0a327dab-e920-e311-93fd-00155d44aac4' QueueMessageBody='ProjectUID='736967e2-321c-e311-93fc-00155d44aac4'. ForceFullSync='False'. SynchronizationType='Documents'' 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='14327dab-e920-e311-93fd-00155d44aac4' QueueMessageBody='ProjectUID='736967e2-321c-e311-93fc-00155d44aac4'. ForceFullSync='False'. SynchronizationType='Documents'' 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='1e327dab-e920-e311-93fd-00155d44aac4' QueueMessageBody='ProjectUID='736967e2-321c-e311-93fc-00155d44aac4'. ForceFullSync='False'. SynchronizationType='Documents'' 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='23347dab-e920-e311-93fd-00155d44aac4' QueueMessageBody='ProjectUID='736967e2-321c-e311-93fc-00155d44aac4'. ForceFullSync='False'. SynchronizationType='Documents'' 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='b3f8dbb1-e920-e311-93fd-00155d44aac4' QueueMessageBody='ProjectUID='736967e2-321c-e311-93fc-00155d44aac4'. ForceFullSync='False'. SynchronizationType='Documents'' 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='bdf8dbb1-e920-e311-93fd-00155d44aac4' QueueMessageBody='ProjectUID='736967e2-321c-e311-93fc-00155d44aac4'. ForceFullSync='False'. SynchronizationType='Documents'' 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='bef8dbb1-e920-e311-93fd-00155d44aac4' JobUID='821efda6-e920-e311-93fd-00155d44aac4' ComputerName='f3d7ef1c-7426-4c4e-a533-1b7bc1c7452b' GroupType='ReportingWSSSync' MessageType='WSSSyncMessageEx' MessageId='1' Stage='' CorrelationUID='c36c449c-afae-d0af-7452-be5aee2ce202'. For more details, check the ULS logs on machine f3d7ef1c-7426-4c4e-a533-1b7bc1c7452b for entries with JobUID 821efda6-e920-e311-93fd-00155d44aac4.

    Can someone help m to fix this issue.

    Thanks

    Sunitha


    • Edited by Sunitha vv Thursday, September 19, 2013 7:08 AM
    Thursday, September 19, 2013 6:05 AM

All replies

  • Sunitha,

       The way I read the messages above it is complaining that the Risks & Issues lists (Codes 1100 & 1101) in the associated project workspace is the cause of the problem.

    I would go and take a look at the workspace site for this project and make sure the Risks and Issues lists have all the default columns, and they have not been deleted or renamed.

    If you find that the Risks or Issues list has been altered away from the default state, you might want to export any important information from the site, and then use the Server Settings->Project Sites to delete the site and have it be recreated during the next publish operation.  (Do not use SharePoint to delete the site)

    Good luck,

       James.


    James Boman - http://www.boman.biz Software Consultant for IPMO - http://www.ipmo.com.au


    Thursday, September 19, 2013 7:18 AM
  • Hey James curious about how to obtain the Codes list? You mentioned 1100 and 1101 being associated with Risks and Issues, but where does that code list live?

    REJ

    Thursday, January 19, 2017 1:37 PM