Can't Change Project Attribute Status Reporting Default Value

[JEC]

'Status Reporting' is a lookup attribute under project object. Whenever I tried to change the default value from 'Not Required' to 'Required' and hit save, it will restore back to 'Not Required'. For some reason, I can't change/override the default value. Tried toggling options like 'POPULATE NULL VALUES WITH THE DEFAULT' and 'Read Only' but none helps.

[Jose Ignacio Mugica]

Hi,
Could you check the following table?
select * from odf_default_overrides where object_code='project' and attribute_code='youraffectedattributeid';
Do you find your attribute there?
If there is an entry:
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='youraffectedattributeid'
commit;
3. Start Clarity services
You should now be able to set a new default.
regards
Joxi

[JEC]

I haven't tried the suggestion but I think it should work. My workaround is going to the view and there is an OVERRIDE DEFAULT option for this field.