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 im****t data in the datawarehouse, which
includes the following tasks: Configuration Synchronisation, Web server
log
im****t, Transaction data im****t, Product catalog im****t, IP resolution and
Re****ts 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
im****t 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
im****t type and resource name "<sitename>" are valid.
Catalog DTS task: Im****t failed
5. Ip Resolution Task :Failed to initialize, invalid connection
information %1
6. Prepare Re****ts DTS task : Error 145 (Initialize failed because of an
invalid configuration. Please check the event log for more details.)
Prepare Re****ts DTS task : failed to complete
To summarise, nothing works anymore..
Any help will be highly appreciated. Thanks in advance
|
