JR42962: CMVC 222825 - ADD AN OPTION IN DI-PREPROCESS TO IGNORE PARENT CATGROUP BUSINESS DATA CONSTRAINT

APAR status

• Closed as program error.

Error description

• When running di-preprocess.sh, a 'SQLCODE=-803, SQLSTATE=23505'
  db2 error is seen. This is a duplicate key error, and it can be
  thrown when a catentry is in more than one catgroup in the
  Master Catalog.
  
  Normally the duplicate catentry needs to be rooted out and
  removed before di-preprocess can be run again. This can be
  time-consuming, especially if there are multiple catentries that
  are in multiple catgroups.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users with WebSphere Commerce Search sol'n
  enabled
  
  PROBLEM ABSTRACT:
  Adding an additional parameter into preprocess files to be able
  to ignore business logic constraint of having a catentry in more
  than one catgroup in the master catalog.
  
  BUSINESS IMPACT:
  di-preprocess fails unexpectedly
  
  RECOMMENDATION:
  

Problem conclusion

• APAR JR42962 adds the option of adding an 'ignore business
  constraints' parameter when building the temporary tables.
  
  With the APAR installed, to add this parameter, locate the file
  wc-dataimport-preprocess-parent-catgroup.xml in the directory:
  
  <CommerceServer70 install dir>/instances/<instance
  name>/search/pre-processConfig/MC_<master catalog ID>/<database
  type>/
  
  (Note: there can be multiple copies of this file, one for each
  master catalog)
  
  Add the line '<_config:property
  name="masterCatalogContainsCatalogEntriesWithMultipleParents"
  value="true"/>' as follows:
  
  
  <_config:DIHPreProcessConfig
  xmlns:_config="http://www.ibm.com/xmlns/prod/commerce/foundation
  /config" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.ibm.com/xmlns/prod/commerce/found
  ation/config ../../xsd/wc-dataimport-preprocess.xsd ">
    <_config:data-processing-config
  processor="com.ibm.commerce.foundation.dataimport.preprocess.Cat
  alogHierarchyDataPreProcessor"
     masterCatalogId="10001" batchSize="10000">
      <_config:table definition="CREATE TABLE TI_APGROUP_0
  (CATENTRY_ID BIGINT NOT NULL, CATGROUPS VARCHAR(10240), PRIMARY
  KEY (CATENTRY_ID))" name="TI_APGROUP_0"/>
      <_config:query sql=""/>
      <_config:mapping>
        <_config:key queryColumn="CATENTRY_ID"
  tableColumn="CATENTRY_ID"/>
        <_config:column-mapping>
          <_config:column-column-mapping>
           <_config:column-column queryColumn="CATGROUP_ID"
  tableColumn="CATGROUP"/>
          </_config:column-column-mapping>
          </_config:column-mapping>
      </_config:mapping>
  
     <!--Add/uncomment line below
          <_config:property
  name="masterCatalogContainsCatalogEntriesWithMultipleParents"
  value="true"/>
      -->
    </_config:data-processing-config>
  </_config:DIHPreProcessConfig>
  
  
  -------------------------------------------------------------
  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