Error: 'Error Calculating Finish Date' When Publishing Projects.

(Doc ID 2359858.1)

Last updated on FEBRUARY 15, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 17.11.0.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 17.9.0.1 and later
Information in this document applies to any platform.

Symptoms

When the Project is Published, the following failure occurs:

ERROR
-----------------------
017-11-22 10:58:12:[TASK]:[PxServiceActivityReader]: [22] CORE(BRE): (Class: Activity) (Filter: ((ProjectId = 440)) AND (ActivityId = 218663) ORDER BY ActivityId) (Fields: Var1NonLaborUnits,UnitsPercentComplete,AtCompletionExpenseCost,PlannedValueLaborUnits,PrimaryResourceName,Var1ExpenseCost,PlannedValueCost,Var1MaterialCost,DurationPercentOfPlanned,ActualExpenseCost,NonLaborUnitsCompletePercent,PlannedMaterialCost,VarCost,BLPlannedNonLaborUnits,ScheduleVarianceLaborUnits,RemainingMaterialCost,BLPlannedMaterialCost,NonLaborCostPercentComplete,VarianceAtCompletionLaborUnits,RemainingUnits,ActualNonLaborCost,BLStartDate,ActivityId,VarLaborCost,ActualLaborCost,VarExpenseCost,VarNonLaborUnits,ScheduleVarIndexLaborUnits,OwnerId,EstimateToComplete,VarStartDate,RemainingLaborCost,WbsName,WbsShortName,EstimateAtCompletionLaborUnits,DurationPercentComplete,AtCompletionDuration,FinishDate,ActualCost,EarnedValueLaborUnits,PercentComplete,ActualMaterialCost,CostVariance,PlannedUnits,ScheduleVariance,VarianceAtCompletion,ActualThisPeriodNonLaborCost,ActualThisPeriodMaterialCost,ExpenseCostPercentComplete,BLPlannedLaborCost,LastUpdateDate,BLPlannedDuration,RemainingFloat,BLPlannedCost,AtCompletionLaborCost,Critical,PlannedLaborCost,EarnedValueCost,CreateDate,StartDate,Var1NonLaborCost,AtCompletionNonLaborUnits,ActualThisPeriodLaborCost,CostVarianceIndexLaborUnits,RemainingExpenseCost,PlannedCost,AccountingVarianceLaborUnits,PerformancePercentComplete,BLDuration,SchedulePercentComplete,ToCompletePerformanceIndex,CostPercentOfPlanned,PhysicalPercentComplete,ActualUnits,PlannedNonLaborCost,CostVarianceIndex,PrimaryResourceShortName,AtCompletionMaterialCost,AtCompletionUnits,AtCompletionLaborUnits,ActualDuration,RemainingNonLaborCost,EstimateToCompletionLaborUnits,SchedulePerfIndexLaborUnits,CostPercentComplete,ActualProgressDate,BLPlannedNonLaborCost,CostVarianceLaborUnits,OwnerName,RemainingCost,CostPerformanceIndex,CalendarName,Var1Cost,AtCompletionNonLaborCost,VarFinishDate,VarLaborUnits,BLFinishDate,SchedulePerformanceIndex,BudgetAtCompletion,Var1LaborCost,PlannedExpenseCost,MaterialCostPercentComplete,BLPlannedLaborUnits,CostPerformanceIndexLaborUnits,DataDate,EstimateAtCompletionCost,VarNonLaborCost,AtCompletionCost,ScheduleVarianceIndex,AccountingVariance,VarMaterialCost,BLPlannedExpenseCost,VarDuration,Var1LaborUnits,Var1StartDate,Var1FinishDate,LaborUnitsCompletePercent,LaborCostPercentComplete,Var1Duration)
SEVERE: 2017-11-22 10:58:12:[TASK]:[Activity]: [22] CORE(BRE): Object: 218663 Failed to load
com.primavera.PhoenixException: Error calculating Finish Date
Start Date: 2017-05-05 Duration: 5385600000
Remaining Millis: 5385600000 Last Day: java.util.GregorianCalendar[time=185540377957200000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Europe/Moscow",offset=10800000,dstSavings=0,useDaylight=false,transitions=79,lastRule=null],firstDayOfWeek=2,minimalDaysInFirstWeek=1,ERA=1,YEAR=5881510,MONTH=6,WEEK_OF_YEAR=28,WEEK_OF_MONTH=2,DAY_OF_MONTH=10,DAY_OF_YEAR=191,DAY_OF_WEEK=1,DAY_OF_WEEK_IN_MONTH=2,AM_PM=0,HOUR=8,HOUR_OF_DAY=8,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=10800000,DST_OFFSET=0] DayWorkMap: {}
at com.primavera.infr.calendar.CalendarUtil.getFinishDate(CalendarUtil.java:1115)
at com.primavera.infr.calendar.CalendarUtil.getFinishDate(CalendarUtil.java:1163)
at com.primavera.bo.rules.calc.AssignmentCE.calc_ResourceAssignmentSpread(AssignmentCE.java:1851)
at com.primavera.bo.schema.dispatch.AssignmentCEDispatch.dispatch(AssignmentCEDispatch.java:127)
at com.primavera.bo.rules.calc.AssignmentCE.dispatch(AssignmentCE.java:169)
at com.primavera.bo.base.CalculateEngineImpl.getObjects(CalculateEngineImpl.java:4324)
at com.primavera.bo.base.CalculateEngineImpl.getObjects(CalculateEngineImpl.java:4053)
at com.primavera.bo.base.server.ServerDAOImpl.load(ServerDAOImpl.java:420)
at com.primavera.bo.base.server.ServerDAOImpl.load(ServerDAOImpl.java:348)
at com.primavera.bo.spread.ActivitySpreadCalculator.a(ActivitySpreadCalculator.java:1756)
at com.primavera.bo.spread.ActivitySpreadCalculator.calculateActivitySpreads(ActivitySpreadCalculator.java:294)
at com.primavera.bo.rules.calc.ActivityCE.calc_ActivitySpread(ActivityCE.java:5287)
at com.primavera.bo.schema.dispatch.ActivityCEDispatch.dispatch(ActivityCEDispatch.java:73)
at com.primavera.bo.rules.calc.ActivityCE.dispatch(ActivityCE.java:119)
at com.primavera.bo.base.CalculateEngineImpl.getObjects(CalculateEngineImpl.java:4324)
at com.primavera.bo.base.CalculateEngineImpl.getObjects(CalculateEngineImpl.java:4053)
at com.primavera.bo.base.server.ServerDAOImpl.load(ServerDAOImpl.java:420)
at com.primavera.bo.base.server.ServerDAOImpl.load(ServerDAOImpl.java:348)
at com.primavera.px.reader.PxServiceActivityReader.getBusinessObjects(PxServiceActivityReader.java:65)
at com.primavera.px.common.PxServiceBoTaskImpl$PxServiceBoTaskUnit.attemptToProcessForPageSize(PxServiceBoTaskImpl.java:307)
at com.primavera.px.common.PxServiceBoTaskImpl$PxServiceBoTaskUnit.attemptToProcessForPageSize(PxServiceBoTaskImpl.java:341)
at com.primavera.px.common.PxServiceBoTaskImpl$PxServiceBoTaskUnit.execute(PxServiceBoTaskImpl.java:285)
at com.primavera.px.common.PxServiceBoTaskImpl.c(PxServiceBoTaskImpl.java:227)
at com.primavera.px.common.PxServiceBoTaskImpl.a(PxServiceBoTaskImpl.java:181)
at com.primavera.px.common.PxServiceBoTaskImpl.executeTask(PxServiceBoTaskImpl.java:147)
at com.primavera.px.common.PxAbstractServiceTask.execute(PxAbstractServiceTask.java:110)
at com.primavera.px.common.PxAbstractServiceTask.execute(PxAbstractServiceTask.java:28)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(ThreadPoolImpl.java:343)
at java.lang.Thread.run(Thread.java:748)
SEVERE: 2017-11-22 10:58:12:[TASK]:[Activity]: [22] CORE(BRE): Failed Ids = [218663]
2017-11-22 10:58:12:[TASK]:[PxServiceActivityReader]: [22] CORE(BRE): (Class: Activity) (Filter: ((ProjectId = 440)) AND (ActivityId >= 218664) and (ActivityId <= 218668) ORDER BY ActivityId) (Fields: Var1NonLaborUnits,UnitsPercentComplete,AtCompletionExpenseCost,PlannedValueLaborUnits,PrimaryResourceName,Var1ExpenseCost,PlannedValueCost,Var1MaterialCost,DurationPercentOfPlanned,ActualExpenseCost,NonLaborUnitsCompletePercent,PlannedMaterialCost,VarCost,BLPlannedNonLaborUnits,ScheduleVarianceLaborUnits,RemainingMaterialCost,BLPlannedMaterialCost,NonLaborCostPercentComplete,VarianceAtCompletionLaborUnits,RemainingUnits,ActualNonLaborCost,BLStartDate,ActivityId,VarLaborCost,ActualLaborCost,VarExpenseCost,VarNonLaborUnits,ScheduleVarIndexLaborUnits,OwnerId,EstimateToComplete,VarStartDate,RemainingLaborCost,WbsName,WbsShortName,EstimateAtCompletionLaborUnits,DurationPercentComplete,AtCompletionDuration,FinishDate,ActualCost,EarnedValueLaborUnits,PercentComplete,ActualMaterialCost,CostVariance,PlannedUnits,ScheduleVariance,VarianceAtCompletion,ActualThisPeriodNonLaborCost,ActualThisPeriodMaterialCost,ExpenseCostPercentComplete,BLPlannedLaborCost,LastUpdateDate,BLPlannedDuration,RemainingFloat,BLPlannedCost,AtCompletionLaborCost,Critical,PlannedLaborCost,EarnedValueCost,CreateDate,StartDate,Var1NonLaborCost,AtCompletionNonLaborUnits,ActualThisPeriodLaborCost,CostVarianceIndexLaborUnits,RemainingExpenseCost,PlannedCost,AccountingVarianceLaborUnits,PerformancePercentComplete,BLDuration,SchedulePercentComplete,ToCompletePerformanceIndex,CostPercentOfPlanned,PhysicalPercentComplete,ActualUnits,PlannedNonLaborCost,CostVarianceIndex,PrimaryResourceShortName,AtCompletionMaterialCost,AtCompletionUnits,AtCompletionLaborUnits,ActualDuration,RemainingNonLaborCost,EstimateToCompletionLaborUnits,SchedulePerfIndexLaborUnits,CostPercentComplete,ActualProgressDate,BLPlannedNonLaborCost,CostVarianceLaborUnits,OwnerName,RemainingCost,CostPerformanceIndex,CalendarName,Var1Cost,AtCompletionNonLaborCost,VarFinishDate,VarLaborUnits,BLFinishDate,SchedulePerformanceIndex,BudgetAtCompletion,Var1LaborCost,PlannedExpenseCost,MaterialCostPercentComplete,BLPlannedLaborUnits,CostPerformanceIndexLaborUnits,DataDate,EstimateAtCompletionCost,VarNonLaborCost,AtCompletionCost,ScheduleVarianceIndex,AccountingVariance,VarMaterialCost,BLPlannedExpenseCost,VarDuration,Var1LaborUnits,Var1StartDate,Var1FinishDate,LaborUnitsCompletePercent,LaborCostPercentComplete,Var1Duration)
2017-11-22 10:58:40:[TASK]:[Projwbs]: [35] CORE(SQL): Statement (1/1) execution time: 00:02:08.504
2017-11-22 10:58:40:[TASK]:[Projwbs]: [35] CORE(SQL): SQL execution time: 00:02:08.520
2017-11-22 10:58:40:[TASK]:[Projwbs]: [35] CORE(SQL): Task completed[2017-11-22 10:58:40]
SEVERE: 2017-11-22 11:18:55:[SERVICE]:[PxService]: null
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:502)
at com.primavera.infr.threadpool.Future.get(Future.java:27)
at com.primavera.px.common.PxService.a(PxService.java:415)
at com.primavera.px.common.PxService.runJob(PxService.java:216)
at com.primavera.jobsvc.common.JobServiceExecutable.c(JobServiceExecutable.java:254)
at com.primavera.jobsvc.common.JobServiceExecutable.a(JobServiceExecutable.java:197)
at com.primavera.jobsvc.common.JobServiceExecutable.execute(JobServiceExecutable.java:137)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(ThreadPoolImpl.java:343)
at java.lang.Thread.run(Thread.java:748)
2017-11-22 11:18:55:[SERVICE]:[PxService]: Job End Time: 2017-11-22 11:18:55
2017-11-22 11:18:55:[SERVICE]:[PxService]: Job Elapsed Time: 00:23:32.107
SEVERE: 2017-11-22 11:18:55:[SERVICE]:[PxService]: Job Status: Сбой
2017-11-22 11:18:55:[SERVICE]:[PxService]: END: Px Service Job


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Publish Project.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot cannot Publish the Project successfully.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms