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
- :
- SQLRTDoRollbackAll function wont execute SQL scripts scheduled to run during rollback
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
‎Mar 15, 2009
05:51 PM
SQLRTDoRollbackAll function wont execute SQL scripts scheduled to run during rollback
Hi
basically my problem is:
SQLRTDoRollbackAll function wont execute a SQL scripts scheduled to run during rollback
I create a database with one script - and try populate it with tables - there is a intentional error in the populate tables (which causes a rollback) - i can trace this in debug mode
i have a script to remove the database on rollback (check box run on rollback is ticked) but it dosnt seem to work???
**rmdatabase** and **rmdatabaseConfig** are replaced with the names of the database that is created,
Use Master
--Remove the Database if rollBack is needed
DROP DATABASE **rmdatabase**
--Remove the Config Database if rollBack is needed
DROP DATABASE **rmdatabaseConfig**
Any ideas what i should try? - i have been googling this error for a while - found nothing!!
Thanks for the Help / advice
A
basically my problem is:
SQLRTDoRollbackAll function wont execute a SQL scripts scheduled to run during rollback
I create a database with one script - and try populate it with tables - there is a intentional error in the populate tables (which causes a rollback) - i can trace this in debug mode
i have a script to remove the database on rollback (check box run on rollback is ticked) but it dosnt seem to work???
**rmdatabase** and **rmdatabaseConfig** are replaced with the names of the database that is created,
Use Master
--Remove the Database if rollBack is needed
DROP DATABASE **rmdatabase**
--Remove the Config Database if rollBack is needed
DROP DATABASE **rmdatabaseConfig**
Any ideas what i should try? - i have been googling this error for a while - found nothing!!
Thanks for the Help / advice
A
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 24, 2009
07:20 PM
Any ideas?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 31, 2009
05:47 PM
The problem does not occur on my side. Please follow the steps below and see if it is reproducible:
[LIST=1]
Create a new InstallScript project.
Go to the SQL Scripts view.
Add a connection and two SQL scripts.
Write an incorrect T-SQL statement in the first SQL script, and schedule it to run during install.
Write a correct T-SQL statement such as creating a new table in the second SQL script, and schedule it to run during rollback.
Build and run the setup.
On the SQLLogin dialog, provide a valid login information, and then proceed the setup.
When you get an error during installation, click the OK on the error dialog.
Observe the database using Microsoft SQL Server Management Studio.
Expected result: the new table should be created by the second SQL script.
[LIST=1]
Expected result: the new table should be created by the second SQL script.
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)