If the Column name for a Dictionary entry is over 30 characters long, a usable Dictionary Override cannot be created. What is created has its name truncated to 30 chars, is not related to any [sys_dictionary] record, and it can't be edited in.

No error message is presented to the user on the first attempt of creating the Dictionary Override.

If a second attempt is made to create a Dictionary Override, "Duplicate entry" exception and invalid insert messages are displayed:

--{ java.sql.BatchUpdateException: Duplicate entry 'sc_task-a_field_name_that_exceeds_30_c' for key 'name' }--
--{ Invalid insert }--


Example of a such a field:

The issue can be obverved OOB issue when creating a Dictionary Override for the field "update_actual_effort_from_time_card" on tsp2_project under Preferences. The override will create, but generates a *Undefined(baseRecord.reference_qual) in the Reference qualifier.

Steps to Reproduce

  1. Create a new column that is over 30 characters long, e.g. "a_field_name_that_exceeds_30_chars".
    2. On the Dictionary Overrides related list for the Dictionary entry, click the New button.
    3. Note the symptoms listed above, including truncated column name, e.g. "a_field_name_that_exceeds_30_c".
    4. Select any table, also making a change as an override, and click the 'Submit' button.
    5. View returns to the Dictionary entry form, with an empty Dictionary Overrides list.
    6. If a user makes a second attempt to add the Dictionary Override for the same table, the following error messages are presented:
    --{ java.sql.BatchUpdateException: Duplicate entry 'sc_task-a_field_name_that_exceeds_30_c' for key 'name' }--
    --{ Invalid insert }--
    7. The new [sys_dictionary_override] record can be located, but it cannot be edited in as a related record.


This problem has been fixed. If you are able to upgrade, review the Fixed In or Intended Fix Version fields to determine whether any versions have a planned or permanent fix.

As a workaround, if the columns is still new, create a new one with a shorter name, reworking that into the application, instead.

Another option is to change the max length of the [sys_dictionary_override.element] column in the [sys_dictionary] table to 80.


Related Problem: PRB1262819

Seen In

There is no data to report.

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-07-05 05:12:26