Project Server 2013：QueueUpdateProject2因LookupTableItemInvalidLookupTable错误而失败 [英] Project Server 2013: QueueUpdateProject2 fails with LookupTableItemInvalidLookupTable error

查看：72
本文介绍了Project Server 2013：QueueUpdateProject2因LookupTableItemInvalidLookupTable错误而失败的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述


我们在WebSvcProject中使用新引入的QueueUpdateProject2 PSI方法有一个奇怪的问题。服务器正在运行15.0.4481.1005版（Project Server 2013，2013年3月PU）。这是最小的repro代码：

 projectService.CheckOutProject（projectUid，  sessionUid，  sessionDescription）; 
  var   projectDataSet  =  projectService.ReadProject（projectUid，   DataStoreEnum  .WorkingStore）; 
 projectDataSet.Project [0] .SetModified（）;   //  Simplest  repro  
 
  VAR   jobUid  =  Guid.NewGuid（）; 
 projectService.QueueUpdateProject2（jobUid，  sessionUid，  projectDataSet，   false ）;


 

不幸的是，QueueUpdateProject2队列作业总是失败，并且该项目的LookupTableItemInvalidLookupTable错误。下面是如在PWA中所示的完整的错误信息：



  • 的 LookupTableItemInvalidLookupTable为查表值b99b7782-924c-e311-9404-00155d027b07：

    • LookupTableItemInvalidLookupTable （11073）。详细信息：id ='11073'name ='LookupTableItemInvalidLookupTable'uid ='b1c62182-924c-e311-9404-00155d027b07'。

  • 队列：

    • GeneralQueueJobFailed （26000） - ProjectUpdate.ProjectUpdate2Message 。详细信息：id ='26000'name ='GeneralQueueJobFailed'uid ='b020bf82-924c-e311-9404-00155d027b07'JobUID ='f294b911-f500-45bc-91ec-a493bdf3d07a'ComputerName ='1beb2ff2-5dc9-4136-aa24-1c2be86c5768 '
      GroupType =' ProjectUpdate"消息类型= 'ProjectUpdate2Message' 的MessageId = '2' 阶段= '' CorrelationUID = 'ce4e569c-0aa5-70d6-c576-8b3b764d14f1'。有关详细信息，检查表项上机械
      ULS日志的 1beb2ff2-5dc9-4136-aa24-1c2be86c5768 使用JobUID的
      f294b911-f500-45bc-91ec-a493bdf3d07a       。


以下是来自ULS日志的一些相应条目：


'p> 2013年11月13日19：36：30.82  Microsoft.Office.Project.Server（0x06D0）  0x1E60 项目服务器         &NBSP ;        Active Cache Save            
  myzo  Medium   错误是：LookupTableItemInvalidLookupTable。详细信息：LookupTableItemInvalidLookupTable用于查找表值b99b7782-924c-e311-9404-00155d027b07。标准信息：，LogLevelManager警告 - ulsID：0x6D797A6F没有
实体明确指定  ce4e569c-0aa5-70d6-c576-8b3b764d14f1

2013年11月13日19：36：30.82&NBSP ; Microsoft.Office.Project.Server（0x06D0）  0x1E60 项目服务器                  Active Cache Save            
  4zbp 可监视  PWA :, ServiceApp：项目服务器服务应用程序，用户：I：0＃.W | my\account，PSI：[TrackingId：fa790381-924c-e311-9404-00155d027b07] [ RESOURCEID：3222f5b7-C13B-e311-9404-00155d027b07] [SessionGuid：db83645c-50e1-4368-a59f-94df13ff7d5e] [SessionDescr：] [JobGuid：af20bf82-924c-e311-9404-00155d027b07] [ProjectGuid：81a4a757-c446-E311 -9404-00155d027b07] [PS_AC] [400]
Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.WinProjException：LookupTableItemInvalidLookupTable为查表值b99b7782-924c-e311-9404-00155d027b07    在Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.P12Deserializer.PostReadRow（P12ContainerHeader
cntrHeader，Row row）    在Microsoft.Office.Project.Server.BusinessLayer.WinProj.SaveProjectInternal（GUID projGuid，字符串projName，的Int32 projType，布尔...  ce4e569c-0aa5-70d6-c576-8b3b764d14f1

11/13 / 2013 19：36：30.82 *  Microsoft.Office.Project.Server（0x06D0）  0x1E60 项目服务器            &NBSP ;   活动缓存保存            
  4zbp 可监控  ... isNewProj，的Guid jobGuid ，Guid sessionGuid，Guid checkOutByResUid，String sessionDescr，Boolean isFirstPacket，Boolean isLastPacket，String newVersionStamp，Int16 dataFormatVersion，Boolean isDataCompressed，Byte [] projectData，
String winprojBuildNumber，ACProcessorType acProcType），LogLevelManager Warning-ulsID：0x347A6270没有实体明确指定。  ce4e569c-0aa5-70d6-c576-8b3b764d14f1


如果需要，我们很乐意提供更多信息。 Project Professional可以很好地打开和保存项目，所以它似乎与其他论坛帖子无关（1,2）。


有没有人见过这个？有关搜索位置或查找内容的任何提示？


谢谢，

Thomas

TPG项目组


[1] http://social.technet.microsoft.com/Forums/projectserver/en-US/da3c0d64-1ced-45dd-ace6-ce821fd1c362/what-are-the-lookup-fields- in-the-local-project-cant-publish-project-to-server

[2] http://answers.microsoft.com/en-us/office/forum/office_2010-项目/错误110730x2b41-importsave到项目服务器/ 03fd792f-4451-4512-ac0b-ddad946c3e3

解决方案
< blockquote>

好的，我们与微软开了一个支持案例。他们可以重现这个问题，但目前尚无法解决问题。由于现在只有一个客户有两个有缺陷的项目，他们可能也不会提供修复。因此，如果您面临同样问题的
，请联系Microsoft 支持并与案例REG113121911042186联系。



谢谢，


Thomas


TPG项目组


Hi,

We have a strange problem here using the newly introduced QueueUpdateProject2 PSI method in WebSvcProject. The server is running version 15.0.4481.1005 (Project Server 2013, March 2013 PU). Here's the minimum repro code:

projectService.CheckOutProject(projectUid, sessionUid, sessionDescription);
var projectDataSet = projectService.ReadProject(projectUid, DataStoreEnum.WorkingStore);
projectDataSet.Project[0].SetModified(); // Simplest repro
 
var jobUid = Guid.NewGuid();
projectService.QueueUpdateProject2(jobUid, sessionUid, projectDataSet, false);

 

Unfortunately the QueueUpdateProject2 queue job always fails with error LookupTableItemInvalidLookupTable for this project. Here's the full error information as shown in PWA:

  • LookupTableItemInvalidLookupTable for lookup table value b99b7782-924c-e311-9404-00155d027b07:
    • LookupTableItemInvalidLookupTable (11073). Details: id='11073' name='LookupTableItemInvalidLookupTable' uid='b1c62182-924c-e311-9404-00155d027b07'.
  • Queue:
    • GeneralQueueJobFailed (26000) - ProjectUpdate.ProjectUpdate2Message. Details: id='26000' name='GeneralQueueJobFailed' uid='b020bf82-924c-e311-9404-00155d027b07' JobUID='f294b911-f500-45bc-91ec-a493bdf3d07a' ComputerName='1beb2ff2-5dc9-4136-aa24-1c2be86c5768' GroupType='ProjectUpdate' MessageType='ProjectUpdate2Message' MessageId='2' Stage='' CorrelationUID='ce4e569c-0aa5-70d6-c576-8b3b764d14f1'. For more details, check the ULS logs on machine 1beb2ff2-5dc9-4136-aa24-1c2be86c5768 for entries with JobUID f294b911-f500-45bc-91ec-a493bdf3d07a.

Here are some corresponding entries from the ULS log:

11/13/2013 19:36:30.82  Microsoft.Office.Project.Server (0x06D0) 0x1E60 Project Server                 Active Cache Save              myzo Medium   Error is: LookupTableItemInvalidLookupTable. Details: LookupTableItemInvalidLookupTable for lookup table value b99b7782-924c-e311-9404-00155d027b07 . Standard Information: , LogLevelManager Warning-ulsID:0x6D797A6F has no entities explicitly specified. ce4e569c-0aa5-70d6-c576-8b3b764d14f1
11/13/2013 19:36:30.82  Microsoft.Office.Project.Server (0x06D0) 0x1E60 Project Server                 Active Cache Save              4zbp Monitorable PWA:, ServiceApp:Project Server Service Application, User:i:0#.w|my\account, PSI: [TrackingId:fa790381-924c-e311-9404-00155d027b07][ResourceId:3222f5b7-c13b-e311-9404-00155d027b07][SessionGuid:db83645c-50e1-4368-a59f-94df13ff7d5e][SessionDescr:][JobGuid:af20bf82-924c-e311-9404-00155d027b07][ProjectGuid:81a4a757-c446-e311-9404-00155d027b07][PS_AC][400] Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.WinProjException: LookupTableItemInvalidLookupTable for lookup table value b99b7782-924c-e311-9404-00155d027b07     at Microsoft.Office.Project.Server.BusinessLayer.WinProjUtility.P12Deserializer.PostReadRow(P12ContainerHeader cntrHeader, Row row)     at Microsoft.Office.Project.Server.BusinessLayer.WinProj.SaveProjectInternal(Guid projGuid, String projName, Int32 projType, Boolean ... ce4e569c-0aa5-70d6-c576-8b3b764d14f1
11/13/2013 19:36:30.82* Microsoft.Office.Project.Server (0x06D0) 0x1E60 Project Server                 Active Cache Save              4zbp Monitorable ...isNewProj, Guid jobGuid, Guid sessionGuid, Guid checkOutByResUid, String sessionDescr, Boolean isFirstPacket, Boolean isLastPacket, String newVersionStamp, Int16 dataFormatVersion, Boolean isDataCompressed, Byte[] projectData, String winprojBuildNumber, ACProcessorType acProcType), LogLevelManager Warning-ulsID:0x347A6270 has no entities explicitly specified. ce4e569c-0aa5-70d6-c576-8b3b764d14f1

We would be happy to provide more information if needed. Project Professional can open and save the project just fine, so it seems to be unrelated to other forum posts (1, 2).

Has anybody seen this before? Any hints on where to search or what to look for?

Thanks,
Thomas
TPG The Project Group

[1] http://social.technet.microsoft.com/Forums/projectserver/en-US/da3c0d64-1ced-45dd-ace6-ce821fd1c362/what-are-the-lookup-fields-in-the-local-project-cant-publish-project-to-the-server
[2] http://answers.microsoft.com/en-us/office/forum/office_2010-project/error-110730x2b41-importsave-to-project-server/03fd792f-4451-4512-ac0b-ddad946c3e3

解决方案

OK, we opened a support case with Microsoft. They could reproduce the issue, but there's no fix available yet. As there's only a single customer with two defective projects right now, they likely won't provide a fix either. So if you're facing the same issue, please contact Microsoft Support and connect with case REG113121911042186.

Thanks,

Thomas

TPG The Project Group


这篇关于Project Server 2013：QueueUpdateProject2因LookupTableItemInvalidLookupTable错误而失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发语言最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆