My Oracle Support Banner

Primavera P6 Web Services ReadActivities Fails When Including Baseline Fields (Doc ID 2836240.1)

Last updated on JANUARY 27, 2022

Applies to:

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

Symptoms

When attempting to run P6 Web Services ReadActivities and including baseline fields, the following error occurs for large projects.

ERROR
-----------------------
Invalid database request (DBEngineException). Please see server logs for more details.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a ReadActivities request with baseline fields:

    <ReadActivities>
        <Field>ProjectId</Field>
        <Field>WBSCode</Field>
        <Field>Id</Field>
        <Field>Name</Field>
        <Field>StartDate</Field>
        <Field>FinishDate</Field>
        <Field>LateStartDate</Field>
        <Field>LateFinishDate</Field>
        <Field>PlannedDuration</Field>
        <Field>TotalFloat</Field>
        <Field>PerformancePercentComplete</Field>
        <Field>CalendarObjectId</Field>
        <Field>DataDate</Field>
        <Field>LastUpdateDate</Field>
        <Field>SchedulePercentComplete</Field>
        <Field>BaselineStartDate</Field>
        <Field>BaselineFinishDate</Field>
        <Field>EarlyStartDate</Field>
        <Field>EarlyFinishDate</Field>
        <Field>DurationType</Field>
        <Field>ObjectId</Field>
        <Field>ExpectedFinishDate</Field>
        <Filter>ProjectId= 'Test'</Filter>
   </ReadActivities>


  
2. The request fails.
3. Remove baseline fields and the request succeeds.

    <ReadActivities>
        <Field>ProjectId</Field>
        <Field>WBSCode</Field>
        <Field>Id</Field>
        <Field>Name</Field>
        <Field>StartDate</Field>
        <Field>FinishDate</Field>
        <Field>LateStartDate</Field>
        <Field>LateFinishDate</Field>
        <Field>PlannedDuration</Field>
        <Field>TotalFloat</Field>
        <Field>CalendarObjectId</Field>
        <Field>DataDate</Field>
        <Field>LastUpdateDate</Field>
        <Field>EarlyStartDate</Field>
        <Field>EarlyFinishDate</Field>
        <Field>DurationType</Field>
        <Field>ObjectId</Field>
        <Field>ExpectedFinishDate</Field>
        <Filter>ProjectId= 'Test'</Filter>
   </ReadActivities>


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.