Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-360

ORA-01000: maximum open cursors exceeded

    XMLWordPrintable

Details

    Description

      When I try to import users from JIRA I get an error that maximum number of open cursors exceeded. We set the number of maximum cursors to 1000. My DB admin says that Crowd is using too many cursors during JIRA import.

      So I'm unable to import the JIRA users.

      2007-06-14 14:45:47,515 ERROR [com.atlassian.crowd.console.action.dataimport.ImportJIRA] ORA-01000: maximum open cursors exceeded

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

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:500)
      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946)
      at com.atlassian.crowd.console.action.dataimport.ImportJIRA.importUsers(ImportJIRA.java:198)

      Attachments

        Activity

          People

            justen.stepka@atlassian.com Justen Stepka [Atlassian]
            c5b057c61007 Marc Gerstmair
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: