vtadas@onlinemicrosoftcom vinayak

Registering the dlls on another machine will not work. This task needs to
be run on the machine commerce server is installed because the task
attemtps to connect to the MSCS_Admin database and the information on
connecting to this database is stored on the machine commerce server is
installed (this information is captured during setup) .

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only


--------------------
Thread-Topic: DTS package scheduled as a job execution problem
thread-index: AcW3pIDsdrlbeXpYR9qkbMbFZJdveA==
X-WBNR-Posting-Host: 195.24.43.252
From: =?Utf-8?B?S3Jpc3RpbmEgU3RvaXR6b3Zh?= <Kristina
Stoitzova@discussions.microsoft.com>
Subject: DTS package scheduled as a job execution problem
Date: Mon, 12 Sep 2005 07:16:01 -0700
Lines: 34
Message-ID: <B1E3DE19-0E6B-4CD4-B605-660D9DCDA4C7@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.commerceserver.****ysis
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSF TNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.****ysis:414
X-Tomcat-NG: microsoft.public.commerceserver.****ysis

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

kristina stoitzova*¸¬¶)újú·:/iø¬rë,Š‰ìš+¢êµê&

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

vtadas

Registering the dlls on another machine will not work. This task needs to
be run on the machine commerce server is installed because the task
attemtps to connect to the MSCS_Admin database and the information on
connecting to this database is stored on the machine commerce server is
installed (this information is captured during setup) .

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only


--------------------
Thread-Topic: DTS package scheduled as a job execution problem
thread-index: AcW3pIDsdrlbeXpYR9qkbMbFZJdveA==
X-WBNR-Posting-Host: 195.24.43.252
From: =?Utf-8?B?S3Jpc3RpbmEgU3RvaXR6b3Zh?= <Kristina
Stoitzova@discussions.microsoft.com>
Subject: DTS package scheduled as a job execution problem
Date: Mon, 12 Sep 2005 07:16:01 -0700
Lines: 34
Message-ID: <B1E3DE19-0E6B-4CD4-B605-660D9DCDA4C7@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.commerceserver.****ysis
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSF TNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.****ysis:414
X-Tomcat-NG: microsoft.public.commerceserver.****ysis

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