Queue is failing in Project Server

• Question

• 

  

  0

  Sign in to vote

   

  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!

  
  

  • Edited by DBA MS Project Server Saturday, March 24, 2012 1:20 AM

  Friday, March 23, 2012 10:06 PM