Project XOG read performance is slow on 13.0.1

Document ID : KB000021218
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

After upgrading to 13.0.1, using XML Open Gateway (XOG) READ action of projects can take a long time.

Steps to Reproduce:

  1. Create a project with some resources, tasks, financial actuals and other relevant data
  2. Create a XOG READ file
    <?xml version="1.0" encoding="UTF-8"?> <NikuDataBus>   <Header version="6.0.11" action="read" objectType="project" externalSource="NIKU">     <args name="include_tasks" value="true" />     <args name="include_resources" value="true" />     <args name="include_custom" value="true" />     <args name="include_dependencies" value="true" />   </Header>   <Query>     <Filter name="projectID" criteria="EQUALS">My Project</Filter>   </Query> </NikuDataBus>
  3. Perform the XOG READ action

Expected Result: For the XOG read action to complete in a reasonable time.
Actual Result:     The XOG read action is very slow and for 1 specific project it took approximately 15 minutes.

Cause:

Caused by CLRT-68180

Resolution:

 

At this time Development team is not planning to make any changes to this area of the product due to the complexity of the root cause.

Workaround: 

There is no alternative workaround for this issue.  

Plan your XOG read actions during non-peak hours.

One recommendation is to split up the XOG read actions based on the arguments you desire. For example, including dependencies can impact the performance of the read action.

  1. Create XOG read file #1 for only one argument value="true" 
  2. Perform the XOG read
  3. Create XOG read file #2 for a different argument value="true"
  4. Repeat steps to generate multiple output files