API-1003 error importing investments into Hierarchies

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When importing projects to hierarchies the following error is displayed.

API-1003 : Could not find resource investments.

Why?

The app-ca.log file shows the following errors on the app-ca.log file

ERROR 2024-08-30 02:30:31,127 [http-nio-1622-exec-782] odf.ObjectController (clarity:myuser:myclaritysession:PPM_REST_API) (c9c2ae2f-19eb-4e13-99f0-72ec25398b9a) Error occurred trying to materialize object "inv"

com.niku.union.odf.exception.ODFException: error interpreting object associations

at com.niku.odf.object.AbstractODFMetaData.resolveHierachyObjectAssociations(AbstractODFMetaData.java:5715)

.....

Caused by: java.lang.NullPointerException: Cannot invoke "com.niku.union.odf.object.Attribute.getExtendedType()" because "attr" is null

 

ERROR 2024-08-30 02:30:33,915 [http-nio-1622-exec-782] ppm.rest (clarity:myuser:myclaritysession:PPM_REST_API) (c9c2ae2f-19eb-4e13-99f0-72ec25398b9a) 

com.ca.ppm.rest.exception.NotFoundException: API-1003 : Could not find resource investments.

at com.ca.ppm.rest.resource.BaseResourceHandler.throwNotFoundException(BaseResourceHandler.java:1905)

at com.ca.ppm.rest.resource.BaseResourceHandler.validate(BaseResourceHandler.java:1073)

at com.ca.ppm.rest.resource.BaseResourceHandler.populateRequestContext(BaseResourceHandler.java:1044)

Environment

Clarity 16.2.X

Cause

A custom-calculated attribute is corrupted. One of the fields the calculation is based on does not exist and therefore calculation can not be done.

A calculated field was based on the sum of two number-type attributes and one of those had been deleted, invalidating the calculation expression

Resolution

Rebuild the calculated attribute so the expression is valid.

OR

Remove the calculated attribute if it is not needed any longer.

Additional Information

Other relevant error messages that can be found on the app-ca.log file and help identify the calculated field.

ERROR 2024-08-30 02:30:24,985 [http-nio-1622-exec-779] odf.out (clarity:myuser:myclaritysession:PPM_REST_API) (e9133245-ee61-4ddc-a9bf-e3a1b1a3a5d3) Unable to parse expression for calculated attribute: mycalculatedattribute expression: Sum(calc1,calc2)
java.lang.Exception: Invalid attribute calc1
    at com.niku.odf.exprbuilder.calcAttribute.ExpressionTranslator.getTableColumn(ExpressionTranslator.java:1154)
    at com.niku.odf.exprbuilder.calcAttribute.ExpressionTranslator.getTableColumn(ExpressionTranslator.java:1132)