My Oracle Support Banner

Error: 'Error Calculating Finish Date' When Publishing Projects Or Exporting To XML Format (Doc ID 2359858.1)

Last updated on MARCH 16, 2020

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

Symptom 1:

When the Project is Published, the following failure occurs:

ERROR

<date>:[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: <date>:[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: <date>:[TASK]:[Activity]: [22] CORE(BRE): Failed Ids = [218663]
<date>:[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)
<date>:[TASK]:[Projwbs]: [35] CORE(SQL): Statement (1/1) execution time: 00:02:08.504
<date>:[TASK]:[Projwbs]: [35] CORE(SQL): SQL execution time: 00:02:08.520
<date>:[TASK]:[Projwbs]: [35] CORE(SQL): Task completed[2017-11-22 10:58:40]
SEVERE: <date>:[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)
<date>:[SERVICE]:[PxService]: Job End Time: 2017-11-22 11:18:55
<date>:[SERVICE]:[PxService]: Job Elapsed Time: 00:23:32.107
SEVERE: <date>:[SERVICE]:[PxService]: Job Status: Сбой
<date>:[SERVICE]:[PxService]: END: Px Service Job

STEPS

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

Symptom 2:

When attempting to export to XML format, the following error is seen in the failed job log file:

ERROR

Error calculating Finish Date
Start Date: 2019-01-29 Duration: 576000000
Remaining Millis: 576000000 Last Day: java.util.GregorianCalendar[time=185540377986000000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT-05:00",offset=-18000000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=5881510,MONTH=6,WEEK_OF_YEAR=29,WEEK_OF_MONTH=3,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=-18000000,DST_OFFSET=0] DayWorkMap: {}

STEPS

  1. Sign in to P6 Pro Client
  2. Open a project
  3. Export to P6 XML format
  4. Check the failed job log for the error details

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.