Hello Özge,
I've tested the scenario and indeed, the SQL scripts scheduled on rollback don't run when the user cancels the installation during or after the SQL scripts (scheduled on install) execution. This seems to be an Advanced Installer issue caused by our
Enhanced User Interface feature. A fix will be available in a future version of Advanced Installer, thank you for helping us to isolate this issue. We'll update this thread when the fix will be out.
Until then, as a workaround, you can disable the "Enhanced User Interface" feature. Please note that when the EUI is disabled the only theme you can use for installation dialogs is the "Classic" one. Also, after changing the theme from "Themes" page, all of your customization made on installation dialogs ("Dialogs" page) will be lost. As another solution, you can try to use a
custom action which will drop your created databases. The custom action should be scheduled (on rollback) just before "Install Execution Stage -Add Resources -> RegisterTypeLibraries" standard action.
All the best,
Daniel