JR44538: CMVC 224701 - ADDRESS DATALOAD LIMITATION DUE TO LOADING OF AD ATTRIBUTES WITH 'SEARCHABLE' AND 'FACETABLE' COLUMNS

APAR status

• Closed as program error.

Error description

• When trying to populate data in SEARCHABLE and FACETABLE columns
  in ATTR the dataload utility fails with error, for example:
  
  com.ibm.commerce.foundation.dataload.exception.DataLoadSQLExcept
  ion: The ID was not resolved for the table SELECT STOREENT_ID
  FROM ATTR WHERE ATTR_ID = ?  with the unique index data
  7000000000000012901.
   at
  com.ibm.commerce.catalog.dataload.mediator.AttributeDictionaryAt
  tributeMediator.populateSRCHATTR(AttributeDictionaryAttributeMed
  iator.java:573)
  
  because the ATTR row is not committed to the database yet.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0 using dataload to dataload
  Attribute Dictionary (AD) attributes and populate SEARCHABLE and
  FACETABLE columns in ATTR table.
  
  PROBLEM ABSTRACT:
  Loading Attribute Dictionary (AD) attributes fails to populate
  SEARCHABLE and FACETABLE columns in ATTR table
  
  BUSINESS IMPACT:
  Dataload for Attribute Dictionary (AD) fails and needs
  troubleshooting.
  
  RECOMMENDATION:
  

Problem conclusion

• Included xpaths for the SEARCHABLE and FACETABLE columns in ATTR
  table in the loader configuration.
  Enabled the dataload mediator code to populate SEARCHABLE and
  FACETABLE columns in ATTR table and related tables.
  
  -------------------------------------------------------------
  The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
  http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

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 EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP