none
Issues and Risks not getting sync with PWA database RRS feed

  • Question

  • Hi,

    I am adding risks and issues on project site in Project Online but it is not getting synced with PWA database. I checked in Manage Queue Jobs and it is showing "Reporting (Project Risk Sync)" message. Any of the OOTB field is also not deleted nor modified. Also, this issue does not occur for all the projects. For any of the random project I am facing this issue.

    Any idea why this is happening?

    Friday, April 20, 2018 1:04 PM

All replies

  • Hello,

    What is the Reporting (Project Risk Sync) message in the queue showing? An error or success?

    Paul


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

    Saturday, April 21, 2018 9:56 AM
    Moderator
  • Hi Paul,

    In Job State it is showing "Failed But Not Blocking Correlation" message. And in error it is showing the below details:

    General
    • Reporting Wss list sync failed:
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='df50eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1100' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='e250eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1101' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='eb50eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1100' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='ee50eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1101' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='f750eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1100' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='fa50eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1101' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='0151eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1100' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='0451eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1101' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='0b51eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1100' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='0e51eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1101' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='1551eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1100' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
      • ReportingWssSyncListFailed (24018) - Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.. Details: id='24018' 
        name='ReportingWssSyncListFailed' 
        uid='1851eed6-a543-e811-80c7-8a5d3f5a673f' 
        ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10' 
        SPListType='1101' 
        Error='Mismatch transaction usage, a Commit/Rollback was called without a matching Begin. Current reference count 0.' 
        .
    • 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='e850eed6-a543-e811-80c7-8a5d3f5a673f' 
        QueueMessageBody='ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10'. ForceFullSync='False'. SynchronizationType='Risks'' 
        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='f450eed6-a543-e811-80c7-8a5d3f5a673f' 
        QueueMessageBody='ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10'. ForceFullSync='False'. SynchronizationType='Risks'' 
        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='ff50eed6-a543-e811-80c7-8a5d3f5a673f' 
        QueueMessageBody='ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10'. ForceFullSync='False'. SynchronizationType='Risks'' 
        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='0951eed6-a543-e811-80c7-8a5d3f5a673f' 
        QueueMessageBody='ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10'. ForceFullSync='False'. SynchronizationType='Risks'' 
        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='1351eed6-a543-e811-80c7-8a5d3f5a673f' 
        QueueMessageBody='ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10'. ForceFullSync='False'. SynchronizationType='Risks'' 
        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='1d51eed6-a543-e811-80c7-8a5d3f5a673f' 
        QueueMessageBody='ProjectUID='d45036d2-cbe4-e711-80e0-00155d3cbb10'. ForceFullSync='False'. SynchronizationType='Risks'' 
        Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.' 
        .
    • Queue:
      • GeneralQueueJobFailed (26000) - ReportingWSSRiskSync.WSSSyncMessageEx. Details: id='26000' 
        name='GeneralQueueJobFailed' 
        uid='1e51eed6-a543-e811-80c7-8a5d3f5a673f' 
        JobUID='c6ee7ed0-a543-e811-80c7-8a5d3f5a673f' 
        ComputerName='2ef0dfc7-7a03-4273-a836-6971789e9ee4' 
        GroupType='ReportingWSSRiskSync' 
        MessageType='WSSSyncMessageEx' 
        MessageId='1' 
        Stage='' 
        CorrelationUID='b9f05e9e-408d-5000-9bb6-1052b1bb884f' 
        For more details, check the ULS logs on machine 2ef0dfc7-7a03-4273-a836-6971789e9ee4 for entries with JobUID c6ee7ed0-a543-e811-80c7-8a5d3f5a673f.
    
    
    <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-width:1px;border-style:solid;border-color:#ababab;background-color:#fdfdfd;margin-left:10px;" type="button" value="Close" />

    Monday, April 23, 2018 9:34 AM
  • Hi Reshu,
    This has happened with me also, but then I had changed the "datatype" of one field in risk list from text to choice, then i shows this error. Other than , check queue jobs only to find any clue.



    • Edited by mafab Monday, April 30, 2018 10:40 AM
    Monday, April 30, 2018 10:37 AM
  • I experienced the same issue and ultimately we discovered that the site in question had the Assigned To column switched to "Allow multiple selections".  Switching this back resolved the issue.  No major catastrophe. 

    If the simple switch back doesn't work, we have had some success with removing the association to the Connected SharePoint Site, and then readding the association through the Server Settings.

    Note: Our environment in question is Project Online as of May 2018.

    Wednesday, May 16, 2018 1:15 PM