Collecting MustGather data for Data Load issues

Prepare the following MustGather information before you call HCL Support to help with Data Load issues.

About this task

To enable more tracing detail, add the following parameter to the dataload script: 
-Dpackage_ name.level=FINEST
For example, to enable the database trace with FINE level, specify the following parameter: 
-Dcom.ibm.commerce.foundation.dataload.database.level=FINE
Details on tracing can be found in the Data Load utility documentation.

Procedure

  1. Reproduce the problem.
    1. Include the load order configuration file. For more information, see Configuring the data load order.
    2. Include the wc-dataload-env.xml. Its location is dependent on your local configuration; for more information, see Configuring the data load environment settings.
    3. Include the loader configuration file. For more information, see Configuring the data load order.
    4. Include the Data source file (input CSV file).
    The locations of these files are specified in the Main Configuration File. Here is an example of one:
    <_config:DataLoadConfiguration
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.ibm.com/xmlns/prod/commerce/foundation/config ../../../../xml/config/xsd/wc-dataload.xsd"
xmlns:_config="http://www.ibm.com/xmlns/prod/commerce/foundation/config">>
<!-- Environment File -->
<_config:DataLoadEnvironment configFile="../wc-dataload-env.xml" />

<_config:LoadOrder commitCount="100" batchSize="1" dataLoadMode="Replace">
<_config:property name="firstTwoLinesAreHeader" value="true" />

<!-- Business Object Config file -->
<_config:LoadItem name="ProductDefiningAttributeAndAllowedValues" businessObjectConfigFile="wc-loader-product-defining-attribute-and-allowed-values.xml" >
<!-- Data Source Location (input file) -->
<_config:DataSourceLocation location="ProductDefiningAttributeAndAllowedValues.csv" />
</_config:LoadItem>
</_config:LoadOrder>

</_config:DataLoadConfiguration>
  2. Confirm that the issue was captured.
    Before sending logs to HCL, ensure that the issue being reported was captured.
  3. Collect data.

    Include the general information requested in MustGather: General Issues in WebSphere Commerce as well as the contents of the load log trace file in the /opt/CommerceUtilities/logs directory.