MUX - Staffing Module error on "Collapse All"
search cancel

MUX - Staffing Module error on "Collapse All"

book

Article ID: 270050

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When using the Staffing module, and attempting to use the "Collapse All" option an error is displayed "An error occurred while saving preferences", but it will correctly collapse the information.

STEPS TO REPRODUCE: 

1. Access the Staffing module in the MUX
2. Expand an Investment in the list (or expand multiple)
3. Right click in the grid and select "Collapse All"


Expected Results: 

It should collapse without error

Actual Results:

It collapses all but displays error.

In Browser Console the returned packet shows:

{
    "resourceId": null,
    "httpStatus": "400",
    "errorMessage": "ODF-0015: Value must be unique.",
    "errorCode": "odf.uniqueIndexViolation"
}

Error in app-ca.log:

Caused by: Error : 1, Position : 0, Sql = insert into cmn_ui_personalizations(id,component,personalizations,user_id,created_date,created_by,last_updated_date,last_updated_by) values(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ), OriginalSql = insert into cmn_ui_personalizations(id,component,personalizations,user_id,created_date,created_by,last_updated_date,last_updated_by) values(?,?,?,?,?,?,?,?), Error Msg = ORA-00001: unique constraint (<host>.CMN_UI_PERSONALIZATIONS_U1) violated
ERROR rest.validation (clarity:admin:5355135__6BAC85C1-8D44-4C7E-AB85-6C4C8DB41949:PPM_REST_API) ODFResourceProvider :: Could not create resource. Object code alias: [ requestUrl: http://HOSTNAME/ppm/rest/v1/private/views , _restResourceName : views , _id : null , _parentInfo : null , _apiVersion : v1 , _includeLinksArray : true , _contextId : -1 , _hierarchyId : -1 , _isGroupBy : false , _isPartition : false]
ERROR rest.validation (clarity:admin:5355135__6BAC85C1-8D44-4C7E-AB85-6C4C8DB41949:PPM_REST_API) ExceptionInfo ::  Could not create resource. Resource name: views. Error code: odf.uniqueIndexViolation Error message: ODF-0015: Value must be unique.
ERROR object.CustomObjectInstanceClass (clarity:admin:5355135__6BAC85C1-8D44-4C7E-AB85-6C4C8DB41949:PPM_REST_API) Exception on insert
com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<host>.CMN_UI_PERSONALIZATIONS_U1) violated

Environment

Release : 16.1.2

Resolution

The resolution for this problem is slated for inclusion in 16.2.0. It was originally tracked DE70960.

The items will collapse even though there is an error.