Hello,
The following WIX line does not produce the desired behavior
of running the SQL script on install, uninstall and rollback (it does not
run on uninstall, we're not sure about install and rollback)
<sql:SqlScript
Id="PolicyReplicationClean" BinaryKey="PolicyRepCleanSQL"
ExecuteOnInstall="yes" ExecuteOnReinstall="yes" ExecuteOnUninstall="yes"
RollbackOnInstall="yes" ContinueOnError="no"
SqlDb="ForefrontSecuritySuiteDb" Sequence="801" />
When changing the above line to:
<sql:SqlScript Id="PolicyReplicationClean"
BinaryKey="PolicyRepCleanSQL" *ExecuteOnInstall="no"* *
ExecuteOnReinstall="no"* ExecuteOnUninstall="yes"
*RollbackOnInstall="no"*ContinueOnError="no"
SqlDb="ForefrontSecuritySuiteDb" Sequence="801" />
We get the script running on uninstall. What might cause
this issue? Are we doing something wrong? Here are some snippets from the
MSI log:
Old (First version, not working on uninstall, log is filtered to contain
only lines referencing the sql script):
0532 MSI (s) (BC!F4) [13:25:09:414]: PROPERTY CHANGE: Adding
RollbackExecuteSqlStrings property. Its value is
'ForefrontSecuritySuiteDb€ESAS-SRV39€€ForefrontSecuritySuite€32€1€€€PolicyReplicationClean€27€USE
[ForefrontSecuritySuite]€PolicyReplicationClean€27€BEGIN TRY EXEC
sp_dropsubscription @publication = N'Forefront System', @article='all',
@subscriber='all' END TRY BEGIN CATCH PRINT ERROR_MESSAGE() END CATCH
0535 USE [master]€PolicyReplicationClean€27€BEGIN TRY EXEC
sp_replicationdboption @dbname = N'ForefrontSecuritySuite', @optname =
N'publish', @value = N'false' END TRY BEGIN CATCH PRINT ERROR_MESSAGE() END
CATCH'.
1998 Property(S): RollbackExecuteSqlStrings =
ForefrontSecuritySuiteDb€ESAS-SRV39€€ForefrontSecuritySuite€32€1€€€PolicyReplicationClean€27€USE
[ForefrontSecuritySuite]€PolicyReplicationClean€27€BEGIN TRY EXEC
sp_dropsubscription @publication = N'Forefront System', @article='all',
@subscriber='all' END TRY BEGIN CATCH PRINT ERROR_MESSAGE() END CATCH
2001 USE [master]€PolicyReplicationClean€27€BEGIN TRY EXEC
sp_replicationdboption @dbname = N'ForefrontSecuritySuite', @optname =
N'publish', @value = N'false' END TRY BEGIN CATCH PRINT ERROR_MESSAGE() END
CATCH
New (Second version, working on uninstall, log is filtered to contain only
lines referencing the sql script):
1106 Property(S): ExecuteSqlStrings =
ForefrontSecuritySuiteDb€ESAS-SRV39€€ForefrontSecuritySuite€32€1€€€PolicyReplicationClean€2€USE
[ForefrontSecuritySuite]€PolicyReplicationClean€2€BEGIN TRY EXEC
sp_dropsubscription @publication = N'Forefront System', @article='all',
@subscriber='all' END TRY BEGIN CATCH PRINT ERROR_MESSAGE() END CATCH
1109 USE [master]€PolicyReplicationClean€2€BEGIN TRY EXEC
sp_replicationdboption @dbname = N'ForefrontSecuritySuite', @optname =
N'publish', @value = N'false' END TRY BEGIN CATCH PRINT ERROR_MESSAGE() END
CATCH
In addition when examining the MSIs in orca, we can see in the SqlScript
table that the Attributes value of this script is 27 for the first MSI and 2
for the second MSI.
I would appreciate your help in this matter,
Thanks,
-Fadi
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
