matt.luthi@gmail.com
Posts: 44
Joined: Thu Jun 20, 2013 4:42 am

Sequence of text file update and database connection

I have an installer that was working with versions of AI for months, but since we upgraded to 11.3 we are experiencing an issue that looks like there has been a change to when things happen.

This installs a web site and the associated database. All the database variables are AI parameters. When the SQL connection dialog form comes up, the user has the opportunity to change the defaults. These parameters are also used to write the web.config file.

Obviously we want the web.config file written AFTER the SQL connection dialog has shown. However, this does not seem to be happening in that order consistently. We have a Win7 x64 machine where the web.config file is consistently written before the SQL connection dialog comes up. On my personal Win7 x64 machine this does not happen.

I have the AIP file attached.

Thanks,
Matt
Attachments
CapisceSendServer64.aip
(344.67 KiB) Downloaded 566 times
Eusebiu
Posts: 4971
Joined: Wed Nov 14, 2012 2:04 pm

Re: Sequence of text file update and database connection

Hi Matt,

I'm not sure why you encounter this problem, but I'm sure that the "web.config" file cannot be written before the "SQL Connection" dialog was displayed. I think that the file may be found on the machine if it was left by the previous version of the application.

Can you reproduce the problem on multiple clean machine? If so, can you send us a verbose log of the installation, so we can investigate it?

Best regards,
Eusebiu
Eusebiu Aria - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
matt.luthi@gmail.com
Posts: 44
Joined: Thu Jun 20, 2013 4:42 am

Re: Sequence of text file update and database connection

Okay, I'll get a verbose log to you. Thanks for your reply.
matt.luthi@gmail.com
Posts: 44
Joined: Thu Jun 20, 2013 4:42 am

Re: Sequence of text file update and database connection

Hi Eusebiu, as promised, the log file attached.
Attachments
out.zip
(174.01 KiB) Downloaded 546 times
Eusebiu
Posts: 4971
Joined: Wed Nov 14, 2012 2:04 pm

Re: Sequence of text file update and database connection

Hi,

I looked over the log file that you sent and it shows that the "AI_TxtUpdaterInstall" custom action, that updates the "web.config" file, is executed correctly on the "Install Execution Sequence" after the "WriteRegistryValues" and "WriteIniValues" custom actions. So the file cannot be updated before the "SQL Connections" dialog is displayed.

I also, tried to reproduce the problem using your AIP, but the "web.config" file was always updated correctly, with the values that I wrote on the "SQL Connections" dialog. Did you try to reproduce the behavior on multiple clean machines?

Best regards,
Eusebiu
Eusebiu Aria - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
matt.luthi@gmail.com
Posts: 44
Joined: Thu Jun 20, 2013 4:42 am

Re: Sequence of text file update and database connection

Hi Eusebiu,

So far we only see this happening on one machine. It works fine on mine as well. However I am concerned that if it happens on one of our dev machines it may well happen on any other machine at a cutomer's site.

Perhaps it is not so much the timing that is the issue, but the values in the variables? I mean I use the variables set in the parameters section in the sql dialog controls but even though we type in other values than the defaults set in the parameter section it always uses the default values.

Regards,
Matt Luthi
Eusebiu
Posts: 4971
Joined: Wed Nov 14, 2012 2:04 pm

Re: Sequence of text file update and database connection

Hi Matt,

I suspect that the problem appears on that machine because it got corrupted somehow (maybe because of multiple tests), as the problem does not also appear on the other machines. That is why, for repeated testing, we highly recommend virtual machines, as they can easily be restored to a clean state. However, the problem should not appear on the end user's machines.

Best regards,
Eusebiu
Eusebiu Aria - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
matt.luthi@gmail.com
Posts: 44
Joined: Thu Jun 20, 2013 4:42 am

Re: Sequence of text file update and database connection

Hmm... is there any way you know of that *cures* a corrupted machine?

Return to “Building Installers”