Microsoft KB Archive/329396

= FIX: Data Warehouse Cannot Import Transaction Data =

Article ID: 329396

Article Last Modified on 9/27/2005

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition

-



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

Keywords: kbbug kbfix kbqfe kbhotfixserver KB329396

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.