XOG fails while updating a project hierarchy due to a possible allocation rounding

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

Problem:

XOG fails while updating a project hierarchy due to a possible allocation rounding.  This is occurring for a project investment that has multiple parent investments and this specific project has different hierarchical allocation percentages with up to 4 decimal point values.

 
Steps to Reproduce:
1. Create 6 Product Investments: prd1, prd2, prd3, prd4, prd5, prd6 
2. Create 1 Project Investment called PR09242 
3. On the Project Hierarchy tab, add the created product investments as parents 
4. On the Allocation field of the hierarchy parents list view, add the following allocation values: 
    prd1 > 62.3597 
    prd2 > 0.251 
    prd3 > 11.6616 
    prd4 > 3.0672 
    prd5 > 4.7389 
    prd6 > 17.9216 
5. Save the changes 
6. The Project total allocation is 100% among all parent investments
7. Use the following XML file to update the hierarchy through XML Open Gateway (XOG). 
   Note the allocation figures are exactly the same (file attached): 
 
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd"> 
  <Header action="write" externalSource="NIKU" objectType="project" version="13.3.0.286"/> 
    <Projects> 
      <Project name="PR09242" projectID="PR09242"> 
        <InvestmentAssociations isComplete="true"> 
          <Allocations> 
            <ParentInvestment InvestmentID="prd1" InvestmentType="product" defaultAllocationPercent="0.623597"/> 
            <ParentInvestment InvestmentID="prd2" InvestmentType="product" defaultAllocationPercent="0.00251"/> 
            <ParentInvestment InvestmentID="prd3" InvestmentType="product" defaultAllocationPercent="0.116616"/> 
            <ParentInvestment InvestmentID="prd4" InvestmentType="product" defaultAllocationPercent="0.030672"/> 
            <ParentInvestment InvestmentID="prd5" InvestmentType="product" defaultAllocationPercent="0.047389"/> 
            <ParentInvestment InvestmentID="prd6" InvestmentType="product" defaultAllocationPercent="0.179216"/> 
          </Allocations> 
        </InvestmentAssociations> 
      </Project> 
    </Projects> 
</NikuDataBus> 
 
Expected Result:  XOG write action updates data correctly without error.  
Actual Result:  The XOG write action fails with error message:  XOG-3669: Investment Object operation failed while processing Investment Associations: insert
 

Environment:

Applies to all supported PAS environments for specified releases.

Cause:

Caused by CLRT-76783

Resolution:

Resolved in CA Clarity PPM 13.3 Generic Patch #11.

NOT Resolved in CA PPM 14.1

Resolved in CA PPM 14.2

Workaround:

Adjust the hierarchy allocation values from the XOG XML so the sum of the allocations equals 100%
 

Additional Information:

Reference TEC605767 : Clarity 13.3.0 Generic Patch available to resolve reported issues

Reference CA PPM Resolved Defects Index for CA PPM 14.2