Hello,
I'm using the Data Warehouse Im****t Wizard to im****t data for a commerce
server re****ting. All the steps in the process work up to the final step -
Re****t Preparation - which fails.
The following message is written to the event log:
Event Type: Error
Event Source: CSDataWareHouse
Event Category: None
Event ID: 45057
Date: 14/12/2005
Time: 10:35:31
User: N/A
Computer: DSL002973
Description:
Prepare Re****ts DTS task : Error 429 (ActiveX component can't create
object)
SysInternals' DebugView re****ts the following:
Get Custom Name is called, returned DTSTask_CS_DTSPostImp.DTSPostIm****t
Custom task Execute is called
Enterprise edition of CS installed.
Gathering proxy site info for DataWarehouse: Data Warehouse 1
Reading configuration information for site: RYA
Description: Re****t preparation (Commerce Server): undefined
Source Name: Data Warehouse 1
Processing Type: 1
Task Name: DTSTask_CS_DTSPostImp.DTSPostIm****t
Num Retries: 10
Retry Interval: 30
Max Parallel Operations: 1
Retrieving new TaskHistoryId from Data Warehouse
Writing task execution data to TaskHistory table.
Prepare Re****ts DTS Task Run: 14/12/2005 10:35:21
System : DSL002973
Setting dboption in CS4.0 Data Warehouse Provider:
sp_dboption [rya_DW] , 'select into/bulkcopy', true
Retrieving list of stored procedures to execute from data warehouse.
Executing Stored Procedure: CSDW_MakeUserAgentData
Completed execution of Stored Procedure: CSDW_MakeUserAgentData
Executing Stored Procedure: CSDW_MakeMVQueryStringFactTable
Completed execution of Stored Procedure: CSDW_MakeMVQueryStringFactTable
Executing Stored Procedure: CSDW_MakeSVQueryStringFactTable
Completed execution of Stored Procedure: CSDW_MakeSVQueryStringFactTable
Executing Stored Procedure: CSDW_MakeAggRequestsByUri
Completed execution of Stored Procedure: CSDW_MakeAggRequestsByUri
Executing Stored Procedure: CSDW_MakeProductCategoryInfo
Completed execution of Stored Procedure: CSDW_MakeProductCategoryInfo
Executing Stored Procedure: CSDW_MakeSalesFactTable
Completed execution of Stored Procedure: CSDW_MakeSalesFactTable
Executing Stored Procedure: CSDW_MakeBasketEventsFactTable
Completed execution of Stored Procedure: CSDW_MakeBasketEventsFactTable
Executing Stored Procedure: CSDW_DateFill
Completed execution of Stored Procedure: CSDW_DateFill
Executing Stored Procedure: csdw_spDefineOLAPPartitions
Completed execution of Stored Procedure: csdw_spDefineOLAPPartitions
Reconciling partition design
Enterprise edition of CS installed.
Error Number: 429 (ActiveX component can't create object)
Writing task execution data to TaskHistory table.
Uninitialize Called
Get Custom Name is called, returned DTSTask_CS_DTSPostImp.DTSPostIm****t
The im****t works fine on our development machines - this is the production
environment where it fails. We used SQL Server backup/restore to transfer
the databases, Analysis Services Archive/Restore database and PUP packages
to
deploy to the production environment.
The Commerce Server machine is running Windows 2003 SP1, Sql Server 2000
SP3
client tools, and Analysis Server 2000 SP3 client tools. Content
Management
Server is also installed.
There is a cluster of 2 database servers, running Windows 2003 SP1 and Sql
Server 2000 SP3. Analysis Server 2000 SP3 is installed on one machine in
the
cluster.
Can anybody suggest what is causing the problem (what is the ActiveX
control? why can't it be created?) and how it can be resolved
(permissions?
registering the control?)
Many thanks in advance,
Phil Mellor
|
