Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

ORA-04031

anurag
2005-09-10
2013-05-02
  • anurag
    anurag
    2005-09-10

    Hi!!
    ia m using version 2.5.2d
    i am facing a problem while querying product list in requisition, purchase order, invoice (vendor) etc screens. i am searching with search criter % and it shows me zero resullt. in backend i am getting error:
    .sql.SQLException: ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_allocate_pal")
    ; State=61000; ErrorCode=4031

    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:623)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
    at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
    at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:915)
    at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
    at org.compiere.util.CPreparedStatement.executeQuery(CPreparedStatement.java:99)
    at org.compiere.apps.search.Info$Worker.run(Info.java:910)

    i have tried increasing shared pool memory in database, but still getting the error.

    can u please tell me why the error is coming and what should i do to remove it.

    thanks in advance

    anurag

     
    • Paulo Emerique
      Paulo Emerique
      2005-09-15

      Check if you dont have a recursive Bill of materials (the product included on its own item list) ... cause this causes an infinite loop.

      We faced this once.