Hello Rich,

I saw similar issues was resolved by this method:

1) Removing the data warehouse site resource in the Commerce Server
Manager/Global Resources
2) Removing the data warehouse global resource in Commerce Server
Manager/Commerce Sites/Site/Site Resources
3) Removing the analysis data warehouse store in the SQL Analysis Servers
snap in
4) Remove the data warehouse database
5) Using the same site package used to unpup the site, add the data
warehouse resource to your existing site. In this step, they had to
manually create a data warehouse database via enterprise manager and then
go through the custom site packager wizard.

You may want to clean web log file to see if it is relate to specific log.

Also, if debug server does not bring any clue on this, to find out the root
cause of this issue we may need to analyze memory dumps, this work has to
be done by contacting Microsoft Product Support Services.

For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

Have a great day!

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:

BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469

Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Thread-Topic: Log Import Error
| thread-index: AcW+19QkSmsttUn/T9edjE3svc4Rdg==
| X-WBNR-Posting-Host: 66.181.92.2
| From: "=?Utf-8?B?Ukxhbm91ZQ==?=" <rlanoue@community.nospam>
| References: <00AABEF1-7E0B-408D-B726-6D20568DF641@microsoft.com>
<d2eVCulvFHA.3020@TK2MSFTNGXA01.phx.gbl>
<8ABEA36B-83FA-48B6-9F14-2F4C60EAACE3@microsoft.com>
| Subject: RE: Log Import Error
| Date: Wed, 21 Sep 2005 11:11:03 -0700
| Lines: 149
| Message-ID: <D15607A1-0EB5-46B7-BDF4-22CEA2C3EBAE@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.dts
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:14907
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| I should have thought of this earlier, I'm going to use the Commerce
Server
| Data Warehouse debug server (Csdwdbgsrv.exe) with an ActiveX script task
| before the Web log import task to collect more infromation on the issue.
|
| - Rich
|
|
[quoted text, click to view]
|
| > Thanks Peter.
| >
| > I already checked out this article and do not beleive that it applies
for
| > this issue. It talks about a new data warehouse, and then you try to
import
| > transaction data and profile data, the tasks fail.
| >
| > My issue is with the web log imports. The transaction and profile
import
| > steps complete successfully. Also note that my DW has been up and
running
| > for almost 3 years, importing daily, without this issue.
| >
| > - Rich
| >
| >
[quoted text, click to view]
| >
| > > Hello Rich,
| > >
| > > It seems you encountered the following known issue. You may want
toobtain
| > > the latest service pack for Commerce Server 2002 to test the
situation:
| > >
| > > 329396 FIX: Data Warehouse Cannot Import Transaction Data
| > > http://support.microsoft.com/?id=329396
| > >
| > > Hope this is helpful.
| > >
| > > Regards,
| > >
| > > Peter Yang
| > > MCSE2000/2003, MCSA, MCDBA
| > > Microsoft Online Partner Support
| > >
| > > When responding to posts, please "Reply to Group" via your newsreader
so
| > > that others may learn and benefit from your issue.
| > >
| > > =====================================================
| > >
| > >
| > > This posting is provided "AS IS" with no warranties, and confers no
rights.
| > >
| > > --------------------
| > > | Thread-Topic: Log Import Error
| > > | thread-index: AcW+B2ZetbPjzes0RFuQPlcU7cc/aw==
| > > | X-WBNR-Posting-Host: 66.181.92.2
| > > | From: "=?Utf-8?B?Ukxhbm91ZQ==?=" <rlanoue@community.nospam>
| > > | Subject: Log Import Error
| > > | Date: Tue, 20 Sep 2005 10:19:04 -0700
| > > | Lines: 71
| > > | Message-ID: <00AABEF1-7E0B-408D-B726-6D20568DF641@microsoft.com>
| > > | MIME-Version: 1.0
| > > | Content-Type: text/plain;
| > > | charset="Utf-8"
| > > | Content-Transfer-Encoding: 7bit
| > > | X-Newsreader: Microsoft CDO for Windows 2000
| > > | Content-Class: urn:content-classes:message
| > > | Importance: normal
| > > | Priority: normal
| > > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > > | Newsgroups: microsoft.public.sqlserver.dts
| > > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:14884
| > > | X-Tomcat-NG: microsoft.public.sqlserver.dts
| > > |
| > > | I have a data warehouse that imports all of the required profile,
| > > | transactions, logs, etc. on a daily basis and has been running
fine. The
| > > | other night, I started to receive the following errors during the
web log
| > > | import.
| > > |
| > > | My package logging shows:
| > > | Step 'DTSStep_CS_DTSLogImps.DTSLogImport_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/19/2005 6:38:35 PM
| > > | Step Execution Completed: 9/19/2005 6:38:44 PM
| > > | Total Step Execution Time: 8.532 seconds
| > > | Progress count in Step: 0
| > > |
| > > | The SQL job logging shows: