JR54960: Dataload for AttributeDictionaryAttribute not considering Faceta ble, Searchable, and Merchandisable in the ColumnExclusionList

APAR status

• Closed as program error.

Error description

• During Dataload for AttributeDictionaryAttribute, if any of the
  Facetable, Searchable, or Merchandisable columns are specified
  in the ColumnExclusionList, they are still treated as default
  value of null or 0, and the existing value in the database will
  get overwritten together with the children table records reset.
  

Local fix

• Include the 3 columns: Facetable, Searchable, Merchandisable in
  the Dataload input file.
  

Problem summary

• USERS AFFECTED:
  Dataload user on V7 fixpack 6 and above
  
  PROBLEM ABSTRACT:
  Dataload for AttributeDictionaryAttribute not considering
  Facetable, Searchable, and Merchandisable in the
  ColumnExclusionList
  
  BUSINESS IMPACT:
  If the Dataload input file does not contain any of the 3 columns
   values listed,  they will be reset to the default and will need
   to be updated again through Management Center.
  
  By putting these columns into the ColumnExclusionList, they are
  intended to be excluded for update and therefore preserve their
  existing values in the database.
  
  RECOMMENDATION:
  

Problem conclusion

• Enhance the AttributeDicitionaryAttribute mediator for Dataload
  to support ColumnExclusionList for Facetable, Searchable, and
  Merchandisable.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WC BUS DEV ED W

• Fixed component ID

  5724I3900

Applicable component levels

• R700 PSY

     UP