Default Value in Attribute can not be cleared

book

Article ID: 142169

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Trying to change the default value of a custom attribute in Project Object, with a default value defined.

When trying to clear the Default Value field, it gets populated again automatically with the previous value.

Cause

This problem is sometimes caused by an entry stored on the table odf_default_overrides table for that attribute.

Environment

Clarity PPM 15.x

Resolution

If there is an entry on the table for that attribute, the solution would be to delete it having the services stopped.


1. Stop Clarity services

2. Connect to database and execute this delete statement:

delete from odf_default_overrides where object_code='project' and attribute_code='attribute_id';

commit;

3. Start Clarity services