Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Duplicate files for objects causing errors when importing data dictionary

chris.saxonMay 24 2013
Hi,

I have a data modeler design I want to compare against the data dictionary for the actual database it represents (via File -> Import -> Data Dictionary). When doing this I get an error. Looking in the log file I see this:

2013-05-24 11:05:20,257 [Thread-154] ERROR XMLTransformationManager - Duplicated file for ID - D16C9832-97EC-0B00-E7DE-8018A9E276B6
path - C:\Projects\cam_test\obs\rel\43C5D565-3D3E4E638779\phys\32076570-BF29817DFF70\View\seg_5\D16C9832-97EC-0B00-E7DE-8018A9E276B6.xml

2013-05-24 11:13:49,683 [Thread-170] ERROR DBMExtractionController - Error Generate Design: obs

java.lang.NullPointerException

at oracle.dbtools.crest.model.design.compare.CompareModelToModel.addFK(Unknown Source)

at oracle.dbtools.crest.model.design.compare.CompareModelToModel.addTableDetails(Unknown Source)

at oracle.dbtools.crest.model.design.compare.CompareModelToModel.addTable(Unknown Source)

at oracle.dbtools.crest.model.design.compare.CompareModelToModel.addFromSourceModel(Unknown Source)

at oracle.dbtools.crest.model.design.compare.CompareModelToModel.<init>(Unknown Source)

at oracle.dbtools.crest.swingui.compare.CompareModelsDialog.<init>(Unknown Source)

at oracle.dbtools.crest.swingui.compare.CompareModelsDialog.<init>(Unknown Source)

at oracle.dbtools.crest.imports.metadata.DBMExtractionController$Runner.run(Unknown Source)

at java.lang.Thread.run(Thread.java:662)

There's large number of files raising the "duplicated file" message. Looking on the filesystem I can see the duplications:

chrissa@pc-12112 /cygdrive/c/Projects/cam_test/obs/rel/43C5D565-3D3E4E638779
$ find . -name D16C9832-97EC-0B00-E7DE-8018A9E276B6.xml
./phys/32076570-BF29817DFF70/View/seg_0/D16C9832-97EC-0B00-E7DE-8018A9E276B6.xml
./phys/32076570-BF29817DFF70/View/seg_5/D16C9832-97EC-0B00-E7DE-8018A9E276B6.xml
./view/seg_5/D16C9832-97EC-0B00-E7DE-8018A9E276B6.xml

Is there an easy way to clear up the duplicated files? I'm using v 3.3.0.747 of Oracle Data Modeler.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2013
Added on May 24 2013
0 comments
501 views