ODF-0231 Creating attributes (log: column xxxxx does not exist)

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The following error is found while trying to create an attribute on a custom object.

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

app-ca.log shows the following error:

Caused by: org.postgresql.util.PSQLException: ERROR: column odf_ca_clr_bus_capability.clr_initiatives does not exist
  Position: 17224
 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)

Cause

When the attribute was created the referenced object table was not updated accordingly

Resolution

Looking at the object list, the attribute is present and exists, but looking at the DB table the column does not exist

select * from odf_custom_attributes where object_name = 'clr_bus_capability' and column_name = 'clr_initiatives' >>> the attribute exists

select clr_initiatives from odf_ca_clr_bus_capability >>> the column does not exist

Remove the custom attribute: 

delete from odf_custom_attributes where object_name = 'clr_bus_capability' and column_name = 'clr_initiatives'

Additional Information

Please also see:

ODF-0231 while creating an attribute

Error ODF-0231 When Creating Object Attribute

ODF-0231 Error When Updating Attribute Properties