Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1572

Unable to import over 5000 Tables from Oracle schema due to maximum open cursors exceeded

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.1
    • 7.7
    • Import/Export
    • None

    Description

      Importing from oracle data source produced the following error:

      !STACK 0
      java.sql.SQLException: ORA-01000: maximum open cursors exceeded

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
      at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:853)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
      at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1469)
      at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:389)
      at oracle.jdbc.OracleDatabaseMetaData.getCatalogs(OracleDatabaseMetaData.java:3120)
      at com.metamatrix.modeler.jdbc.relational.impl.RelationalModelProcessorImpl.getCatalogs(RelationalModelProcessorImpl.java:2529)
      at com.metamatrix.modeler.jdbc.relational.impl.RelationalModelProcessorImpl.computeNameInSource(RelationalModelProcessorImpl.java:2616)
      at com.metamatrix.modeler.jdbc.relational.impl.custom.OracleModelProcessor.computeNameInSource(OracleModelProcessor.java:263)
      at com.metamatrix.modeler.jdbc.relational.impl.RelationalModelProcessorImpl.setNameAndNameInSource(RelationalModelProcessorImpl.java:2469)
      at com.metamatrix.modeler.jdbc.relational.impl.RelationalModelProcessorImpl.setNameAndNameInSource(RelationalModelProcessorImpl.java:2422)
      at com.metamatrix.modeler.jdbc.relational.impl.RelationalModelProcessorImpl.createNewObject(RelationalModelProcessorImpl.java:1104)
      at com.metamatrix.modeler.jdbc.relational.impl.RelationalModelProcessorImpl.performExecute(RelationalModelProcessorImpl.java:824)
      at com.metamatrix.modeler.jdbc.relational.impl.RelationalModelProcessorImpl$1.run(RelationalModelProcessorImpl.java:329)
      at com.metamatrix.modeler.internal.core.ModelEditorImpl.executeAsTransaction(ModelEditorImpl.java:550)
      at com.metamatrix.modeler.internal.core.ModelEditorImpl.executeAsTransaction(ModelEditorImpl.java:593)
      at com.metamatrix.modeler.jdbc.relational.impl.RelationalModelProcessorImpl.executeWithinTransaction(RelationalModelProcessorImpl.java:336)
      at com.metamatrix.modeler.jdbc.relational.impl.RelationalModelProcessorImpl.executeWithinTransaction(RelationalModelProcessorImpl.java:312)
      at com.metamatrix.modeler.jdbc.relational.impl.RelationalModelProcessorImpl.execute(RelationalModelProcessorImpl.java:302)
      at com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportWizard.runFinish(JdbcImportWizard.java:716)
      at com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportWizard$1.run(JdbcImportWizard.java:275)
      at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
      !SUBENTRY 1 org.teiid.designer.compare 0 50010 2013-01-30 09:43:41.558
      !MESSAGE Completed difference analysis

      Attachments

        Activity

          People

            blafond Barry LaFond
            van.halbert Van Halbert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: