search cancel

Project XOG read performance is slow on 13.0.1

book

Article ID: 21218

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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

 

 



Environment

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component:

Resolution

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