My Oracle Support Banner

Error While Calling ReadActivities On ActivityService Web Service (Doc ID 2676993.1)

Last updated on JULY 14, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 19.12 to 19.12.4.0 [Release 19.12]
Primavera Web Services - Version 19.12 to 19.12.4.0 [Release 19.12]
Information in this document applies to any platform.

Symptoms

When attempting to call the ReadActivities method on the ActivityService it was noticed that this works for some projects, but fails on other projects.

The error generated is

Invalid database request (DBEngineException). Please see server logs for more details. (Fault Detail is equal to IntegrationFaultType)


STEPS TO REPRODUCE
-----------------------
The issue can be reproduced at will with the following steps:
1. Calling the ReadActivities method on the ActivityService web service. For the following activity fields, the Read Activity does not work:

  //ActivityFieldType.BaselineStartDate,
  //ActivityFieldType.BaselineFinishDate,
  //ActivityFieldType.DurationType,
  //ActivityFieldType.PercentCompleteType,
  //ActivityFieldType.LocationName,
  //ActivityFieldType.CalendarName,
  //ActivityFieldType.StartDateVariance,
  //ActivityFieldType.FinishDateVariance,
  //ActivityFieldType.PercentCompleteType,
  //ActivityFieldType.SchedulePercentComplete,
  //ActivityFieldType.UnitsPercentComplete,
  //ActivityFieldType.BaselineDuration,
  //ActivityFieldType.DurationPercentComplete,
  //ActivityFieldType.DurationVariance,
  //ActivityFieldType.MinimumDuration,
  //ActivityFieldType.MaximumDuration,
  //ActivityFieldType.MostLikelyDuration,
  //ActivityFieldType.PlannedDuration,
  //ActivityFieldType.RemainingDuration,
  //ActivityFieldType.AtCompletionDuration,
  //ActivityFieldType.PrimaryResourceName,
  //ActivityFieldType.PrimaryConstraintDate,
  //ActivityFieldType.BaselinePlannedTotalCost,
  //ActivityFieldType.CostPerformanceIndex,
  //ActivityFieldType.SchedulePerformanceIndex,
  //ActivityFieldType.CostPercentComplete,
  //ActivityFieldType.EarnedValueCost,
  //ActivityFieldType.CostVariance,
  //ActivityFieldType.EstimateAtCompletionCost,
  //ActivityFieldType.TotalCostVariance,
  //ActivityFieldType.WBSNamePath,

2. Notice the error


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