You don't need Upgrade elements if you use the MajorUpgrade element 
(recommended).  MajorUpgrade creates Upgrade Table entries.  It's complaining 
about duplicates.

--
John Merryweather Cooper
Build & Install Engineer - ESA
Jack Henry & Associates, Inc.®
Shawnee Mission, KS  66227
Office:  913-341-3434 x791011
jocoo...@jackhenry.com
www.jackhenry.com



-----Original Message-----
From: Wenzel, John [mailto:john.wen...@p66.com] 
Sent: Friday, February 7, 2014 3:14 PM
To: wix-users@lists.sourceforge.net
Subject: [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.

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
NOTICE: This electronic mail message and any files transmitted with it are 
intended
exclusively for the individual or entity to which it is addressed. The message, 
together with any attachment, may contain confidential and/or privileged 
information.
Any unauthorized review, use, printing, saving, copying, disclosure or 
distribution 
is strictly prohibited. If you have received this message in error, please 
immediately advise the sender by reply email and delete all copies.


------------------------------------------------------------------------------
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

Reply via email to