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

Subscribe

You can track all active APARs for this component.

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 number

    JR42962

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-31

  • Closed date

    2012-12-04

  • Last modified date

    2012-12-04

  • 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



Document information


More support for:

WebSphere Commerce Enterprise

Software version:

7.0

Reference #:

JR42962

Modified date:

2012-12-04

Translate my page

Content navigation