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 |