Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 890913 - Last Review: March 31, 2005 - Revision: 1.2
Only part of the data is imported to the Data Warehouse when you run a Transaction Data Import DTS task in Commerce Server 2002
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.
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.
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:
- Start SQL Server Enterprise Manager.
- Expand Microsoft SQL Servers, expand
SQL Server Group, and then expand the server on which your Data
Warehouse is hosted.
- 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.
- On the Task menu, click
Transaction data import (Commerce Server).
- In the Query interval(mins.)
box, type 0, and then click
OK.
- To run this package, click Execute on the
Package menu.
Microsoft has confirmed that this is a bug in the Microsoft products that are
listed in the "Applies to" section.
APPLIES TO
- Microsoft Commerce Server 2002 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate