View Full Version : SQL Script Text Replacement causes install to fail

06-07-2004, 09:46 AM

Installation fails without any error messages or any information in the log file when running SQL script that uses test replacement.
The same installation works without text replacement.
The correct table and stored procedure are created in both cases.

Attached is a small project to verify this behavior.
It works, until I go and add in Text Replacement tab:
replace Table1 with MyTable.

Thank you

From the log file
Good one
Action 10:30:12: ISSQLServerInstall.
MSI (s) (A4:68): Executing op: CustomActionSchedule(Action=ISSQLServerInstall,ActionType=1025,Source=BinaryData,Target=ISSQLServerInstall,CustomActionData=C:\TEMP\~3AB9.tmp)
MSI (s) (A4:68): Creating MSIHANDLE (29) of type 790536 for thread 4200
1: Start executing SQL script file: C:\TEMP\~3ABA.tmp
Action 10:30:12: Progress Custom Action. Executing SQL Install Script...
MSI (s) (A4:68): Executing op: ActionStart(Name=RegisterUser,Description=Registering user,Template=)

Failed one
MSI (s) (D0:F0): Executing op: ActionStart(Name=ISSQLServerInstall,,)
Action 10:18:25: ISSQLServerInstall.
MSI (s) (D0:F0): Executing op: CustomActionSchedule(Action=ISSQLServerInstall,ActionType=1025,Source=BinaryData,Target=ISSQLServerInstall,CustomActionData=C:\TEMP\~3AAD.tmp)
MSI (s) (D0:F0): Creating MSIHANDLE (295) of type 790536 for thread 1264
1: Start executing SQL script file: C:\TEMP\~3AAE.tmp
Action 10:18:26: Progress Custom Action. Executing SQL Install Script...
Action ended 10:18:26: InstallFinalize. Return value 3.

06-07-2004, 10:51 AM
Our install appears to be doing the same thing. It executes the SQL and then says its rolling back, but displays no error message. Is this what you are seeing?

06-07-2004, 10:59 AM
Hi ninlar,

Yes, we see the same behavior.


06-07-2004, 12:51 PM

Confirmed. I submitted the work order #1-PGYQ5 to address this issue in the first sevice pack of InstallShield X. If you need a custom fix for InstallShield X, please email me at hidenoriy@installshield.com

Thank you for reporting this.
Hidenori Yamanishi
InstallShield Software Corporation

07-12-2004, 04:16 PM
When is the service pack likely to be available? I have the same issue, but I can hardcode the values if it's before we release.


07-13-2004, 04:12 PM

The first service pack of InstallShield X will be avaliable in the next 30 days.

Hidenori Yamanishi

07-13-2004, 04:46 PM
Excellent. Thanks.

12-22-2004, 08:45 AM

Is this still an issue? - I have installed Installshield X and SP2 and I have got this issue - do I also need to install SP1 as well?



12-22-2004, 11:58 AM
Please make sure that ‘Service Pack 1’ appears on the Help->About box. If you applied InstallShield X SP2 patch, you may not have service pack 1 installed. The service pack 2 is only for Universal Installer projects and it does not install the SP1 fixes for Windows and InstallScript projects. If that is the case, you need to apply the InstallShield X SP1 patch that can be downloaded from http://support.installshield.com/kb/view.asp?articleid=Q111021.

Hope this helps.

12-23-2004, 04:10 AM
Thankx - I assumed the SP were cumulative