项目成功发布，数据无法存储在报告表中。 [英] Project gets published successfully the data fails to stored in reporting tables.

问题描述

大家好

Project Server 2013中出现以下问题。

我在PWA中有一个项目计划。当我从专业人员编辑此项目时，修改其中的一些数据并保存。单击按钮保存后，我看到状态表明保存项目成功。然后我点击发布按钮，处理后，我看到
发布作业也成功完成。所以我检查了这个项目。现在我可以很好地看到PWA中的数据，它在我修改时是准确的。这是我的问题，当我尝试从
Project Server报告数据库查询此项目的任务时，我什么都没得到。我不知道原因。

当我查看管理队列作业时发现以下错误消息

一般

• 报告Wss列表同步失败：
  
  
  
  
  • ReportingWssSyncListFailed （240 18） - 1100.详细信息：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='02327dab-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error =' 1100' 。
    
  • ReportingWssSyncListFailed （24018） - 1101详情：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='05327dab-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1101'。
    
  • ReportingWssSyncListFailed （24018） - 1100详情：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='0c327dab-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1100'。
    
  • ReportingWssSyncListFailed （24018） - 1101详情：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='0f327dab-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1101'。
    
  • ReportingWssSyncListFailed （24018） - 1100详情：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='16327dab-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1100'。
    
  • ReportingWssSyncListFailed （24018） - 1101详情：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='19327dab-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1101'。
    
  • ReportingWssSyncListFailed （24018） - 1100详情：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='13347dab-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1100'。
    
  • ReportingWssSyncListFailed （24018） - 1101详情：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='1e347dab-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1101'。
    
  • ReportingWssSyncListFailed （24018） - 1100详情：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='abf8dbb1-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1100'。
    
  • ReportingWssSyncListFailed （24018） - 1101 。细节：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='aef8dbb1-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1101'。
    
  • ReportingWssSyncListFailed （24018） - 1100详情：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='b5f8dbb1-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1100'。
    
  • ReportingWssSyncListFailed （24018） - 1101详情：id ='24018'
    name ='ReportingWssSyncListFailed'uid ='b8f8dbb1-e920-e311-93fd-00155d44aac4'SPListType ='736967e2-321c-e311-93fc-00155d44aac4'Error ='1101'。
    
  
  
• 报告消息处理器失败：
  
  
  
  
  • ReportingWSSSyncMessageFailed （24016） - RDS失败，而
    尝试同步一个或多个SP列表。将重试RDS队列消息。详细信息：id ='24016'name ='ReportingWSSSyncMessageFailed'uid ='0a327dab-e920-e311-93fd-00155d44aac4'QueueMessageBody ='ProjectUID ='736967e2-321c-e311-93fc-00155d44aac4' 。 ForceFullSync ="假"。
    SynchronizationType ='Documents''Error ='尝试同步一个或多个SP列表时RDS失败。将重试RDS队列消息。'。
    
  • ReportingWSSSyncMessageFailed （24016） - RDS尝试同步一个或多个SP列表时
    失败。将重试RDS队列消息。详细信息：id ='24016'name ='ReportingWSSSyncMessageFailed'uid ='14327dab-e920-e311-93fd-00155d44aac4'QueueMessageBody ='ProjectUID ='736967e2-321c-e311-93fc-00155d44aac4' 。 ForceFullSync ="假"。
    SynchronizationType ='Documents''Error ='尝试同步一个或多个SP列表时RDS失败。将重试RDS队列消息。'。
    
  • ReportingWSSSyncMessageFailed （24016） - RDS尝试同步一个或多个SP列表时
    失败。将重试RDS队列消息。详细信息：id ='24016'name ='ReportingWSSSyncMessageFailed'uid ='1e327dab-e920-e311-93fd-00155d44aac4'QueueMessageBody ='ProjectUID ='736967e2-321c-e311-93fc-00155d44aac4' 。 ForceFullSync ="假"。
    SynchronizationType ='Documents''Error ='尝试同步一个或多个SP列表时RDS失败。将重试RDS队列消息。'。
    
  • ReportingWSSSyncMessageFailed （24016） - RDS尝试同步一个或多个SP列表时
    失败。将重试RDS队列消息。详细信息：id ='24016'name ='ReportingWSSSyncMessageFailed'uid ='23347dab-e920-e311-93fd-00155d44aac4'QueueMessageBody ='ProjectUID ='736967e2-321c-e311-93fc-00155d44aac4' 。 ForceFullSync ="假"。
    SynchronizationType ='Documents''Error ='尝试同步一个或多个SP列表时RDS失败。将重试RDS队列消息。'。
    
  • ReportingWSSSyncMessageFailed （24016） - RDS尝试同步一个或多个SP列表时
    失败。将重试RDS队列消息。详细信息：id ='24016'name ='ReportingWSSSyncMessageFailed'uid ='b3f8dbb1-e920-e311-93fd-00155d44aac4'QueueMessageBody ='ProjectUID ='736967e2-321c-e311-93fc-00155d44aac4' 。 ForceFullSync ="假"。
    SynchronizationType ='Documents''Error ='尝试同步一个或多个SP列表时RDS失败。将重试RDS队列消息。'。
    
  • ReportingWSSSyncMessageFailed （24016） - RDS尝试同步一个或多个SP列表时
    失败。将重试RDS队列消息。详细信息：id ='24016'name ='ReportingWSSSyncMessageFailed'uid ='bdf8dbb1-e920-e311-93fd-00155d44aac4'QueueMessageBody ='ProjectUID ='736967e2-321c-e311-93fc-00155d44aac4' 。 ForceFullSync ="假"。
    SynchronizationType ='Documents''Error ='尝试同步一个或多个SP列表时RDS失败。将重试RDS队列消息。'。
    
  
  
• 队列：
  
  
  
  
  • GeneralQueueJobFailed （26000） -
    ReportingWSSSync.WSSSyncMessageEx 。详细信息：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'。有关详细信息，请查看计算机上的ULS日志
    f3d7ef1c-7426-4c4e-a533-1b7bc1c7452b ，查看JobUID
    821efda6-e920-e311-93fd-00155d44aac4的条目即可。
  
  

有人可以帮忙吗？解决这个问题。

谢谢

Sunitha

解决方案

Sunitha，

  我阅读上面消息的方式是抱怨风险和风险相关项目工作区中的问题列表（代码1100和1101）是导致问题的原因。

我会去查看该项目的工作区网站，并确保风险和问题列表具有所有默认列，并且尚未删除或重命名。

如果您发现风险或问题列表已更改为默认状态，则可能希望从网站导出任何重要信息，然后使用服务器设置 - >项目网站删除该网站，并在
下次发布操作时重新创建该网站。  （不要使用SharePoint删除网站）

祝你好运，

  詹姆斯。

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

解决方案

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.

这篇关于项目成功发布，数据无法存储在报告表中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！