kristina dimitrova

Hi all,
We are running CS2k2 Standard Edition on Widnows Server 2003, with SQL
Server 2000 on a different machine.
I created a DTS package to import data in the datawarehouse, which
includes the following tasks: Configuration Synchronisation, Web server log
import, Transaction data import, Product catalog import, IP resolution and
Reports Preparation in the specified order.
If I execute the DTS package from the Server Enterprise Manager on the
machine, where the Commerce Server is installed, everything works fine.
If I logon locally on the machine, where the SQL server is installed,
then the problems begin. First I discovered that the dlls for the commerce
server tasks were not registered on the SQL server machine. I registered
them
manually, using the regsvr32 command line utility. Then, when I execute the
DTS package, all tasks fail to execute and give very strange errors in the
event log. The errors are as follows:
1. Error in Commerce Administration Object : Description - 'The <SiteName>
site contains too many applications. Commerce Server 2002 Standard Edition
allows a maximum of 1 Bizdesk and 1 non-Bizdesk application.'
The site contains the web site, the BizDesk application and the catalog
manager web service, which works fine, as all other commerce sites we have.
2. Failed to initialize configuration object,Source name may be invalid.
ProgID : Commerce.SiteConfigReadOnly
3. Transaction DTS task : Error reading the admin store. Please check if the
import type and resource name "<sitename>" are valid.
Transaction DTS task :Execution failed.
4. Catalog DTS task : Error reading the admin store. Please check if the
import type and resource name "<sitename>" are valid.
Catalog DTS task: Import failed
5. Ip Resolution Task :Failed to initialize, invalid connection information
%1
6. Prepare Reports DTS task : Error 145 (Initialize failed because of an
invalid configuration. Please check the event log for more details.)
Prepare Reports DTS task : failed to complete
To summarise, nothing works anymore..
Any help will be highly appreciated. Thanks in advance

v-wzhang

Hi Kristina,

As I know, we can only run the DTS tasks on the Commerce machine. For
example, the configuration synchronization task will read
configuration values from IIS metabase to administration database and
then from admin db to data warehouse. So the error should be expected
which indicates it failed to read IIS config data on the SQL box.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

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