SQL Scripts - Don't run on Repair/Modify

[kurtmwa]

We are shipping an update to our product. The last installer was done in 6.3 and this time we are using the latest version 7.0.1.

Somewhere along the line a new checkbox got added to the SQL Script page. Run SQL Script during maintenance (Repair/Modify). Since I want our scripts to run during a repair I have checked this for all of our scripts.

However no scripts get run during a repair or modify. They do however work properly during a install.

Any ideas?

[Cosmin]

Hi,

I'm not sure why you are encountering this behavior. Can you please send us the .AIP (project) file and a verbose log of the repair or modify process with the problem to support at advancedinstaller dot com so we can investigate them?

Regards,
Cosmin

[kurtmwa]

Cosmin,

I figured this out by comparing the existing aip and a new project. It seems that the Advanced Installer program does not upgrade the AIP project file correctly. Our existing aip has the following header.

Code: Select all

<DOCUMENT type="Advanced Installer" CreateVersion="6.1.1" version="7.0.1" modules="enterprise" RootPath="." Language="en">

It was missing the following two lines

Code: Select all

<ROW Action="AI_SqlMaint" Description="Executing maintenance SQL scripts" Template="Connection: [1]  Script: [2]" DescriptionLocId="ActionText.Description.AI_SqlMaint" TemplateLocId="ActionText.Template.AI_SqlMaint"/>

Code: Select all

<ROW Action="AI_SqlMaint" Type="11265" Source="sql.dll" Target="OnSqlMaint" WithoutSeq="true"/>

I also had to change the following line from

Code: Select all

<ROW Action="AI_SqlInstall" Condition="(VersionNT >= 500) AND (NOT Installed)" Sequence="5401"/>

to this

Code: Select all

<ROW Action="AI_SqlInstall" Condition="(VersionNT >= 500) AND (REMOVE <> "ALL")" Sequence="5401"/>

[Cosmin]

Hi,

Indeed, the conversion process doesn't add all the actions. We will try to improve it in a future version. Until then, a solution is to edit the .AIP file like you did or to remove and re-add the SQL scripts.

Regards,
Cosmin