ODF-0231 Error When Updating Attribute Properties
search cancel

ODF-0231 Error When Updating Attribute Properties


Article ID: 127156


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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 
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.


Clarity 15.9.3


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

ODF-0231 Creating a new attribute