My Oracle Support Banner

SVN: ODI Studio Incorrectly Detects Differences and Shows No Code for "JOIN" Condition when "Compare Results" (Doc ID 2312860.1)

Last updated on DECEMBER 13, 2024

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

After instantiating a new branch from a tag (on an empty repository), when looking at Version History and "Compare Results" for Oracle Data Integrator (ODI) mappings that contain a JOIN immediately show a difference between the ODI repository and SVN: ODI shows no code for the JOIN in SVN, and does show code for the JOINS in the ODI repository, even though the mapping comes directly from SVN and was not modified.

This is the same behavior that was fixed by Patch 26249461 for FILTERS, but here it is for JOINS.

Example reproduction:

  1. In Trunk: create a full or partial tag containing mappings that makes use of "JOIN" filter conditions.
     
  2. Create a branch from trunk
     
  3. Login to the empty Work Repository (WR) associated with the newly created branch.
     
  4. In ODI Studio menu, select Team > VCS Actions > Populate from VCS
     
  5. Right click on the mapping.
    Select: Version - Version History

  6. In Version History window, select icon to "Compare Versions"
        
  7. Notice that even though no changes were done, there are changes shown for the "JOIN" condition, and the SVN repository is found to have an empty join condition

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.