ODF-0231 Error When Updating Attribute Properties

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When attempting to change the properties of Data Warehouse attribute. e.g, changing maximum size of a custom string attribute on the Investment object and clicking on Save, the change is saved, but the following error is thrown: 

ERROR ODF-0231: Serious error on inserting or updating object attribute, contact system administrator

The app-ca logs include the following error: 

[http-nio-80-exec-11] niku.xql2 (clarity:admin:11702019__5BD3566D-1D55-4726-B70A-00DA378369F3:odf.updateObjectDefinitionAttribute) Database Error thrown 
com.niku.union.persistence.PersistenceException: 
SQL error code: 15165 
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Could not find object 'dwh_inv_v' or you do not have permission.

Environment

Clarity 15.9.3

Resolution

This error will occur if the attribute is checked to 'Include in the Data Warehouse' and an attempt is made to change the attribute details. To avoid this error, first exclude the attribute from the Data Warehouse, make the change to the attribute and save. Once this change is saved, then check the 'Include in the Data Warehouse' option and save again. 

Additional Information

Please also see:

ODF-0231 while creating an attribute

Error ODF-0231 When Creating Object Attribute