The s_WebServerInstance value is set to -2 when a Web server is unavailable during synchronization in Commerce Server (842643)



The information in this article applies to:

  • Microsoft Commerce Server 2002 SP2
  • Microsoft Commerce Server 2000 SP3

INTRODUCTION

When you synchronize a Microsoft Commerce Server application and one Web server is unavailable, you receive the following error message:

The IIS Web Site 'SiteName' does not exist on web server 'Server' Do you want to continue synchronizing this site?
Note The words "Web" and "site" are capitalized incorrectly in this error message.

If you click Yes, the s_WebServerInstance value of the ResourceProps table in the MSCS_Admin database will be set to -2 for that server. When this value is set, the synchronization object skips this Web server.

Microsoft Commerce Server 2000 will set the s_WebServerInstance value to -2 if you click No. Microsoft Commerce Server 2002 will not change the value of s_WebServerInstance if you click No.

MORE INFORMATION

To determine the servers in a server farm that did not synchronize, start SQL Query Analyzer, and then run the following command:
Use MSCS_Admin
select b.s_DisplayName [Site with failed server], a.s_value [Position of server in list] from ResourceProps a, Resources b where a.i_ResourceID = b.i_ResourceID AND a.s_value LIKE '%-2#%'

Steps to reproduce the behavior

Set up the Blank Site application

  1. Install Commerce Server 2000 or 2002.
  2. Unpup the Blank Site application.
  3. Deploy the Blank Site application to a second Web server.
  4. Start Commerce Server Manager.
  5. Expand Commerce Server Manager, expand Commerce Sites, expand Blank Site, right-click the application, and then click Properties.
  6. On the Web Servers tab, click Synchronize Values, and then click OK.
  7. Expand Microsoft SQL Servers, expand SQL Server Group, expand Server, expand Database, expand MSCSAdmin Database, right-click the ResourceProps table, point to Open Table, and then click Return all rows.
  8. Make sure that the s_WebServerInstance value is set to 1#^1#^.
  9. Unplug the network cable.

Synchronize the application

  1. In Commerce Server Manager, expand Commerce Server Manager, expand Commerce Sites, expand Blank Site, right-click the application, and then click Properties.
  2. On the Web Servers tab, click Synchronize Values.

    You will receive the following error message:

    The IIS Web Site 'SiteName' does not exist on web server 'Server' Do you want to continue synchronizing this site?
    Note The words "Web" and "site" are capitalized incorrectly in this error message.
  3. Click Yes.
  4. Click Cancel.
  5. Right-click the ResourceProps table, point to Open Table, and then click Return all rows.
  6. Make sure that the s_WebServerInstance value is set to 1#^-2#^.

Modification Type:MajorLast Reviewed:6/8/2004
Keywords:kbinfo kbtshoot KB842643 kbAudDeveloper kbAudITPRO