locked
Queue is failing in Project Server RRS feed

  • Question

  •  

    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!


    Friday, March 23, 2012 10:06 PM

All replies

  • 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.


    Best regards, Ricardo Segawa - Segawas Projetos / Microsoft Partner

    Tuesday, March 27, 2012 11:37 PM