PDA

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



miryamgb
06-07-2004, 09:46 AM
Hi,

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
Miryam

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.

ninlar
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?

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

Yes, we see the same behavior.

Miryam

hidenori
06-07-2004, 12:51 PM
Hi,

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

johnludlow
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.

Thanks

hidenori
07-13-2004, 04:12 PM
Hi,

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

Regards,
Hidenori Yamanishi

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

ShaunW
12-22-2004, 08:45 AM
Hi

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?

Regards

Shaun

hidenori
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.

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