Article ID: 295193 - View products that this article applies to.
This article was previously published under Q295193
BUG #: 353275 (SHILOH_bugs)
After you merge a working setup package and the Sqlsvr.msm file, the resulting package may fail validation, and this error message occurs:
ICE03 ERROR Value not a member of the set; Table: Shortcut, Column: ShowCmd, Key(s): SvcMngrShortcut.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616
The shortcut table in the Sqlsvr.msm merge modules contains a row with the following settings:
The ShowCmd setting (0 = SW_HIDE) is invalid. The ShowCmd setting ought to be (1 = SW_SHOWNORMAL).
Shortcut="SvcMngrShortcut.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616" Directory_="StartupFolder" Name="SvcMngr|Service Manager" Component="SvcMngrShortcut.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616" Target="[#sqlmangr.exe.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616]" Arguments="/n" Description=(NULL) Hotkey=(NULL) Icon_=(NULL) IconIndex=(NULL) ShowCmd="0" WkDir=(NULL)
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
To work around this behavior either:
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
Alone, the merge module does not fail validation because the _Validation table of the merge module is incorrect as well.
The _Validation table contains a row with the following settings:
Description="The show command for the application window. The following values may be used."
The Set row shows that zero (0) is allowed while 1 is not. The correct row setting is: