Project Server 2010 增加自定义字段后,同步数据到ProjectServer_Reporting表报错

 

一、概述

在Project Server 2010中配置自定义字段后,发现数据无法同步到报表中,导致CUBE中数据出不来
查看队列作业,发现如下错误

Reporting message processor failed:
ReportingResourceChangeMessageFailed (24008) - One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008'. 详细信息: id='24008' name='ReportingResourceChangeMessageFailed' uid='968fd2df-8d21-46bc-908c-db0422b58811' QueueMessageBody='Resource UID: '19604708-5135-424a-a57d-78987cc48008'. ChangeType='Add'. ResourceChangeType='All'' Error='One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008''. 
ReportingResourceChangeMessageFailed (24008) - One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008'. 详细信息: id='24008' name='ReportingResourceChangeMessageFailed' uid='fb12845b-5c3a-43f5-b37e-3e511ce7ec14' QueueMessageBody='Resource UID: '19604708-5135-424a-a57d-78987cc48008'. ChangeType='Add'. ResourceChangeType='All'' Error='One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008''. 
ReportingResourceChangeMessageFailed (24008) - One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008'. 详细信息: id='24008' name='ReportingResourceChangeMessageFailed' uid='74f44ba8-f1c3-4deb-b708-a77419438c73' QueueMessageBody='Resource UID: '19604708-5135-424a-a57d-78987cc48008'. ChangeType='Add'. ResourceChangeType='All'' Error='One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008''. 
ReportingResourceChangeMessageFailed (24008) - One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008'. 详细信息: id='24008' name='ReportingResourceChangeMessageFailed' uid='eb378e13-6aa0-437e-821f-b75906364c54' QueueMessageBody='Resource UID: '19604708-5135-424a-a57d-78987cc48008'. ChangeType='Add'. ResourceChangeType='All'' Error='One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008''. 
ReportingResourceChangeMessageFailed (24008) - One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008'. 详细信息: id='24008' name='ReportingResourceChangeMessageFailed' uid='163ab142-343b-4764-a8de-1f2afcfe0f88' QueueMessageBody='Resource UID: '19604708-5135-424a-a57d-78987cc48008'. ChangeType='Add'. ResourceChangeType='All'' Error='One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008''. 
ReportingResourceChangeMessageFailed (24008) - One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008'. 详细信息: id='24008' name='ReportingResourceChangeMessageFailed' uid='384ffff2-9bcc-48cf-9f0e-1b9062de7f64' QueueMessageBody='Resource UID: '19604708-5135-424a-a57d-78987cc48008'. ChangeType='Add'. ResourceChangeType='All'' Error='One or more custom field metadata mismatch were detected while transfering resource '19604708-5135-424a-a57d-78987cc48008''. 
Queue:
GeneralQueueJobFailed (26000) - ReportingResourceSync.ReportResourceSyncMessageEx. 详细信息: id='26000' name='GeneralQueueJobFailed' uid='a7f27563-8674-47b6-8cfa-19546a364362' JobUID='280d512f-9365-4b4e-927b-96fed6dc6045' ComputerName='WS-BJGISGTFS-03' GroupType='ReportingResourceSync' MessageType='ReportResourceSyncMessageEx' MessageId='1' Stage=''. 有关详细信息,请查阅机器 WS-BJGISGTFS-03 上的 ULS 日志中带有 JobUID 280d512f-9365-4b4e-927b-96fed6dc6045 的条目.

二、解决方案:

1 进入“服务器设置”,在“数据库管理下”,点击“管理性备份”

clip_image002

2 在打开的页面中,选择“企业自定义域”

clip_image004

3 选择“备份”
4 进入“服务器设置”,在“数据库管理下”,点击“管理性还原”

clip_image006

5 在打开的页面中,选择“企业自定义域”

clip_image008

6 选择还原
7 结果确认

之后在队列作业中可以看到有作业在运行,大概十多分钟后,刚才的作业会消失,说明

ProjectServer_Reporting库Rebuild成功,资源数据可以正常同步,更新CUBE,即可看到相关的数据更新

原文地址:https://www.cnblogs.com/davidw/p/2891198.html