Forum Stats

  • 3,814,949 Users
  • 2,258,933 Discussions
  • 7,892,894 Comments

Discussions

Please Help; Its a bug in tool or I'm missing something;

Data Dictionary Import is Failing For Foreign Key Constraints; Gives Empty relationship ER Diagrams.

Import failed – using the data dictionary built in feature I connected to the oracle instance and started loading table. However, after choosing the required schema and tables I see the below error in the log generated. In-fact the entity is generated in the physical relation and I see the count of table but, the constraints are failed to load. Thus, it gave me a E-R diagrams with out connecting relationship which is of no use. I also, look into engineer to logical design but no luck. Please help.

Error:

2021-05-19 10:49:40 INFO – Oracle SQL Developer Data Modeler 21.1.0.092.1221

2021-05-19 10:54:49 SEVERE – Error in database import:

java.lang.NullPointerException

at oracle.dbtools.crest.imports.metadata.oracle.CheckConstraintsImport.processCheckConstr(CheckConstraintsImport.java:277)

at oracle.dbtools.crest.imports.metadata.oracle.CheckConstraintsImport.initCHECK_Constraints(CheckConstraintsImport.java:256)

at oracle.dbtools.crest.imports.metadata.oracle.MOHTableOracle.generate(MOHTableOracle.java:466)

at oracle.dbtools.crest.imports.metadata.AbstractDBMExtractionHandler.generateDesign(AbstractDBMExtractionHandler.java:303)

at oracle.dbtools.crest.imports.metadata.oracle.DBMExtractionHandlerOracle.generateDesign(DBMExtractionHandlerOracle.java:283)

at oracle.dbtools.crest.imports.metadata.DBMExtractionController$EmptyRunner.run(DBMExtractionController.java:514)

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

I logged in with DBA privileged user and version for sql data modeler is 21+ and using the latest JDK 11+. I have verified below checklist as well –

Check1:

select dbms_metadata.get_ddl(‘TABLE’,'<>’,'<>’) from dual ; this able to give the ddl script with foreign key constraints included.

Check2:

In SQL Developer, right click the object that you want to generate a script for. i.e. the table name, this able to give the ddl script with foreign key constraints included.

Check3:

Generate in DDL: Controls whether the foreign key creation is included when DDL

statements are generated to be used to create the database.

Go to FILE -> DATA MODELLER -> EXPORT -> DDL FILE.

New pop up window appear.

Click on Generate button.

New pop window appears.

Now click on “Generate DDL scripts in Separate Files”, on screen at bottom right.

Now go to tab “Include TABLE DDL scripts.

Select table you want to have DDL scripts.

click ok.

[ fails to get the foreign key constraints loaded with the sql data modeler ]

Check4:

SELECT * FROM user_constraints where owner = <> AND TABLE_NAME=<> AND constraint_type = ‘R’; [ able to see the FK and the status is enabled ]

SELECT * FROM all_constraints where <> AND TABLE_NAME=<> AND constraint_type = ‘R’; [ able to see the FK and the status is enabled ]

Check5:

Right click on the relation E-R Diagram and try via Synchronize with Data Dictionary; [ Unable to load data dictionary using this option ]

Answers