cbooth
Posts: 14
Joined: Tue Jan 04, 2011 9:37 pm

MSSQL conditional Prereq Issue

Hi,

I'm having an issue with an MSSQL 2005 Express SP3 prereq. It appears that on some machines, the MSSQL feature is being added to the ADDLOCAL in the log, but on others it is not for some reason, and so the prereq is not installing. I've manually checked the conditions that the install is looking for on the machines and have confirmed that there is no trace of MSSQL installed, so I'm not sure why some machines would not include this feature.

Here's some log excerpts from a good install:

Code: Select all

Feature: MSSQL_2005_Express_SP3; Installed: Absent;   Request: Null;   Action: Null
...
PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'Feature,ftdibus,ftdibus_1,ftdiport_3,ftdiport_2,Feature_1,MSSQL_2005_Express_SP3,ftdibus_2,ftdibus_3,AI64BitFiles,AI32BitFiles,MainFeature,Office_2007_Primary_Interop_Assemblies,ftdiport,ftdiport_1,AIOtherFiles,NET_Framework_2.0_SP2,MDAC_2.8,VSTO_2005_SE_Runtime,Office2007'.
And one from an install that's failing:

Code: Select all

MSSQL_2005_Express_SP3; Installed: Absent;   Request: Local;   Action: Local
...
PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'Feature,ftdibus,ftdibus_1,ftdiport_3,ftdiport_2,Feature_1,ftdibus_2,ftdibus_3,AI64BitFiles,AI32BitFiles,MainFeature,Office_2007_Primary_Interop_Assemblies,ftdiport,ftdiport_1,AIOtherFiles,NET_Framework_2.0_SP2,MDAC_2.8,VSTO_2005_SE_Runtime,Office2007'.
Any ideas? Is there other information I can provide that may help?

Thanks!
cbooth
Posts: 14
Joined: Tue Jan 04, 2011 9:37 pm

Re: MSSQL conditional Prereq Issue

oops! Got the Feature lines from the log backwards. Should be:

Good install:

Code: Select all

Feature: MSSQL_2005_Express_SP3; Installed: Absent;   Request: Local;   Action: Local
...
PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'Feature,ftdibus,ftdibus_1,ftdiport_3,ftdiport_2,Feature_1,MSSQL_2005_Express_SP3,ftdibus_2,ftdibus_3,AI64BitFiles,AI32BitFiles,MainFeature,Office_2007_Primary_Interop_Assemblies,ftdiport,ftdiport_1,AIOtherFiles,NET_Framework_2.0_SP2,MDAC_2.8,VSTO_2005_SE_Runtime,Office2007'.
Bad install:

Code: Select all

Feature: MSSQL_2005_Express_SP3; Installed: Absent;   Request: Null;   Action: Null
...
PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'Feature,ftdibus,ftdibus_1,ftdiport_3,ftdiport_2,Feature_1,ftdibus_2,ftdibus_3,AI64BitFiles,AI32BitFiles,MainFeature,Office_2007_Primary_Interop_Assemblies,ftdiport,ftdiport_1,AIOtherFiles,NET_Framework_2.0_SP2,MDAC_2.8,VSTO_2005_SE_Runtime,Office2007'.
mihai.petcu
Posts: 3860
Joined: Thu Aug 05, 2010 8:01 am

Re: MSSQL conditional Prereq Issue

Hello,

Can you please make sure that the behavior manifests on machines that do not have SQL Server 2005 Express SP3 installed?

You can verify this from the registry using the same search criteria the prerequisite does. Simply make sure that this registry value:

Code: Select all

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\CurrentVersion\CurrentVersion
is not 9.00.4035 or greater, as described in the following article:
http://social.technet.microsoft.com/wik ... sions.aspx

If the behavior manifests on machines that do not have the registry value, please specify their OS and architecture so we can replicate the behavior.

All the best,
Mihai
Mihai Petcu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
cbooth
Posts: 14
Joined: Tue Jan 04, 2011 9:37 pm

Re: MSSQL conditional Prereq Issue

Thanks for the quick reply Mihai!

I've so far seen this happen on 2 machines. One was a Windows 7 64bit without SP1 installed. The other was WinXP 32bit (I'm checking with the client to get the SP level).

I've checked both machines to make absolutely sure that MSSQL was not installed on either. The Win7 64bit was a brand new machine that had never had MSSQL installed (I verified that the reg entry was not even there). Curiously, I was able to install just fine on another new Win7 (non SP1) 64bit machine.

Based on http://msdn.microsoft.com/en-us/library ... s.85).aspx, I'm understanding that because the log states in both cases "Installed: Absent" that the installer knows that MSSQL is not installed, but is choosing not to install it for some reason. Am I understanding this correctly?

I have full logs from both of the failed installs as well as the good install I did on the Win7 64bit as well as my .aip file. Would it be helpful for me to send you those?

Thanks!
mihai.petcu
Posts: 3860
Joined: Thu Aug 05, 2010 8:01 am

Re: MSSQL conditional Prereq Issue

Hello,

I have tested our "SQL Server 2005 Express SP3" predefined prerequisite with the registry search criteria described in this thread and it works fine on both Windows 7 x64 and XP x86.

From your .AIP I noticed you weren't using our predefined prerequisite. You should review your "MSSQL 2005 Express SP4" custom prerequisite's search criteria as it is reason for this behavior.

All the best,
Mihai
Mihai Petcu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
cbooth
Posts: 14
Joined: Tue Jan 04, 2011 9:37 pm

Re: MSSQL conditional Prereq Issue

Mihai,

I also get the install to work fine on SOME Win7 64bit and WinXP 32bit machines. It's only a few that it's not installing on. However, I've checked and rechecked the machines on which this is failing, and as far as I can tell, the installer should install the MSSQL feature. MSSQL has NEVER been installed on these machines. Unless I'm completely misunderstanding something, if I set a "Registry entry exists" as one of the install conditions on the prereq and choose "Install if any of the above searches fails", and that registry entry does not exist, the prereq should install, correct?

I'm also still confused about the fact that on the failing machines, the Feature line in the log states "Installed: Absent" indicating that the installer indeed finds that this is not installed. Is that not correct? Why, on the failing installs, does the feature line show "Request: Null; Action: Null;" if the installer knows it should install that feature? Or am I simply misunderstanding what this log line is telling me?

Could you also please tell me what registry entry the "Product Version (identify by Product Code)" is looking for? Perhaps I'm not checking in the correct place in the registry for that one. I assumed that if I did a search across the entire registry, and can't find that Product Code in there, then that install condition should also fail.

I'm certainly willing to accept that I've set something up incorrectly. However, based on investigation on the machines that are failing and the logs, I just can't see what I'm missing.

Thanks!
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Re: MSSQL conditional Prereq Issue

Hi,
Unless I'm completely misunderstanding something, if I set a "Registry entry exists" as one of the install conditions on the prereq and choose "Install if any of the above searches fails", and that registry entry does not exist, the prereq should install, correct?
Yes, this is true. I noticed you are using a mixed 32/64-bit package and that your prerequisite is feature-based. For this type of package you need 2 feature-based prerequisites: one for 32-bit and another one for 64-bit. The 64-bit one can use the "64-bit" option from Edit Prerequisite dialog.

Another approach is to use a global prerequisite.
Why, on the failing installs, does the feature line show "Request: Null; Action: Null;" if the installer knows it should install that feature?
The "Installed" attribute represents the feature state, if it's installed or not. Request and Action are used for the feature action, which is what the installer will do. Just because the state is not installed doesn't mean that the action will be install.
Could you also please tell me what registry entry the "Product Version (identify by Product Code)" is looking for?
It's not looking for a registry. It's looking for a ProductVersion based on a specific ProductCode. This search uses the Windows Installer API to find products.

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
cbooth
Posts: 14
Joined: Tue Jan 04, 2011 9:37 pm

Re: MSSQL conditional Prereq Issue

Thanks for the reply Cosmin!

I still have some questions:
I noticed you are using a mixed 32/64-bit package and that your prerequisite is feature-based. For this type of package you need 2 feature-based prerequisites: one for 32-bit and another one for 64-bit.
We're actually installing all of our processes as 32bit apps. The only reason I have the mixed package is to handle some hardware driver installs correctly. I'm not sure I understand the requirement for 2 prereqs, as I am able to install on some 64bit machines with this setup just fine.

It seems that the installer is, for some reason, seeing the prereq as installed, even though the registry entry install condition I've specified is definitely not on the problem machines. Is there something else I can look for in the log that may give me more information about why this is happening (perhaps a log entry that would tell me what this install condition is being set to and/or why)?

Or perhaps I'm not using an appropriate install condition. I'm looking at the registry entry "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\OurInstanceName" to determine if our named instance of MSSQL is installed. Is that not the appropriate way to check for this?

Thanks!
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Re: MSSQL conditional Prereq Issue

Hi,
We're actually installing all of our processes as 32bit apps.
Please note that a mixed 32/64-bit package will be installed as 64-bit on a 64-bit machine. So a 32-bit feature-based prerequisite will be ignored. Only 64-bit feature based prerequisites and global prerequisites will be installed.
It seems that the installer is, for some reason, seeing the prereq as installed
It doesn't. You mentioned it yourself, it's initial state is Absent and its action is Null. Basically, it's detected as missing, but the installation ignores it.
Is there something else I can look for in the log that may give me more information about why this is happening
Did you try using a separate 64-bit prerequisite or using a global prerequisite?

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
cbooth
Posts: 14
Joined: Tue Jan 04, 2011 9:37 pm

Re: MSSQL conditional Prereq Issue

Hi Cosmin,

Thanks for the response. I think there are some issues with the information you supplied. Let me explain:
Please note that a mixed 32/64-bit package will be installed as 64-bit on a 64-bit machine. So a 32-bit feature-based prerequisite will be ignored. Only 64-bit feature based prerequisites and global prerequisites will be installed.
I don't believe this to be true, as I've installed this on numerous 64bit machines and it successfully installed the prerequisite. I've only run into 3 64bit machines that have exhibited this behavior so far. If I understood your statement correctly, this install shouldn't work on ANY 64bit machines, correct?

Also, I'm having this same issue (with the same log results) on a Win XP 32bit machine, so I wouldn't think the prereq would be ignored in that situation would it?
Did you try using a separate 64-bit prerequisite or using a global prerequisite?
I can't use a global prereq because I have to localize the MSSQL install command line, and found out a few months ago that this is not possible with global prereqs. If something has changed or I misunderstood that, please let me know and I'll try a global prereq.

Thanks,
Chris
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Re: MSSQL conditional Prereq Issue

Hi Chris,

Did you try using separate 32-bit and 64-bit prerequisites like I mentioned in my previous posts?
I don't believe this to be true, as I've installed this on numerous 64bit machines and it successfully installed the prerequisite.
Can you please send us a verbose log for one of these installations? Perhaps something is not configured correctly.

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
cbooth
Posts: 14
Joined: Tue Jan 04, 2011 9:37 pm

Re: MSSQL conditional Prereq Issue

Hi Cosmin,

I've forwarded an email with a number of install logs and my aip (I've explained what each of the logs are in the email).

Thanks for the help!

Return to “Common Problems”