Commerce Manager Does Not Display Sites When Locale Is Changed (302677)

CAUSE

This problem is caused by changes to resource properties, such as doubles and Booleans.

When a site has a resource that contains a property of type adDouble, the manager fails when it tries to add a number with the incorrect decimal symbol. For example, your site may have a resource named App Default Config. If you look in the ResourceProps table for this resource, you may find an f_AltCurrencyConversionRate that has an i_VarType of 5 (adDouble) and an s_Value of 1,1007. If your site was installed with the French (Canada) locale with a comma (,) decimal symbol, the number appears as follows:

1,1007

When the computer is switched to the English (Canada) locale, the decimal symbol changes to a period (.). This causes an exception to occur.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft Commerce Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

297216 INFO: How to Obtain the Latest Commerce Server 2000 Service Pack

The English version of this fix should have the following file attributes or later:

   Date          Time    Version   Size      File name     
   -------------------------------------------------------------
   13-Jun-2001   15:08   1.0.0.1    28,944   Hotfixsetup.exe
   06-Jul-2001   21:27                 432   Qfehotfix.ini
   05-Jul-2001   22:04             126,976   Qfepatch.msp
   05-Jul-2001   22:38               7,168   Qfeunpatch.msp

WORKAROUND

To work around this problem, do one of the following:

Change the decimal symbol setting in Control Panel.

If the problem is with Boolean properties, run the following commands against the MSCS_ADMIN database:

update  resourceprops 
set s_value = 'False'
where s_value Like 'Faux'
go
update  resourceprops 
set s_value = 'True'
where s_value Like 'Vrai'
Go

STATUS