Created attachment 492120 [details] serverlogfile Description of problem: ORA-01002 errors with Oracle database Version-Release number of selected component (if applicable): How reproducible: 100% Steps to Reproduce: 1. Install RHQ with Oracle 11 database, doing all Oracle configuration stuff 2. log in, dashboard, inventory, view some resources 3. Actual results: Caused by: java.sql.SQLException: ORA-01002: fetch out of sequence at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1084) at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:359) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:263) at org.jboss.resource.adapter.jdbc.WrappedResultSet.next(WrappedResultSet.java:1196) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2213) ... 164 more Expected results: absence of oracle errors in the server log file Additional info:
Mike, can you track this down to one particular request in the UI?
I retested this Oracle 10G Express with RHQ CR1 ... and have not seen the ORA-01002 issues ...which were quite prevalent before. This was a new installation of Oracle, and perhaps I followed the post-installation steps more closely which resulted in the correct behavior and the issue not manifesting.