When Loading Relationships Using P6 Web Services a Timeout Occurs (Doc ID 3006016.1)

Last updated on FEBRUARY 23, 2024

Applies to:

Symptoms

When attempting to run a P6 Web Services request to retrieve relationships, a timeout occurs or performance is very slow.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a request to read relationships
p6ws/services/RelationshipService

<v1:ReadRelationships>
<!--1 or more repetitions:-->
<v1:Field>ObjectId</v1:Field>
<v1:Field>PredecessorActivityObjectId</v1:Field>
<v1:Field>SuccessorActivityId</v1:Field>
<v1:Field>SuccessorActivityObjectId</v1:Field>
<v1:Field>Type</v1:Field>
<v1:Field>Lag</v1:Field>
<v1:Field>SuccessorProjectId</v1:Field>
<v1:Field>PredecessorWbsShortName</v1:Field>
<v1:Field>PredecessorActivityId</v1:Field>
<v1:Field>PredecessorProjectId</v1:Field>
<v1:Field>PredecessorProjectObjectId</v1:Field>
<v1:Field>SuccessorProjectObjectId</v1:Field>
<v1:Filter>PredecessorProjectObjectId=4875</v1:Filter>
<!--<v1:OrderBy>?</v1:OrderBy>-->
</v1:ReadRelationships>


2. The above request runs quickly.
3. Add WBS fields to the request
<v1:ReadRelationships>
<!--1 or more repetitions:-->
<v1:Field>ObjectId</v1:Field>
<v1:Field>PredecessorActivityObjectId</v1:Field>
<v1:Field>SuccessorActivityId</v1:Field>
<v1:Field>SuccessorActivityObjectId</v1:Field>
<v1:Field>Type</v1:Field>
<v1:Field>Lag</v1:Field>
<v1:Field>SuccessorProjectId</v1:Field>
<v1:Field>PredecessorWbsShortName</v1:Field>
<v1:Field>PredecessorWbsName</v1:Field>
<v1:Field>SuccessorWbsName</v1:Field>
<v1:Field>PredecessorActivityId</v1:Field>
<v1:Field>PredecessorProjectId</v1:Field>
<v1:Field>PredecessorProjectObjectId</v1:Field>
<v1:Field>SuccessorProjectObjectId</v1:Field>
<v1:Filter>PredecessorProjectObjectId=4875</v1:Filter>
<!--<v1:OrderBy>?</v1:OrderBy>-->
</v1:ReadRelationships>

4. Request becomes much slower and in some cases times out.

Changes

Cause

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