Hi,

I am trying to create a transform on a package, that I am running into problems with.

If I run the .msi by itself, it installs fine. If I apply my transform, I get the error below:

Error 2228. Database: . Unknown Table 'Signature' in SQL query: SELECT 'FileName', 'MinVersion', 'MaxVersion', 'MinSize', 'MaxSize', 'MinDate', 'MaxDate', 'Languages' FROM 'Signature' WHERE 'Signature' = ?

My Transform has a system search in it, and I know this error is related to that because if I take it out then the transform works fine.

My System Search searches for a registry key in HKLM so I would not of though it would be looking for file signatures to run. It is the only system search in the app.

My Signature Table is empty as I am doing a registry search. Can anyone help me figure this out?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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

Answers

0
Yes, you are right. This error is generated because of System Search. I would want to know how have you populated the RegLocator table for the registry Search. What is the value in the Type column of this table.
Answered 04/24/2009 by: WiseNdMe
Senior Yellow Belt

Please log in to comment
0
I Use WPS 7, and this has populated the tables for me. My RegLocator table is as follows:


Signature Root Key Name Type
"AppReg","2","SOFTWARE\rdm","rdmbuildversion","2"
Answered 04/24/2009 by: beefy66
Orange Belt

Please log in to comment
2
....at a glance it seems ok. Because the 'Type' column is set to 2 (and your Signature table is empty) this should search the registry key in the RegLocator table. Maybe try opening just your MSI in Orca and checking if the Signature table exists in that. If it doesn't, you need to add it by clicking 'Tables' > 'Add Table' > Select the 'Signature' check box etc etc
Answered 04/24/2009 by: captain_planet
Second Degree Brown Belt

Please log in to comment
0
I have checked my wsi using wise, compiled, and then checked my msi using orca. The signature table does exist, but it is empty.
Answered 04/24/2009 by: beefy66
Orange Belt

Please log in to comment
0
I have managed to fix it!

I think my transform was corrupt. I have created a brand new transfrom (like I have done 3 times before it!) and this time when I checked in orca the signature table was not there. Added it in and it worked.

Thanks for your help.
Answered 04/24/2009 by: beefy66
Orange Belt

Please log in to comment
0
Check your default 'Windows Application' template. I'll bet the table is missing from that.
Answered 04/24/2009 by: VBScab
Red Belt

Please log in to comment
0
Hi,

Can you tell me how exactly u populated the signature table.
I also am getting the same error. And my signature table is empty in my MST.
Thanks.
Answered 01/24/2011 by: kunjumol
Senior Yellow Belt

Please log in to comment
0
It depends on what you're searching for. If you're searching for a registry value, the Signature table won't be populated. If you're searching for a file, it will be populated.

If you're getting a similar error to the OP, then open your MSI/ISM/WSI in Orca and add the Signature table (as in post #4). Then close Orca. Then re-open it (or your MST) and use your GUI view in Wise/Installshield to create your System Search again.....
Answered 01/25/2011 by: captain_planet
Second Degree Brown Belt

Please log in to comment
Answer this question or Comment on this question for clarity