[Ed ross]

While trying to reverse a fairly complex schema in oracle I get an error about 5 minutes into the process. The error states that I’m trying to make an association to an unmapped table.

When I try and run a query (any query )after the generation error I get a number of ORA errors. The two that seems relevant are:

ORA-00604: error occurred at recursive SQL level 1.
ORA-01000: maximum open cursors exceeded.

Seems the RE tool is not cleaning up and if you have to many relationships will eventually run out of cursors and fail ( and still does not clean up). I have to terminate the connection then reopen it to do any database work.

[Loyal Water]

Can you go to MyEclipse > Installation Summary > Installation Details and paste the information here for me.

[Ed ross]

Install Summary below.

Another question – how can you reverse engineer across multiple schemas? Schema a table a makes reference to a table in schema b?

Thx

*** Date:
Thursday, February 5, 2009 6:46:29 AM EST

** System properties:
OS=WindowsVista
OS version=6.0.0
Java version=1.5.0_11

*** MyEclipse details:
MyEclipse Enterprise Workbench
Version: 7.0
Build id: 7.0-20081201

*** Eclipse details:
MyEclipse Enterprise Workbench

Version: 7.0
Build id: 7.0-20081201

Eclipse Platform

Version: 3.4.1.r341_v20080731-9I96EiDElYevwz-p1bP5z-NlAaP7vtX6Utotqsu
Build id: M20080911-1700

Eclipse Java Development Tools

Version: 3.4.1.r341_v20080709-0800-7o7tEAfEF_U5qyUgrb2HAp539P97
Build id: M20080709-0800

Eclipse Graphical Editing Framework GEF

Version: 3.4.1.v20080806-67718083A56B4H2A3213573
Build id: 200809101400

Eclipse RCP

Version: 3.4.100.r341_v20080814-989JESIEdAciFYfkZZsBfSwQ2341
Build id: M20080703-0800

Eclipse Plug-in Development Environment

Version: 3.4.1.r341_v20080731-7T7U0E9mlRIuGUYviF_VP
Build id: M20080703-0800

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\development\software\Eclipse\MyEclipse 7.0\myeclipse.exe
-name
Myeclipse
–launcher.library
C:\development\software\Eclipse\MyEclipse 7.0\../common\plugins\org.eclipse.equinox.launcher.win32.win32.x86_1.0.101.R34x_v20080731\eclipse_1115.dll
-startup
C:\development\software\Eclipse\MyEclipse 7.0\../common\plugins\org.eclipse.equinox.launcher_1.0.101.R34x_v20080819.jar
-clean
-configuration
configuration
-vm
C:\development\software\Eclipse\common\binary\com.sun.java.jre.win32.x86_1.5.0.011\bin\client\jvm.dll

[Brian Fernandes]

edross,

I’m sorry, but we don’t currently handle cross schema relationships. Are most of your relationships cross schema?

If I understand you correctly, your RE process runs for 5 minutes before it bombs out? From your report, it seems pretty obvious that the failure was caused by exceeding the cursor limit; if you reconnect, can you try reverse engineering just the table for which the error was reported? Does that work when executed on a clean connection?

Can you give us a rough idea of how many tables you have in your database and what version of Oracle you are using? Also, are you using the latest Oracle driver?

I’ll get the DB team to look at this, in the meanwhile I can only suggest reverse engineering tables in smaller groups. The first two checkboxes at the bottom of the tree on Page 3 of the RE wizard will allow you to make sure a closure of tables related to the currently selected tables are selected so you should not miss any relationships, other than cross schema relationships.

Sorry for the inconvenience caused.

[Author]

Posts