[GUSDEV] schema dump of 3.0 database using 3.5 dbaDumpSchema

[marc j. <de...@ho...>]

Hello,

It was unsuccessful, but I'm having a hard time understanding what the
error messages mean.

I ran: ./gus_home/bin/dbaDumpSchema -sourceType db -targetType xml -target 
/var/tmp/report.xml.

I got:

Nov 2, 2006 9:03:23 AM org.gusdb.dbadmin.reader.SchemaReader doRead
INFO: Reading Database
Nov 2, 2006 9:03:23 AM org.gusdb.dbadmin.reader.OracleReader readDatabase
INFO: Reading database: null
Nov 2, 2006 9:03:33 AM org.gusdb.dbadmin.reader.OracleReader addColumns
SEVERE: Error querying for constraint columns: java.sql.SQLException: 
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

Exception in thread "main" java.lang.RuntimeException: 
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

        at 
org.gusdb.dbadmin.reader.OracleReader.addColumns(OracleReader.java:446)
        at 
org.gusdb.dbadmin.reader.OracleReader.addLocalConstraints(OracleReader.java:562)
        at 
org.gusdb.dbadmin.reader.OracleReader.addTables(OracleReader.java:200)
        at 
org.gusdb.dbadmin.reader.OracleReader.addSchemas(OracleReader.java:150)
        at 
org.gusdb.dbadmin.reader.OracleReader.readDatabase(OracleReader.java:107)
        at 
org.gusdb.dbadmin.reader.SchemaReader.doRead(SchemaReader.java:50)
        at org.gusdb.dbadmin.reader.SchemaReader.read(SchemaReader.java:38)
        at org.gusdb.dbadmin.util.SchemaDumper.main(SchemaDumper.java:98)
Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL 
level 1
ORA-01000: maximum open cursors exceeded

        at 
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:622)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:111)
        at 
oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:350)
        at 
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:895)
        at 
oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:382)
        at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:985)
        at 
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1124)
        at 
org.gusdb.dbadmin.reader.OracleReader.addColumns(OracleReader.java:414)
        ... 7 more

What do these error messages mean and how do I fix them?

Regards,

Marc

_________________________________________________________________
Try Search Survival Kits: Fix up your home and better handle your cash with 
Live Search! 
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=hmtagline