Error 500/Exception When Changing a Cost Plan After New Time Varying Attribute

Products

• Clarity FedRAMP
• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When trying to change an a Finacial Plan, you are receiving an error message.

In Classic UX: Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

In Modern UX: An exception occurred while trying to update an object instance costplan

In the logs, you can observe an error similar to this one:

ERROR [...]
com.niku.union.odf.exception.ODFServiceException: An exception occurred while trying to update an object instance costplandetail

[...]

Caused by: com.niku.union.odf.exception.ODFException: Error updating tsv attributes for costplandetail instance
 at com.niku.odf.object.Utils.sliceTimeVaryingAttributes(Utils.java:5429)

[...]

Caused by: com.niku.union.persistence.PersistenceException: 
SQL error code: 942
Error message: ORA-00942: table or view does not exist

Executed:
 DELETE FROM ODF_SSL_<attribute> WHERE SLICE_REQUEST_ID = ? AND PRJ_OBJECT_ID IN (<id>)

 

Time Slicing job could also be failing.

Environment

Clarity 16.4.1

Cause

Recently, a new Time Varying attribute was created in the environment.

The table ODF_SSL_<attribute> is not found in the system, likely caused by an issue when creating the attribute.

Resolution

Re-create (delete and create) the attribute causing the issue.