MS SQL Server DTS - Log Import Error

Author

Log Import Error

RLanoue

2005-09-20, 1:24 pm

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_DTSLogIm
ps.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:
DTSRun OnError: DTSStep_CS_DTSLogImp
s.DTSLogImport_1, Error = -2147220421
(8004043B)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
Error Detail Records:
Error: -2147220421 (8004043B); Provider Error: 0 (0)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700

The application event viewer has the following:
Event Type: Error
Event Source: CSDataWareHo
use
Event Category: None
Event ID: 49176
Date: 9/19/2005
Time: 8:14:49 PM
User: N/A
Computer: INCDCPRDWS
QL02
Description:
Log Import Task :Failed to import logs for site : StaplesCV

Event Type: Error
Event Source: Commerce Server 2002
Event Category: None
Event ID: 33123
Date: 9/19/2005
Time: 8:14:49 PM
User: N/A
Computer: INCDCPRDWS
QL02
Description:
Log Import Task did not import any hits

Event Type: Error
Event Source: Commerce Server 2002
Event Category: None
Event ID: 33122
Date: 9/19/2005
Time: 8:14:49 PM
User: N/A
Computer: INCDCPRDWS
QL02
Description:
Error launching parser. status code : -2147467259 (-2147467259)

I have searched but can not find anything related to an import process that
was functioning previously. Has anyone run into this problem before? Thanks

- Rich

Peter Yang [MSFT]

2005-09-21, 3:24 am

RLanoue

2005-09-21, 9:24 am

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

"Peter Yang [MSFT]" wrote:

> 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+B2ZetbPjzes0RFuQ
PlcU7cc/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@microso
ft.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_DTSLogIm
ps.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:
> | DTSRun OnError: DTSStep_CS_DTSLogImp
s.DTSLogImport_1, Error =
> -2147220421
> | (8004043B)
> | Error string: The task reported failure on execution.
> | Error source: Microsoft Data Transformation Services (DTS) Package
> | Help file: sqldts80.hlp
> | Help context: 700
> | Error Detail Records:
> | Error: -2147220421 (8004043B); Provider Error: 0 (0)
> | Error string: The task reported failure on execution.
> | Error source: Microsoft Data Transformation Services (DTS) Package
> | Help file: sqldts80.hlp
> | Help context: 700
> |
> | The application event viewer has the following:
> | Event Type: Error
> | Event Source: CSDataWareHo
use
> | Event Category: None
> | Event ID: 49176
> | Date: 9/19/2005
> | Time: 8:14:49 PM
> | User: N/A
> | Computer: INCDCPRDWS
QL02
> | Description:
> | Log Import Task :Failed to import logs for site : StaplesCV
> |
> | Event Type: Error
> | Event Source: Commerce Server 2002
> | Event Category: None
> | Event ID: 33123
> | Date: 9/19/2005
> | Time: 8:14:49 PM
> | User: N/A
> | Computer: INCDCPRDWS
QL02
> | Description:
> | Log Import Task did not import any hits
> |
> | Event Type: Error
> | Event Source: Commerce Server 2002
> | Event Category: None
> | Event ID: 33122
> | Date: 9/19/2005
> | Time: 8:14:49 PM
> | User: N/A
> | Computer: INCDCPRDWS
QL02
> | Description:
> | Error launching parser. status code : -2147467259 (-2147467259)
> |
> | I have searched but can not find anything related to an import process
> that
> | was functioning previously. Has anyone run into this problem before?
> Thanks
> |
> | - Rich
> |
> |
> |
>
>

RLanoue

2005-09-21, 1:26 pm

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

"RLanoue" wrote:
[color=darkred]
> 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
>
>
> "Peter Yang [MSFT]" wrote:
>

Peter Yang [MSFT]

2005-09-22, 3:23 am

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/te...erview/40010469

Others: https://partner.microsoft.com/US/te...upportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...a
l.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@microso
ft.com>
<d2eVCulvFHA.3020@TK2MSFTNGXA01.phx.gbl>
<8ABEA36B-83FA-48B6-9F14- 2F4C60EAACE3@microso
ft.com>
| Subject: RE: Log Import Error
| Date: Wed, 21 Sep 2005 11:11:03 -0700
| Lines: 149
| Message-ID: <D15607A1-0EB5-46B7-BDF4- 22CEA2C3EBAE@microso
ft.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
|
|
| "RLanoue" wrote:
|
| > 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
| >
| >
| > "Peter Yang [MSFT]" wrote:
| >
| > > 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+B2ZetbPjzes0RFuQ
PlcU7cc/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@microso
ft.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_DTSLogIm
ps.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:
| > > | DTSRun OnError: DTSStep_CS_DTSLogImp
s.DTSLogImport_1, Error =
| > > -2147220421
| > > | (8004043B)
| > > | Error string: The task reported failure on execution.
| > > | Error source: Microsoft Data Transformation Services (DTS)
Package
| > > | Help file: sqldts80.hlp
| > > | Help context: 700
| > > | Error Detail Records:
| > > | Error: -2147220421 (8004043B); Provider Error: 0 (0)
| > > | Error string: The task reported failure on execution.
| > > | Error source: Microsoft Data Transformation Services (DTS)
Package
| > > | Help file: sqldts80.hlp
| > > | Help context: 700
| > > |
| > > | The application event viewer has the following:
| > > | Event Type: Error
| > > | Event Source: CSDataWareHo
use
| > > | Event Category: None
| > > | Event ID: 49176
| > > | Date: 9/19/2005
| > > | Time: 8:14:49 PM
| > > | User: N/A
| > > | Computer: INCDCPRDWS
QL02
| > > | Description:
| > > | Log Import Task :Failed to import logs for site : StaplesCV
| > > |
| > > | Event Type: Error
| > > | Event Source: Commerce Server 2002
| > > | Event Category: None
| > > | Event ID: 33123
| > > | Date: 9/19/2005
| > > | Time: 8:14:49 PM
| > > | User: N/A
| > > | Computer: INCDCPRDWS
QL02
| > > | Description:
| > > | Log Import Task did not import any hits
| > > |
| > > | Event Type: Error
| > > | Event Source: Commerce Server 2002
| > > | Event Category: None
| > > | Event ID: 33122
| > > | Date: 9/19/2005
| > > | Time: 8:14:49 PM
| > > | User: N/A
| > > | Computer: INCDCPRDWS
QL02
| > > | Description:
| > > | Error launching parser. status code : -2147467259 (-2147467259)
| > > |
| > > | I have searched but can not find anything related to an import
process
| > > that
| > > | was functioning previously. Has anyone run into this problem
before?
| > > Thanks
| > > |
| > > | - Rich
| > > |
| > > |
| > > |
| > >
| > >
|

Sponsored Links