[WiX-users] The primary key {myGUID} is duplicated in table 'Upgrade'. Please remove one of the entries or rename a part of the primary key to avoid the collision.

[Wenzel, John]

I am new to this technology and to this newsgroup. If this is a more advanced 
group and there is another for beginners please inform me.

I have the following wsx file

<?xml version="1.0" encoding="UTF-8"?>
<Wix xmlns="http://schemas.microsoft.com/wix/2006/wi";>
  <?include  my.wxi ?>

  <Product
      Id="*"
      Name="$(var.APPLICATION_NAME) 
$(var.MAJOR_VERSION).$(var.MINOR_VERSION).$(var.BUILD_VERSION)"
      Language="1033"
      Version="$(var.MAJOR_VERSION).$(var.MINOR_VERSION).$(var.BUILD_VERSION)"
      Manufacturer="My Company"
      UpgradeCode="$(var.UPDATE_GUID)">
    <Package
        Id="*"
        InstallerVersion="200"
        Compressed="yes"
        InstallScope="perMachine"
        Manufacturer="My Company"
        ReadOnly="yes"
            />
    <Media
        Id="1"
        Cabinet="$(var.APPLICATION_NAME).cab"
        CompressionLevel="mszip"
        EmbedCab="yes"
            />
    <Upgrade Id="$(var.UPDATE_GUID)">
      <UpgradeVersion
          OnlyDetect="yes"
          
Minimum="$(var.MAJOR_VERSION).$(var.MINOR_VERSION).$(var.BUILD_VERSION)"
          IncludeMinimum="no"
          Property="NEWER_VERSION_FOUND" />
      <UpgradeVersion
          Minimum="0.0.0.0"
          IncludeMinimum="yes"
          
Maximum="$(var.MAJOR_VERSION).$(var.MINOR_VERSION).$(var.BUILD_VERSION)"
          IncludeMaximum="no"
          Property="OLDER_VERSION_FOUND" />
    </Upgrade>
    <MajorUpgrade
        Schedule="afterInstallInitialize"
        DowngradeErrorMessage="A newer version of $(var.APPLICATION_NAME) is 
already installed." />

......

When I run it I get the following error.

Error   1       The primary key '{.......}/4.5.1///2' is duplicated in table 
'Upgrade'.  Please remove one of the entries or rename a part of the primary 
key to avoid the collision.       pathTo\Product.wxs      27      1

The line above in bold is line 27 where the error is happening. Now the error 
to me seems quite obvious, but the GUID is used in 2 spots. In the product tag 
and the upgrade tag. I was under the impression that both of these were 
supposed to be the same. The include file just defines veriables that are 
created in the workflow build prior to the build of the wixproj.

Can anyone give me a hint of what I am missing?

Thanks,


------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users