542 views

Description

If a glide.list field created on one instance is transferred via update set to another instance, its sys_storage_alias record is not pointing to the correct database field. Instead of pointing to a medium  text field it points to a varchar field. Because this field now allows only one sys_id to be stored, adding multiple items to the list is not possible.

 

Steps to Reproduce

  1. Create a new update set and set it as current.
  2. Create a List type field on Incident table referencing Users table with max_length = 32.
  3. Check sys_storage_alias and confirm that on the database, it is linked to a field on task table defined as mediumtext.
  4. Complete the update set and transfer it to another instance.
  5. Check the sys_storage_alias and see whether it has been linked to a field on the database defined as anything other than mediumtext, for example, varchar(32).

Workaround

This problem was fixed in Istanbul, which is no longer supported.

In order to fix an already affected field, please open an incident for SN support to apply the required dictionary change.

In order to prevent the issue on an instance not yet upgraded, create a BEFORE INSERT and UPDATE business rule on sys_dictionary of source and target instances with:

  • Order: between 50 and 100
  • Advanced: true
  • Condition: current.internal_type == 'glide_list' && current.max_length < 256
  • Script: current.max_length = 4000;

This will prevent the issue by creating an update set entry with correct max_length on the source instance and also ensure correct creation or an update of a Dictionary record manually or when an update set is committed on a target instance.

 

 


Related Problem: PRB645057

Seen In

Eureka Patch 10 Hot Fix 1
Eureka Patch 11
Eureka Patch 13 Hot Fix 2
Eureka Patch 13 Hot Fix 5
Fuji Patch 10
Fuji Patch 12 Hot Fix 1
Fuji Patch 13 Hot Fix 1
Fuji Patch 3
Fuji Patch 7 Hot Fix 5
Geneva Patch 3 Hot Fix 2
Geneva Patch 5
Geneva Patch 7

Fixed In

Istanbul

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-09-16 07:15:33
Published:2018-09-16