ODF-0231 and odf_inv_snapshot_v2 view

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

ODF-0231 error when changing an attribute size if this is part of the odf_inv_snapshot_v2 view

STEPS TO REPRODUCE:

1. Run the following statement:
select * from odf_inv_snapshot_v2
2. Get a custom attribute that is part of the above view
3. Go to the investment object and edit the custom attribute found, example my_inv_field
4. Change the maximum size of the field by a higher value

Expected Results: The attribute size changes to save
Actual results: ODF-0231: Serious error on inserting or updating object attribute, contact system administrator

app-ca.log file states:
ERROR 2024-03-01 09:46:21,123 [http-nio-8080-exec-269] xql2.xbl (clarity:admin:51405907__18EAF74A-EA18-4C4D-B232-C8138FC0615B:odf.updateObjectDefinitionAttribute) (ecc95bdb-6f35-413b-9349-c746d1ae3651) Stacktrace java.lang.Exception: System error. Contact system administrator.
......
Caused by: org.postgresql.util.PSQLException: ERROR: cannot alter type of a column used by a view or rule
  Detail: rule _RETURN on view odf_inv_snapshot_v2 depends on column "my_inv_field"

Environment

Clarity PPM 16.2.0, 16.2.1

Cause

This is caused by DE79838

Resolution

This is fixed in 16.2.2