none
Error in formula field: Column 'TASK_BCWP' does not belong to table Task RRS feed

  • Question

  • Hi,

    We have a formula field to calculate the a cost KPI and that field throws an error in the ULS logs. The error is: PWA:PWA, ServiceApp:Project Server Service Application, User:GDFN\IPL_Content, PSI: SSP: Formula Evaluation Failed! - trying to continue - (System.ArgumentException: Column 'TASK_BCWP' does not belong to table Task.

    We are running EPM 2010. Recreating of the custom field did not work. We are not running with the latest CU yet.

    The formula that we use is: IIf([BCWP] > 0; [ACWP] / [BCWP]; 1)

    The stack trace from the ULS log is:

    PWA:http://gdfn-ipl-14/PWA, ServiceApp:Project Server Service Application, User:GDFN\IPL_Content, PSI: SSP: Formula Evaluation Failed! - trying to continue - (System.ArgumentException: Column 'TASK_BCWP' 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.HaveColumn(DataRow row, 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.GreaterExpression.Evaluate(IFieldEvaluator context, Guid nodeId)

    at Microsoft.Office.Project.Server.BusinessLayer.Formula.ConditionalExpression.Evaluate(IFieldEvaluator context, Guid nodeId)

    at Microsoft.Office.Project.Server.BusinessLayer.Formula.FormulaEvaluator.Evaluate(PlatformContext context, Expression formula, Int32 entityId, Int32 fieldId, Guid nodeId, Dictionary`2 entityFormulaFields)) + -- FieldId = 188776525 -- NodeId = 1b1149c1-52c2-4f7f-ba60-6d65effdb6b3 -- Formula = IIf(Greater([MSPJ188743691], 0), Divide([MSPJ188743800], [MSPJ188743691]), 1)

     

    I have no clue where to start looking for the cause of this error. Any help would be appreciated.

    Thanks,

    Quint Mouthaan

    Friday, May 20, 2011 9:21 AM

Answers

All replies