Only part of the data is imported to the Data Warehouse when you run a Transaction Data Import DTS task in Commerce Server 2002 (890913)


The information in this article applies to:

  • Microsoft Commerce Server 2002

SYMPTOMS

In Microsoft Commerce Server 2002, when you run a Transaction Data Import DTS task to import all transaction data to the Data Warehouse, you notice that only part of the transaction data is imported. The number of rows that are in the OrderFormLineItems table of the Commerce Server transaction database is less than the number of rows that are in the OrderFormLineItems table of the Commerce Server Data Warehouse database.

CAUSE

This problem may occur if all the following conditions are true:
  • In the Transaction Import Properties dialog box for the Transaction Data Import DTS task, you click Full under Processing mode.

    Note When you click Full under Processing mode, the import operation performs a "full load" import of your transaction data.
  • In the Transaction Import Properties dialog box of the Transaction Data Import DTS task, a non-zero query interval value is set.

    Note By default, the Transaction Import Properties dialog box has a query interval value of 25 minutes.
  • Large time differences exist in the dates of the transactions that are in your transaction data.
In this scenario, a logic error may occur when you run the task to import your transaction data. Therefore, only a subset of the records may be imported to the Data Warehouse.

WORKAROUND

To work around this problem, set the query interval to 0 in the Transaction Data Import DTS task. When you set the query interval to 0, all the records are correctly imported to the Data Warehouse. To set the query interval to 0 in the Transaction Data Import DTS task, follow these steps:
  1. Start SQL Server Enterprise Manager.
  2. Expand Microsoft SQL Servers, expand SQL Server Group, and then expand the server on which your Data Warehouse is hosted.
  3. Follow one of these steps:
    • If you want to create a new package, right-click Data Transformation Services, and then click New Package.
    • If you want to modify an existing package, right-click Data Transformation Services, and then click Open Package. Click the package that you want to modify, and then click Open.
  4. On the Task menu, click Transaction data import (Commerce Server).
  5. In the Query interval(mins.) box, type 0, and then click OK.
  6. To run this package, click Execute on the Package menu.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MajorLast Reviewed:3/31/2005
Keywords:kbtshoot kbbug KB890913 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.