CA PPM: ODF-0231 Error When Updating Attribute Properties


Article ID: 127156


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


When attempting to change the 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: 

ERROR 2019-02-05 14:38:56,053 [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. 


Release: CODFSS99000-15.3-PPM SAAS FedRAMP-Sandbox-Small Environment


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.