Troubleshooting WebSphere Commerce Analyzer: Time stamp out of range

If the time stamp is out of range of the extraction time cutoff, the new shopping data did not get processed because the time stamp is out of range of the extraction time cutoff. To recover the data that is missing, complete these steps:

1. Type db2 connect todatabase where the database is the name of your local data mart.
2. Type db2 update wca.parameters set param_value = (select varchar(min(lastsuccess)) from asn.ibmsnap_subs_set) where param_type= 'TIME_CUT_OFF_PREV'
3. Restart the WebSphere Commerce Analyzer ETL by doing the following:
   1. On the WebSphere Commerce Analyzer server, from the Start menu, select Programs > IBM WCA> Run WebSphere Commerce Analyzer. The WebSphere Commerce Analyzer Runtime window opens.
   2. Select Debug.
   3. Click Reset Error Status.
   4. Reselect Normal.
   5. Click Start WCA to re-run the 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.