Default values for Xogged in attributes cannot be edited or deleted

Document ID : KB000046778
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

If you xog in an attribute with a default, it's default value cannot be deleted or edited on the target server.

 

Steps to Reproduce:

 

1. Create a custom object

2. Create a string attribute on that custom object with a default value

Attribute Name: test_default
Attribute ID: test_default
Data Type: String
Default Value: default
Maximum Size: 100

3. Xog out that object

4. Xog it into another environment or in the same environment.

5. Go back to that attribute that you created in the custom object

6. Edit or delete the Default Value

 

 

 

Expected Result:

 

 

Default Value can be edited or deleted successfully/

 

Actual Result:

Default Value cannot be edited or deleted.

 

Resolution/Workaround:

 

Execute and commit the following statement on the database

delete from odf_default_overrides where object_code='<object>' and attribute_code='<attribute>'

 

 

 

where '<object>' is the object code which can be found under Administration, Objects on the properties page for your object in the Object ID field and '<attribute>' can be found on the attribute properties page for your object on the Attributes tab in the Attribute ID field.

 

 

 

NOTE:  OD customers - please open a case with product support to have this fix applied to your system by the On Demand Team.

 

 

 

Additional Information:

Caused by CLRT-81152:  Attributes with default values that are xogged in cannot have their default values edited or deleted.