06/13/2004 13922 views
Help with MSI (Microsoft Installer) error 2228: Database: [2]. Unknown table '[3]' in SQL query: [4].
0 Comments   [ + ] Show comments


Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

All Answers

Resolution :-The reason behind this error is the missing table 'Signature' from the MSI (NOT MST). There may be a few MSIs that do not contain Signature table. Further when we try applying MST that includes the LaunchCondition we may get 2228 Installation error. We can include the missing signatute table from ORCA as shown below :- =>Open the MSI with ORCA ->Tables Tab -> Add Table Option : Add Signature TableDetailed Information :-1)This error can be related to the applications that uses AppSearch and Launch Condition. AppSearch action, it searches the target computer for file signatures that are specified in the AppSearch table of the Windows Installer package. 2)If AppSearch locates a file/registry key or a folder that has the relative signature specified, the action returns search results as a property. This property is further used to establish a Launch Condition. 3)If the condition that you set is not satisfied, the Launch Condition quits installation process. 4)The action AppSearch uses database tables such as following while searching for files, registry keys, and folders: * Signature * AppSearch * DrLocator * RegLocator * CompLocator
Answered 02/17/2011 by: Rushikesh Ware
Senior Yellow Belt

If this error occurs while using AppSearch and RegLocator it is because the table does not exist in the MSI. It can be resolved by either adding an empty Signature-table in the MSI or the MST. Note that if you compile a MSI or MST with a empty Signature-table in Wise Package Studio, Package Studio will remove the Signature-table.
Answered 08/31/2011 by: Multiplier
Senior Yellow Belt