How to make inherited mandatory field optional in child table (Dictionary Override error)

[vaishali231]

I'm trying to make the inherited number field non-mandatory in a child table (u_inherit_custom_table_incident). The parent table has number as mandatory, and it's inherited that way.

When I try to create a Dictionary Override, I get this error:

java.sql.BatchUpdateException: (conn=4013) Duplicate entry 'u_inherit_custom_table_incident-u_number' for key 'name'
Error MessageInvalid insert

[Tim Kulhavy]

Do you already have a dictionary override for this field? Can you share a screenshot of what the Dictionary Overrides related list looks like on the Dictionary Entry record for your field?

[Hristo Ivanov]

As Tim mentioned, this error is due to the reason that only one dictionary override can exist for a given table-element pair. 

If you really don't see an override, someone may have created a dictionary entry instead of an override, go to System Definition > Dictionary and check if there's a record for your table/field