title: TIBCO MDM Catalogue Conflicts
body: <p>I have multiple records in Conflict in a TIBCO MDM Version 8.3.2 (182).</p>
  <p>I can identify some conflicted records by running the following query, using the Catalogue Table to identify different catalogs that a record might have a conflict on.</p>
  <pre><code>SELECT
  '34304' AS &quot;CATALOGID&quot;,
  MEM.CPRODUCTID, 
  MEM.CPRODUCTKEYID, 
  mem.csourcesystemid AS &quot;SSKEY&quot;,
  MAX(MEM.CMODVERSION) AS &quot;MAXVERSION&quot;, 
  GC.VERSION,
  GC.MODDATE
      FROM MCT_34304 MEM
      INNER JOIN GOLDENCOPY GC
  ON GC.PRODUCTKEY = MEM.CPRODUCTKEYID AND GC.CATALOGID = 34304 
  GROUP BY
  MEM.CPRODUCTID,
  MEM.CPRODUCTKEYID,
  mem.csourcesystemid,
  GC.VERSION, 
  GC.MODDATE
   HAVING GC.VERSION &lt;&gt; MAX(MEM.CMODVERSION) 
  </code></pre>
  <p>There are records in conflict that aren't the latest version, these are preventing updates to master data.
  I realize this SQL is only looking for versions that aren't the latest version, this was the initial approach taken to identify records in conflict.</p>
  <p>The MDM is running on Oracle Exadata.</p>
  <p>Has anyone had this problem, or have a suggestion on how I can show all conflicted records?</p>
  <p>Thanks.</p>