Are you sure it is the identical issue? Look in the verbose log file for error details.
-----Original Message----- From: anwesha.m [mailto:anwesh...@live.com] Sent: Thursday, January 22, 2009 05:56 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Sql scripts do not run at the time of uninstallation Hi Rob, I am now using the latest Wix build. But i am still facing this issue. Am i missing any properties? This is how I am using sqlscript- <Component Id="C_v3DATABASE" Guid="33B86E13-DDF4-4758-B11F-EFE3DCA856B4"> <ReserveCost Id="DatabaseCost" RunFromSource="1024" RunLocal="20480" /> <sql:SqlDatabase Id="SQLDB" Database="[DBNAME]" Server="[DBSERVER]" CreateOnInstall="no" ContinueOnError="no" ConfirmOverwrite="yes"> <sql:SqlScript Id="SQLScript1" BinaryKey="DeleteScript" ExecuteOnInstall="no" ContinueOnError="no" ExecuteOnUninstall="yes" Sequence="1" /> </sql:SqlDatabase> <CreateFolder/> </Component> Rob Mensching-2 wrote: > > WiX v3.4311.0 is 6-months old. There have been a lot of fixes made in > that time. Try a more recent build and see if this is fixed. > > Also, make sure in a verbose log file that the Component that contains the > SqlScript in question is actually being uninstalled. > > -----Original Message----- > From: anwesha.m [mailto:anwesh...@live.com] > Sent: Monday, January 12, 2009 03:58 > To: wix-users@lists.sourceforge.net > Subject: [WiX-users] Sql scripts do not run at the time of uninstallation > > > Hi All, > > I am using Wix 3.0.4311.0. I have an installer which is required to run a > script at the time of installation (to create stored procedures in > database) > and run another script at the time of uninstallation (to drop the stored > procedures created). Here's a snippet of the code: > > <sql:SqlScript Id="SQLScript1" BinaryKey="DeleteScript" > ExecuteOnInstall="no" RollbackOnInstall="yes" ContinueOnError="no" > ExecuteOnUninstall="yes" Sequence="1" /> > <sql:SqlScript Id="SQLScript2" BinaryKey="CreateScript" > ExecuteOnInstall="yes" RollbackOnInstall="yes" ContinueOnError="no" > ExecuteOnUninstall="no" Sequence="1" /> > > At the time of uninstallation, the 'DeleteScript' is not getting executed > and the stored procedures do not get dropped. This the part of the log > file: > > MSI (s) (E4:18) [03:31:49:741]: Doing action: UninstallSqlData > Action ended 3:31:49: RemoveDuplicateFiles. Return value 1. > MSI (s) (E4:58) [03:31:49:756]: Invoking remote custom action. DLL: > C:\WINDOWS\Installer\MSIB1.tmp, Entrypoint: UninstallSqlData > MSI (s) (E4:04) [03:31:49:756]: Generating random cookie. > MSI (s) (E4:04) [03:31:49:772]: Created Custom Action Server with PID 8492 > (0x212C). > MSI (s) (E4:44) [03:31:49:819]: Running as a service. > MSI (s) (E4:44) [03:31:49:819]: Hello, I'm your 32bit Impersonated custom > action server. > MSI (s) (E4!CC) [03:31:49:944]: PROPERTY CHANGE: Adding > RollbackExecuteSqlStrings property. Its value is > 'SQLDB321SQLScript111 the body of the script goes here > Action start 3:31:49: UninstallSqlData. > MSI (s) (E4!CC) [03:31:49:944]: Doing action: RollbackExecuteSqlStrings > Action start 3:31:49: RollbackExecuteSqlStrings. > Action ended 3:31:49: RollbackExecuteSqlStrings. Return value 1. > > Actually I have upgraded the installer from Wix 2.0 to wix 3.0. The same > code in wix 2.0 works perfect. It installs and uninstalls the database > objects as required. But, in wix 3.0 , the uninstall script does not run. > What am i missing here? What else needs to be done for wix 3? > > Thanks in advance, > Anwesha > -- > View this message in context: > http://n2.nabble.com/Sql-scripts-do-not-run-at-the-time-of-uninstallation-tp2145283p2145283.html > Sent from the wix-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Check out the new SourceForge.net Marketplace. > It is the best place to buy or sell services for > just about anything Open Source. > http://p.sf.net/sfu/Xq1LFB > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ > Check out the new SourceForge.net Marketplace. > It is the best place to buy or sell services for > just about anything Open Source. > http://p.sf.net/sfu/Xq1LFB > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > -- View this message in context: http://n2.nabble.com/Sql-scripts-do-not-run-at-the-time-of-uninstallation-tp2145283p2197888.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
