9 Replies Latest reply: Jun 21, 2013 2:37 AM by dblol RSS

    Cannot Edit Relational Model

    dblol

      I created a relational model by importing from the data dictionary.  The model is residing on my local machine as it is only a test.

      I now cannot edit the table definitions whereas I was able to yesterday. When I bring up the properties dialog on any object all the fields are disabled.

      The New Table button (and all the rest of the buttons) do not activate.  The DDL File Editor works and the search function but nothing else.

      What do I have to change here to be able to edit the relational model?

        • 1. Re: Cannot Edit Relational Model
          Philip Stoyanov-Oracle

          Hi,

           

          thanks for reporting the problem. I logged a bug for that.

           

          Philip

           

          PS sorry I logged a bug for another post. The problem is still unclear in your case

          • 2. Re: Cannot Edit Relational Model
            dblol

            More information:

            I have run another test to determine at what stage I could no longer edit the table definitions.  I did the following:

             

            I created the relational model by importing from a specific user - let's call it myproduct_0_10_1 (data dictionary import).

             

            [Aside, we create new users for each deployment/build and the "0_10_1" in my example is the version of that build.  When I imported all the tables were prefixed with myproduct_0_10_1.  We don't actually want to prefix the tablenames with a user/schema name at all.  The model name reflects the product and each product is contained wholly in one user schema.  The DDL that we generate becomes part of the complete software deployment and is tagged with a particular version number in subversion so we don't want or need the version number in the schema name in any case.]

             

            I removed all the database objects from the schema myproduct_0_10_1 and deleted the schema (as we do not wish the table names to be prefixed).   At this stage I was unable to edit the table definitions.

             

            However I did create a new schema called myproduct (without the version number) and assigned all the database objects to that.  I was still unable to edit the table definitions.

             

            I recreated the user "myproduct_0_10_1" and assigned all the database objects to that instead.  I was again able to edit the table definitions.

             

            It seems that you cannot change the schema name which is highly undesirable.

            • 3. Re: Cannot Edit Relational Model
              Philip Stoyanov-Oracle

              What version of Data Modeler do you use?

               

              Philip

              • 4. Re: Cannot Edit Relational Model
                dblol

                I am running version 3.3.0-747 32-bit version running on 64 bit Windows 7.  I installed the version of the install without the jre.  Our development environment is currently using java 1.7 or 7 as they like to call it but although not strictly supported I wouldn't have thought this would be the cause of the issue.

                 

                I was primarily wondering whether there is some constraint on the reassigning of tables to different schemas or not assigning them at all as it seems that they are tied to the original schema it was imported under (which would be less than ideal).

                • 5. Re: Cannot Edit Relational Model
                  Philip Stoyanov-Oracle

                  can you check log file for problems logged there - its default location is datamodeler\datamodeler\log of your DM installation and is named datamodeler.log

                  Also, can you start Data Modeler in console mode - run datamodeler.exe in datamodeler\datamodeler\bin directory and look for errors reported in console window.

                   

                  Philip

                  • 6. Re: Cannot Edit Relational Model
                    dblol

                    The log file does have some issues.  I will try the test case out again some time to discern exactly what operations are causing the errors/null pointers to occur.  So I suspect you are saying that data modeler should allow you to reassign table objects to other schemas or not have one at all?

                     

                    Anyway, here is the log.

                     

                    2013-06-18 17:19:51,838 [main] INFO  ApplicationView - Oracle SQL Developer Data Modeler 3.3.0.747

                    2013-06-18 17:20:00,560 [main] INFO  ApplicationView - Oracle SQL Developer Data Modeler 3.3.0.747

                    2013-06-18 17:48:10,144 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    C:\Untitled_1\rel\4576A702-6CFEB00BAA2C\table/seg_0/2E2D0964-428F-F0E0-EF6A-0E055C25A05A.xml

                    2013-06-18 17:49:57,178 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    C:\Untitled_1\rel\A74345DA-8A7414372BA4\table/seg_0/557CF798-BA1C-A2E7-23E8-EF6F31F1E485.xml

                    2013-06-18 17:50:28,926 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    \rel\A74345DA-8A7414372BA4\view/seg_0/A43E12DD-6D3B-E6BA-741C-DC2887319CB9.xml

                    2013-06-18 17:53:43,768 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\4576A702-6CFEB00BAA2C\table/seg_0/2E2D0964-428F-F0E0-EF6A-0E055C25A05A.xml

                    2013-06-18 19:01:25,509 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_1/41D49440-D623-9176-1B45-04DA2A2A83FD.xml

                    2013-06-19 12:46:10,028 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_1/41D49440-D623-9176-1B45-04DA2A2A83FD.xml

                    2013-06-19 12:49:50,353 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\4576A702-6CFEB00BAA2C\table/seg_0/2E2D0964-428F-F0E0-EF6A-0E055C25A05A.xml

                    2013-06-19 12:52:07,832 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/B1C8D4BF-6522-7E1B-7548-25C781B2E437.xml

                    2013-06-19 13:02:50,276 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/2AEFD50A-BA30-9E2F-DCCF-AB19E7264C2F.xml

                    2013-06-19 13:09:55,297 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/13FAE02E-2542-D2C3-423B-2EA46BA9D0D4.xml

                    2013-06-19 13:14:07,664 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\4576A702-6CFEB00BAA2C\table/seg_0/2E2D0964-428F-F0E0-EF6A-0E055C25A05A.xml

                    2013-06-19 13:15:10,604 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\4576A702-6CFEB00BAA2C\table/seg_0/2E2D0964-428F-F0E0-EF6A-0E055C25A05A.xml

                    2013-06-19 13:18:30,745 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/B1C8D4BF-6522-7E1B-7548-25C781B2E437.xml

                    2013-06-19 13:19:14,543 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/B1C8D4BF-6522-7E1B-7548-25C781B2E437.xml

                    2013-06-19 13:19:33,362 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/843FF87C-EEE1-6CA5-960F-4208DC01664D.xml

                    2013-06-19 13:28:44,545 [main] INFO  ApplicationView - Oracle SQL Developer Data Modeler 3.3.0.747

                    2013-06-19 13:29:59,069 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/A3572ADF-ADB6-EBAC-8D92-558CD002DAC5.xml

                    2013-06-19 13:33:22,504 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\4576A702-6CFEB00BAA2C\table/seg_0/2E2D0964-428F-F0E0-EF6A-0E055C25A05A.xml

                    2013-06-19 13:38:10,769 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\4576A702-6CFEB00BAA2C\table/seg_0/2E2D0964-428F-F0E0-EF6A-0E055C25A05A.xml

                    2013-06-19 13:39:05,659 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/4D591A30-CE1A-5115-ACA6-F8CB66FE993A.xml

                    2013-06-19 13:41:22,803 [AWT-EventQueue-0] ERROR MDBAction - java.lang.ClassCastException: oracle.dbtools.crest.model.design.relational.FKIndexAssociation cannot be cast to oracle.dbtools.crest.model.design.relational.Table

                    2013-06-19 14:10:55,717 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/4D591A30-CE1A-5115-ACA6-F8CB66FE993A.xml

                    2013-06-19 14:11:48,491 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_1/95274DB9-40B9-BEC5-0096-C2C8C84CF1C1.xml

                    2013-06-19 14:13:16,243 [AWT-EventQueue-0] ERROR MDBAction - java.lang.NullPointerException

                    2013-06-19 14:16:48,546 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\4576A702-6CFEB00BAA2C\table/seg_0/2E2D0964-428F-F0E0-EF6A-0E055C25A05A.xml

                    2013-06-19 14:57:33,791 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\4576A702-6CFEB00BAA2C\table/seg_0/2E2D0964-428F-F0E0-EF6A-0E055C25A05A.xml

                    2013-06-19 14:59:02,358 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/13FAE02E-2542-D2C3-423B-2EA46BA9D0D4.xml

                    2013-06-19 14:59:17,433 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_0/557CF798-BA1C-A2E7-23E8-EF6F31F1E485.xml

                    2013-06-19 14:59:39,883 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_1/21D945DE-ACA4-9C0D-A4B4-6096FF1DB8C0.xml

                    2013-06-19 15:00:00,979 [AWT-EventQueue-0] ERROR DesignObject - DesignObject.updateFromRemoteObject -file for remote object doesn't exist:

                    F:\TestModel\rel\A74345DA-8A7414372BA4\table/seg_1/21D945DE-ACA4-9C0D-A4B4-6096FF1DB8C0.xml

                    2013-06-19 15:55:35,146 [main] INFO  ApplicationView - Oracle SQL Developer Data Modeler 3.3.0.747

                    • 7. Re: Cannot Edit Relational Model
                      Philip Stoyanov-Oracle
                      • So I suspect you are saying that data modeler should allow you to reassign table objects to other schemas or not have one at all?

                      Yes, it's basic functionality and there is no restriction on that. You don't need to delete schema if you don't want it in generated DDL - there is an option to suppress appearance of schema in generated DDL - "Tools>Preferences>Data Modeler>DDL>Include Schema in DDL"

                      More questions:

                      1) Do you see link symbol on the upper left corner of table

                      2) Can you post content of your dmd file here - no confidential info in it


                      Philip

                      • 8. Re: Cannot Edit Relational Model
                        dblol

                        Yes I did realize that you could generate the schema without the schema prefix on all objects.  I just didn't want to see it in the browser at all.

                         

                        Contents of dmd file:

                        <?xml version = '1.0' encoding = 'UTF-8'?>

                        <OSDM_Design class="oracle.dbtools.crest.model.design.Design" name="TestModel2" id="5C4EAD11-B0B6-04E9-A6A7-18AEA77F9E75" version="3.5">

                        <createdBy>lplajbes</createdBy>

                        <createdTime>2013-06-19 06:25:35 UTC</createdTime>

                        <ownerDesignName>TestModel2</ownerDesignName>

                        <capitalNames>false</capitalNames>

                        <designId>5C4EAD11-B0B6-04E9-A6A7-18AEA77F9E75</designId>

                        </OSDM_Design>

                        • 9. Re: Cannot Edit Relational Model
                          dblol

                          I do you see link symbol on the corner of table (but bottom right not top left).

                           

                          Now I have just opened up TestModel2 and now when I remove the schema association to the tables I can edit them (not sure what changed in the last day - I wasn't able to edit them yesterday.

                           

                          In original test model however I can't.  I don't know what is different between the two and why I can now edit the table definitions in the TestModel2 "project".

                           

                          Contents of dmd file of TestModel (1):

                          <?xml version = '1.0' encoding = 'UTF-8'?>

                          <OSDM_Design class="oracle.dbtools.crest.model.design.Design" name="TestModel" id="8832B051-EF15-D35A-4824-BC278451F54E" version="3.5">

                          <createdBy>lplajbes</createdBy>

                          <createdTime>2013-06-18 07:50:00 UTC</createdTime>

                          <ownerDesignName>TestModel</ownerDesignName>

                          <capitalNames>false</capitalNames>

                          <designId>8832B051-EF15-D35A-4824-BC278451F54E</designId>

                          </OSDM_Design>