Hello,
I use Oracle Data Modeler standalone version 23.1.0.087.0806.
Me and my colleague were trying to test team collaboration using SVN.
SVN communication is working, we can see and process Incoming changes and Outgoing changes.
Currently we face one problem.
User1 created new table and new foreign key in existing model, and changes were commited to SVN repository.
When User2 merged Incoming Changes, new FK was merged as “Index proxy” into Physical model (12cR2). So the result was missing FK on the table + additional Index on the table, with the name of missing FK and no columns. Additional Outgoing changes were automatically generated to transfer this error to SVN repository.
We also tried to delete WC from local directory and check out the model from SVN repository to find out where the problem is. When we checked out, everything is fine, FK exists and no index proxy is present. So the problem is around Merge of Incoming changes in Modeler.
We did compare source (User1), middle (SVN) and target (User2) xml of the table.
Source xml is the same as middle xml. Here is FK definition:
<foreignKeys>
<ForeignKey class="oracle.dbtools.crest.model.design.storage.oracle.v10g.FKProxyOraclev10g" name="fk_new_table_robert3_new_table_robert2" id="0058CF87-F1BA-C07D-1233-EBBF5AEFD58B">
<createdBy>User1</createdBy>
<createdTime>2024-08-07 07:54:46 UTC</createdTime>
<ownerDesignName>ModelTest</ownerDesignName>
</ForeignKey>
</foreignKeys>
Target xml has no foreignKeys tag, but it has this section:
<indexProxies>
<IndexProxy class="oracle.dbtools.crest.model.design.storage.oracle.v10g.IndexProxyOraclev10g" name="fk_new_table_robert3_new_table_robert2" id="0058CF87-F1BA-C07D-1233-EBBF5AEFD58B">
<createdBy>User2</createdBy>
<createdTime>2024-08-07 07:57:01 UTC</createdTime>
<ownerDesignName>ModelTest</ownerDesignName>
</IndexProxy>
</indexProxies>
It looks like Merge changed object class from FK to Index.