FIX: Data Warehouse Cannot Import Transaction Data

Hotfix Download Available
View and request hotfix downloads

View products that this article applies to.

This article was previously published under Q329396

Expand all | Collapse all

SYMPTOMS

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

Back to the top

CAUSE

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

Back to the top

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 (http://support.microsoft.com/kb/328814/ ) How to obtain the latest Commerce Server 2002 service pack

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support (http://support.microsoft.com/contactus/?ws=support)

Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Back to the top

STATUS

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

Back to the top

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

Back to the top