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.

This can happen to any attribute/object with a default value set

Cause

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

Environment

Release: All Supported

Component: Clarity Studio

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

Additional Information

See also Department OBS Default value on project object cannot be changed