Error 2228
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?
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
Answers (8)
Please log in to answer
Posted by:
captain_planet
15 years ago
....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
Posted by:
WiseNdMe
15 years ago
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.
Posted by:
beefy66
15 years ago
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"
Signature Root Key Name Type
"AppReg","2","SOFTWARE\rdm","rdmbuildversion","2"
Posted by:
beefy66
15 years ago
I have checked my wsi using wise, compiled, and then checked my msi using orca. The signature table does exist, but it is empty.
Posted by:
beefy66
15 years ago
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.
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.
Posted by:
anonymous_9363
15 years ago
Check your default 'Windows Application' template. I'll bet the table is missing from that.
Posted by:
kunjumol
13 years ago
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.
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.
Posted by:
captain_planet
13 years ago
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.....
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.....
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.