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 }--

For example, the issue occurs when creating a Dictionary Override for the field [update_actual_effort_from_time_card] on [tsp2_project] under Preferences. The override is created, but generates an *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 in Madrid. If you are able to upgrade, review the Fixed In section to determine the latest version with a permanent fix your instance can be upgraded to.


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-10-21 09:07:23