队列在Project Server中失败 [英] Queue is failing in Project Server
问题描述
 
您好，
我正在使用带有SQL Server 2005的Project Server 2007 SP3。
我检查了我的ULS日志，因为有些作业在没有阻塞关联的情况下失败，并且发现它充满了以下行。
03/23/2012 05：33：48.85 Microsoft.Office.Project.Server（0x0F90）
0x1870 Project Server Project Server端项目操作
9dxo 中<跨度>&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;
PWA：http：// epmxx / PWA，SSP：SharedServices1，用户：DOM1 \Admin1，PSI：
SSP：公式评估失败！ - 试图继续 - （System.ArgumentException：列 'TASK_COST_VAR'
不属于表任务的&NBSP;&NBSP;&NBSP;&NBSP; 的系统。 Data.DataRow.GetDataColumn（字符串COLUMNNAME）<跨度>&NBSP;&NBSP;&NBSP;&NBSP;
。在System.Data.DataRow.get_Item（字符串COLUMNNAME）<跨度>&NBSP ;&NBSP;&NBSP;&NBSP ;
在Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetTaskData（Guid nodeId，Int32 fieldId）
at at Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetDataInternal（的Int32 ENTITYID，的Guid的NodeId，的Int32 fieldId，布尔canChangeEntity）<跨度>&NBSP;&NBSP;&NBSP;&NBSP;
的Microsoft.Office。 Microsoft.Office.Project.Server.BusinessLayer.Formula中的Project.Server.BusinessLayer.FormulaDataProvider.GetData（Int32 entityId，Guid nodeId，Int32 fieldId）
.FieldExpression.Evaluate（IFieldEvaluator context，Guid nodeId） & NBSP;&NBSP;&NBSP;
的Microsoft.Office.Project.Server.BusinessLayer.Formula.DivideExpression.Evaluate（IFieldEvaluator上下文中，的Guid NODEID）<跨度>&NBSP;&NBSP;&NBSP;&NBSP;
的Microsoft.Office.Project.Server.BusinessLayer.Formula.FormulaEvaluator.EvaluateSummaryNode（表达式，的Int32 ENTITYID，的Guid的NodeId，的Int32 fieldId，对象&安培;结果）<跨度>&NBSP;&NBSP;&NBSP; &NBSP;
在Microsoft.Office.Project.Server.BusinessLayer.Formula.FormulaEvaluator.Evaluate（PlatformContext context，Expression formula，Int32 entityId，Int32 fieldId，Guid nodeId，SummaryInfo summaryInfo））+ - FieldId = 188776462 - 的NodeId = 9553928e-9dd3-4558-bb60-0788cb88fc7b
- 式=鸿沟（[MSPJ188743689]，[MSPJ188743686]）<跨度>&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;
486dd6a5-9621-474e-8a57-eaba02d7230d
03/23/2012 05：33：48.86 ; Microsoft.Office.Project.Server（0x0F90）
0x1870 Project Server Project Server端项目操作
9dxo 中<跨度>&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;
PWA：http：// epmxx / PWA，SSP：SharedServices1，用户：DOM1 \Admin1，PSI：
SSP：公式评估失败！ - 尝试继续 - （System.ArgumentException：列
'TASK_DUR_VAR'不属于表格任务。
在System.Data.DataRow.GetDataColumn（字符串COLUMNNAME）<跨度>&NBSP;&NBSP;&NBSP;&NBSP;
&NBSP跨度>;&NBSP ;
at Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetTaskData（Guid nodeId，Int32 fieldId）
的Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetDataInternal（的Int32 ENTITYID，的Guid的NodeId，的Int32 fieldId，布尔canChangeEntity）<跨度>&NBSP;&NBSP;&NBSP;&NBSP;
的Microsoft.Office.Project.Server中的Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetData（Int32 entityId，Guid nodeId，Int32 fieldId）
.BusinessLayer.Formula.FieldExpression.Evaluate（IFieldEvaluator context，Guid nodeId）&nb属;&NBSP;&NBSP;&NBSP;
的Microsoft.Office.Project.Server.BusinessLayer.Formula.FormulaEvaluator.Evaluate（PlatformContext上下文中，表达式，的Int32 ENTITYID，的Int32 fieldId，的Guid的NodeId，SummaryInfo使用SummaryInfo使用））+ - FieldId = 188776464 - 的NodeId = e9440595-f62a-4553-b694-0c053a4bb908
- 通式= [MSPJ188743710] <跨度>&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;
486dd6a5-9621-474e-8a57-eaba02d7230d
我们在任何地方都没有使用这些列，任何人都可以通知我我该怎么做才能避免这个问题？
谢谢！
您好DBA MS项目服务器，
它看起来像有公式引用到字段TASK_DUR_VAR和TASK_COST_VAR不存在，因此导致作业处理错误。我现在没有使用有效的PS 2007机器进行确认，但我认为这些字段的正确名称是TASK_COST_VARIANCE
和TASK_DURATION_VARIANCE。您应该确认查看ProjectServer_Draft数据库，任务表。
Hi,
I am using Project Server 2007 SP3 with SQL Server 2005.
I check my ULS Log as some of the jobs were failing without blocking correlation and have found it full of following rows.
03/23/2012 05:33:48.85 Microsoft.Office.Project.Server (0x0F90)
0x1870 Project Server Project Server-side Project Ope
9dxo Medium
PWA:http://epmxx/PWA, SSP:SharedServices1, User:DOM1\Admin1, PSI:
SSP: Formula Evaluation Failed! - trying to continue - (System.ArgumentException: Column 'TASK_COST_VAR'
does not belong to table Task. at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetTaskData(Guid nodeId, Int32 fieldId)
at Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetDataInternal(Int32 entityId, Guid nodeId, Int32 fieldId, Boolean canChangeEntity)
at Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetData(Int32 entityId, Guid nodeId, Int32 fieldId)
at Microsoft.Office.Project.Server.BusinessLayer.Formula.FieldExpression.Evaluate(IFieldEvaluator context, Guid nodeId)
at Microsoft.Office.Project.Server.BusinessLayer.Formula.DivideExpression.Evaluate(IFieldEvaluator context, Guid nodeId)
at Microsoft.Office.Project.Server.BusinessLayer.Formula.FormulaEvaluator.EvaluateSummaryNode(Expression formula, Int32 entityId, Guid nodeId, Int32 fieldId, Object& result)
at Microsoft.Office.Project.Server.BusinessLayer.Formula.FormulaEvaluator.Evaluate(PlatformContext context, Expression formula, Int32 entityId, Int32 fieldId, Guid nodeId, SummaryInfo summaryInfo)) + -- FieldId = 188776462 -- NodeId = 9553928e-9dd3-4558-bb60-0788cb88fc7b
-- Formula = Divide([MSPJ188743689], [MSPJ188743686])
486dd6a5-9621-474e-8a57-eaba02d7230d
03/23/2012 05:33:48.86 Microsoft.Office.Project.Server (0x0F90)
0x1870 Project Server Project Server-side Project Ope
9dxo Medium
PWA:http://epmxx/PWA, SSP:SharedServices1, User:DOM1\Admin1, PSI:
SSP: Formula Evaluation Failed! - trying to continue - (System.ArgumentException: Column
'TASK_DUR_VAR' does not belong to table Task.
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetTaskData(Guid nodeId, Int32 fieldId)
at Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetDataInternal(Int32 entityId, Guid nodeId, Int32 fieldId, Boolean canChangeEntity)
at Microsoft.Office.Project.Server.BusinessLayer.FormulaDataProvider.GetData(Int32 entityId, Guid nodeId, Int32 fieldId)
at Microsoft.Office.Project.Server.BusinessLayer.Formula.FieldExpression.Evaluate(IFieldEvaluator context, Guid nodeId)
at Microsoft.Office.Project.Server.BusinessLayer.Formula.FormulaEvaluator.Evaluate(PlatformContext context, Expression formula, Int32 entityId, Int32 fieldId, Guid nodeId, SummaryInfo summaryInfo)) + -- FieldId = 188776464 -- NodeId = e9440595-f62a-4553-b694-0c053a4bb908
-- Formula = [MSPJ188743710]
486dd6a5-9621-474e-8a57-eaba02d7230d
We are not using these columns anywhere, could anyone inform me that what should I do to avoid this problem?
Thanks!
Hi DBA MS Project Server,
It looks like there are formulas referencing to fields TASK_DUR_VAR and TASK_COST_VAR that do not exist, therefore resulting in job processing error. I am not with an active PS 2007 machine now to confirm, but I think the right name of the fields are TASK_COST_VARIANCE and TASK_DURATION_VARIANCE. You should confirm looking at the ProjectServer_Draft database, Task tables.
这篇关于队列在Project Server中失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
