Running SQL script in Patch

[psaunders]

Hi,

I have created a Patch which from a version which has a new SQL file attached to it, however, upon running the patch the SQL Scripts did not run but the file updates did.

Any reason why? aips are attached

Thanks
Rudy

[mihai.petcu]

Hi Rudy,

Please try to set :

Code: Select all

PATCH

as your script condition for both your SQL scripts. This is a property which is set only when a patch runs.

Regards,
Mihai

[psaunders]

Thanks for the reply mihai.petcu, i also want it to run on install.

The current condition is "1", should i set it to "(INSTALL) OR (PATCH)" or "(1) OR (PATCH)"

Thanks

[mihai.petcu]

Hi Rudy,

Actually you need to set the script condition to:

Code: Select all

(NOT Installed) OR PATCH

"NOT Installed" will make the script to run when the package is installed, not when the package is removed or repaired.

Regards,
Mihai

[psaunders]

Hi,

I did that but it still didnt run. Attached is the .aip

Thanks
Rudy

[Bogdan]

Hi,

Can you please create a verbose log while installing the patch and send it to support at advancedinstaller dot com so we can investigate it?

Regards,
Bogdan

[psaunders]

Will do, but can you tell me how to do it please

Thanks

[Bogdan]

Hi,

In my previous post I placed a link towards an article that explains how to create a verbose log, I will post it again:
http://www.advancedinstaller.com/user-guide/qa-log.html

Regards,
Bogdan

[psaunders]

Thanks

Here it is

[psaunders]

Hi,

Any luck with the patch log?

Thanks
Rudy

[psaunders]

Hi,

I was speaking with support over email and managed to fix it with their help. I did the following.

I changed all of my custom actions, which started and stopped the services, to 'deffered with no impersonation'. I also set the execute condition to include 'PATCH'. The scripts were also set to 'modify/repair' as the patch is seen a modifing the application.

If anyone needs a hand just ask and i will let you know

Thanks all
Rudy

[udayk]

Hi Rudy and Mihai,

I followed steps as Rudy said,

I changed all of my custom actions, which started and stopped the services, to 'deffered with no impersonation'. I also set the execute condition to include 'PATCH'. The scripts were also set to 'modify/repair' as the patch is seen a modifing the application.

In my script i want to create new database using the patch script,but i get ODBC Connect : timeout exceeded exception,

Can you please tell me any alternative, regarding this script running through patch.

Thank you,
Uday.