Hi all,
I have a problem when starting UCS application. The UCS database is in ORACLE.
In log i get the error ORA1:01000 - maximum cursors exceeded. I made some research and found out that the parameter 'open-cursors' should be increased to resolve this issue. I increased it and restart oracle. I tried to start the UCS but its still giving me the same error.
Can anyone help me?
Here is the last part of my ucs log:
XDB_INDEX_DDL_CACHE:
ORA-01000: maximum open cursors exceeded
13:39:54.981 Dbg 29999 [Ucs-Main] Additional Columns are allowed
13:39:54.981 Dbg 29999 [Ucs-Main] Missing Indexes are allowed
13:39:54.981 Dbg 29999 [Ucs-Main] [Main DS] Acquiring new connection from pool (queue size: 1 )
13:39:54.981 Dbg 29999 [Ucs-Main] [Main DS] Acquired new connection from pool in 0 ms
13:39:54.997 Std 07002 Execution failure: SQL statement 'select Id, Timestamp, Version, Description from SchemaHistory order by Timestamp, Id', reason 'ORA-01000: maximum open cursors exceeded
', error code 1000
13:39:54.997 Alarm 30001 [Ucs-Main] Unrecoverable error from while initializing DAPs:ORA-01000: maximum open cursors exceeded
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at com.jolbox.bonecp.StatementHandle.executeQuery(StatementHandle.java:464)
at com.genesyslab.sql.BaseStatement.executeQuery(BaseStatement.java:181)
at com.genesyslab.icc.contactserver.util.SchemaHistory.checkSchemaHistory(SchemaHistory.java:83)
at com.genesyslab.icc.util.DataAccessPointUtils.configureDataSource(DataAccessPointUtils.java:198)
at com.genesyslab.icc.contactserver.ContactServerEngine.initDataSources(ContactServerEngine.java:1093)
at com.genesyslab.icc.contactserver.ContactServerEngine.initInstance(ContactServerEngine.java:732)
at com.genesyslab.icc.contactserver.ContactServerEngine$4.run(ContactServerEngine.java:1615)
at java.lang.Thread.run(Thread.java:745)
13:39:54.997 Std 29997 [Ucs-Main] Abnormal server exit, code:-22
Thanks
