4 Replies Latest reply: Jan 9, 2014 2:16 PM by MWard RSS

Trouble saving Data Modeler design 4.0EA3

user12073397 Newbie
Currently Being Moderated

Hello,

 

I'm having trouble saving a Data Modeler design.  I can create and import tables into a physical model; however, when i save the model (File > Data Modeler > Save) it doesn't appear to be saved correctly since the resulting .dmd file is 0 bytes.  If i close the design and reopen it, none of the tables that i created appear.

 

I'm using version  SQL Developer Version 4.0.0.13.30 on Windows 7.

 

Thanks,

Pete

  • 1. Re: Trouble saving Data Modeler design 4.0EA3
    Philip Stoyanov Guru
    Currently Being Moderated

    Hi Pete,

     

    can you check log file for errors logged there? It's default location is sqldeveloper\sqldeveloper\extensions\oracle.datamodeler\log directory.

    Custom location can be set in "Preferences>Environment>Log".

    Do you have similar issues with standalone version of Data Modeler?

    Can you run sqldeveloper64.exe (or sqldeveloper.exe if you are under Win32) from sqldeveloper\sqldeveloper\bin directory and check for errors appearing in console?

     

    Philip

  • 2. Re: Trouble saving Data Modeler design 4.0EA3
    user12073397 Newbie
    Currently Being Moderated

    i don't see any recent errors in the datamodeler.log file.  the only entries for the last 2 days are:

     

    2013-11-12 11:04:52,116 [AWT-EventQueue-0] INFO  DataModelerAddin - Oracle SQL Developer Data Modeler 4.0.0.825
    2013-11-12 11:15:12,672 [AWT-EventQueue-0] INFO  DataModelerAddin - Oracle SQL Developer Data Modeler 4.0.0.825
    2013-11-12 11:26:59,517 [AWT-EventQueue-0] INFO  DataModelerAddin - Oracle SQL Developer Data Modeler 4.0.0.825
    2013-11-12 16:54:18,313 [AWT-EventQueue-0] INFO  DataModelerAddin - Oracle SQL Developer Data Modeler 4.0.0.825
    2013-11-13 10:44:03,694 [AWT-EventQueue-0] INFO  DataModelerAddin - Oracle SQL Developer Data Modeler 4.0.0.825
    2013-11-13 10:49:26,093 [AWT-EventQueue-0] INFO  DataModelerAddin - Oracle SQL Developer Data Modeler 4.0.0.825
    2013-11-13 11:08:11,679 [AWT-EventQueue-0] INFO  DataModelerAddin - Oracle SQL Developer Data Modeler 4.0.0.825

     

    if run sqldeveloper\sqldeveloper\bin\sqldeveloper.exe, the only message in the console is:

     

    LOAD TIME : 205

     

    no other messages.

     

    I have 3 different builds of sql developer 4.x - they all have this problem.  My 3.2 build does not have this problem.  So, next, i installed the Data Modeler standalone version (4.0.0.825) and created a physical model with just one table - and i was able to save it!  The .dmd had the following content (not 0 byte):

     

    <?xml version = '1.0' encoding = 'UTF-8'?>
    <OSDM_Design class="oracle.dbtools.crest.model.design.Design" name="test_dm_only" id="986F3685-3223-BAF6-8D69-6C2C4C52718E" version="3.5">
    <createdBy>HillsP01</createdBy>
    <createdTime>2013-11-13 16:36:18 UTC</createdTime>
    <ownerDesignName>test_dm_only</ownerDesignName>
    <capitalNames>false</capitalNames>
    <designId>986F3685-3223-BAF6-8D69-6C2C4C52718E</designId>
    </OSDM_Design>

     

    So, looks like the Data Modeler works, but there's a problem with my installation with the full SQL Developer product.  One thing that i noticed is that my full SQL Developer install does not have a full list of logical types.  I had to manual create a the ones that i use.  In the Data Modeler only install, all of the logical types were available out of the box.

  • 3. Re: Trouble saving Data Modeler design 4.0EA3
    Philip Stoyanov Guru
    Currently Being Moderated

    Hi Pete,

     

    One thing that i noticed is that my full SQL Developer install does not have a full list of logical types.

    You need to check setting for "system data types" directory in preferences. Setting for it should be empty or point to directory that contains actual status of files types.xml and defaultRDBMSSites.xml

    as they come with SQL Dev installation. Their default location in SQL Developer is - sqldeveloper\sqldeveloper\extensions\oracle.datamodeler\types

     

    Philip

  • 4. Re: Trouble saving Data Modeler design 4.0EA3
    MWard Newbie
    Currently Being Moderated

    I recently had a bug where my "system data types" preference was overwritten for ALL installations of SDDM.  Thanks for this post to pointing out how to fix the problem of all data types missing.  All types in all of my models were showing unknown.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points