|
Home > Archive > Commerce Server Setup > April 2004 > Moving Commerce Server ProfileService
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Moving Commerce Server ProfileService
|
|
|
| Hi there.
Our company has a cluster of webservers tied to a single SQL server, linked via Commerce Server 2000.
This past weekend, I was able to successfully transfer the SQL server databases and connection strings to a new SQL server, and our website and ordering systems are working just fine. Unfortunately, it doesn't look like everything has switched over - w
hen I try to power down our old SQLServer, our webserver CPU's immediately jump to 100% utilization - and basically the website is dead until I bring the old SQLserver online and do an IISreset on the webservers.
Looking at the error logs, I see the website is getting a database connection error for the old SQLserver, failing on /includes/global_profile_lib.asp, at these lines.
--
Set mscsProfileService = Server.CreateObject("Commerce.ProfileService")
Call mscsProfileService.Initialize(dictConfig.s_ProfileServiceConnectionString, SCHEMA_CATALOG)
--
Obviously, something with the ProfileService is still linked to the old server. I changed all the connection strings for ProfileService in Commerce Server 2000 (on the SQL server) - does anyone know if there is another set of ProfileService server connec
tions I'm missing?
Thanks for any help.
| |
| Jason Xu 2004-04-23, 11:36 am |
| In Commerce Server Manager, go to Global Resource, your Profile resource ->
Profile Catalog -> Data source -> ProfileService_SQLSource, right click the
ProfileService_SQLSource, get properties, go to "partions" tab, select the
SQL source there and click edit button, check the connection string there
see it has been changed or not.
Regards
huanchixOnline@microsoft.com
Microsoft Commerce Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
--------------------
>Thread-Topic: Moving Commerce Server ProfileService
>thread-index: AcQQQiOIp/9RhGSJS+OF0sMW66s+mQ==
>X-Tomcat-NG: microsoft.public.commerceserver.setup.deploymentoperations
>From: "=?Utf-8?B?Q2hyaXM=?=" <anonymous@discussions.microsoft.com>
>Subject: Moving Commerce Server ProfileService
>Date: Mon, 22 Mar 2004 11:16:12 -0800
>Lines: 18
>Message-ID: <56B285D0-DBD6-464B-9304-9B07E7C6E1CC@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.setup.deploymentoperations
>Path: cpmsftngxa06.phx.gbl
>Xref: cpmsftngxa06.phx.gbl
microsoft.public.commerceserver.setup. deploymentoperations:3324
>NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
>X-Tomcat-NG: microsoft.public.commerceserver.setup.deploymentoperations
>
>Hi there.
Our company has a cluster of webservers tied to a single SQL server, linked
via Commerce Server 2000.
This past weekend, I was able to successfully transfer the SQL server
databases and connection strings to a new SQL server, and our website and
ordering systems are working just fine. Unfortunately, it doesn't look
like everything has switched over - when I try to power down our old
SQLServer, our webserver CPU's immediately jump to 100% utilization - and
basically the website is dead until I bring the old SQLserver online and do
an IISreset on the webservers.
Looking at the error logs, I see the website is getting a database
connection error for the old SQLserver, failing on
/includes/global_profile_lib.asp, at these lines.
--
Set mscsProfileService = Server.CreateObject("Commerce.ProfileService")
Call
mscsProfileService.Initialize(dictConfig.s_ProfileServiceConnectionString,
SCHEMA_CATALOG)
--
Obviously, something with the ProfileService is still linked to the old
server. I changed all the connection strings for ProfileService in
Commerce Server 2000 (on the SQL server) - does anyone know if there is
another set of ProfileService server connections I'm missing?
Thanks for any help.
>
|
|
|
|
|