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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
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.