Clarity: Project XOG read performance is slow on 13.0.1

Posted @ 02/13/2013  03:53 PM By Federico Pena

Description:
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

 

    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>

    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.
Solution:
This issue affects 13.0.1 and 13.1 and is currently being reviewed for a resolution in a future release or patch.

“Solutions provided by CA Technologies”