This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Installation didn't rollback after sql script error
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 24, 2012
04:15 AM
Installation didn't rollback after sql script error
Hi All,
I got a strange problem in my installation package. During project upgrade I am running a sql script through the project Setup and I am getting sql error during installation, the installation process is getting aborted and the previous installation files from the installation directory also getting deleted.
In the installation project By default "On Error, Abort Installation" option is selected in the Script Error Handling section of Runtime tab within the sql script file.
Also, I don't want to use "On Error, Goto next script" and "On Error, Goto Next Statement" option because it makes no sense in my case if you are getting any error during installation and still you want to go ahead with the installation.
I don't want the installation process to be aborted, rather than I want the installation process to be Roll-backed in case any sql script error comes.
If anybody have any idea how to rollback the installation in case of sql script error then please provide a solution.
Thanks,
Sumeet Sharma
I got a strange problem in my installation package. During project upgrade I am running a sql script through the project Setup and I am getting sql error during installation, the installation process is getting aborted and the previous installation files from the installation directory also getting deleted.
In the installation project By default "On Error, Abort Installation" option is selected in the Script Error Handling section of Runtime tab within the sql script file.
Also, I don't want to use "On Error, Goto next script" and "On Error, Goto Next Statement" option because it makes no sense in my case if you are getting any error during installation and still you want to go ahead with the installation.
I don't want the installation process to be aborted, rather than I want the installation process to be Roll-backed in case any sql script error comes.
If anybody have any idea how to rollback the installation in case of sql script error then please provide a solution.
Thanks,
Sumeet Sharma
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 24, 2012
12:41 PM
If you are doing a major upgrade, you might want to consider using a different scheduling of the RemoveExistingProducts action. You can modify this setting in the Upgrades view by selecting Upgrade Windows Installer Setup and clicking the Common tab. Try the "Install setup then remove unneeded files" option and see if it works.
Hope that helps.
Hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 27, 2012
12:41 AM
Thanks Yamanishi. Its really resolved my problem. Thanks a lot.
With warm regards,
Sumeet Sharma
With warm regards,
Sumeet Sharma
![](/skins/images/A5EADE085F77DE82FB3B14D6B307AE6A/responsive_peak/images/icon_anonymous_message.png)