FIX: Data Warehouse Cannot Import Transaction Data (329396)


The information in this article applies to:

  • Microsoft Commerce Server 2002
This article was previously published under Q329396

SYMPTOMS

When you create a new data warehouse, and then you try to import transaction data and profile data, the tasks fail.

CAUSE

This problem occurs because the transaction import processing does not correctly delimit the GUIDs before passing them to the OLE DB convert method.

RESOLUTION

This problem was first corrected in Commerce Server 2002 Service Pack 2.

To resolve this problem, obtain the latest service pack for Commerce Server 2002. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

328814 How to obtain the latest Commerce Server 2002 service pack

STATUS

Microsoft has confirmed that this is a problem in Commerce Server 2002.

MORE INFORMATION

The following error information appears in the application event log: 
Event Type: Error
Event Source: CSDataWareHouse
Event Category: None
Event ID: 38914
Date: 9/4/2002
Time: 9:36:41 AM
User: N/A
Computer: ComputerName
Description:
Transaction DTS task :Execution failed

Event Type: Information
Event Source: DataTransformationServices
Event Category: None
Event ID: 80
Date: 9/4/2002
Time: 1:37:22 PM
User: N/A
Computer: ComputerName
Description:
The execution of the following DTS Package succeeded:

Package Name: PackageName
Package Description: (null)
Package ID: {2D8A03EA-9544-47D4-981B-536584BC4721}
Package Version: {2E2DCBB5-2517-4993-BCA6-E13946B9A950}
Package Execution Lineage: {7F58223F-8944-4133-9DAE-E24D887DEF02}
Executed On: ComputerName
Executed By: UserName
Execution Started: 9/4/2002 4:34:54 PM
Execution Completed: 9/4/2002 4:37:22 PM
Total Execution Time: 147.891 seconds
Package Steps execution information:
Step 'DTSStep_CS_DTSTransImp.DTSTransactionImport_1' failed
The transaction log also contains the following information: 
Step 'DTSStep_CS_DTSTransImp.DTSTransactionImport_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution.
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:700

Step Execution Started: 9/4/2002 4:34:54 PM
Step Execution Completed: 9/4/2002 4:37:22 PM
Total Step Execution Time: 147.828 seconds
Modification Type:MinorLast Reviewed:9/27/2005
Keywords:kbHotfixServer kbQFE kbbug kbfix kbQFE KB329396
©2004 Microsoft Corporation. All rights reserved.