Troubleshooting WebSphere Commerce Analyzer: Recover from a load operation that failed because of a data problem

To recover from a load operation that failed because of data problem, do the following:

1. Follow the instructions in A step fails during initial replication and ETL.
   1. If the loaded table is in the load pending state, remove it from this state by running load again using the TERMINATE option. The syntax is similar to the load insert command in the file WCA_installdir/temp/wca_load.bat:

      db2 load from D:\WCA\tmp\wca_load.ixf of ixf messages 
          D:\WCA\tmp\wca_loadimp.msg TERMINATE INTO 
          tablesname ( column1, column 2, 
          ,,,) for exception wcaexcpt.tablesname 
      

   2. If the loaded table is in the check pending state it has table check constraints or referential integrity constraints defined against it.
      1. To remove the check pending state, use the SET INTEGRITY statement,
         db2 set integrity for tablename immediate checked
      2. Restart the failed step by clicking Start WCA in the WebSphere Commerce Analyzer Runtime window. For more information, see Run replication and ETL

Related concepts

• Replication and extract, transform, and load (ETL) processes

Related tasks

• Run replication and ETL

Related reference

• Troubleshooting WebSphere Commerce Analyzer

(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.