CA PPM: ODF-0231 Error When Updating Attribute Properties

book

Article ID: 127156

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

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

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

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.