Created attachment 407085 [details] log file with exception Description of problem: Following exceptions I got in rhq-server-log4j.log durring the test automation run on JON build #94 with Oracle 10g/11g. 2010-04-14 17:49:48,761 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 933, SQLState: 42000 2010-04-14 17:49:48,761 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00933: SQL command not properly ended 2010-04-14 17:49:48,807 ERROR [org.rhq.enterprise.gui.common.paging.PagedListDataModel] Could not retrieve collection for PageControlView[BrowseResourcesUIBean] javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query 2010-04-14 17:50:09,112 ERROR [org.rhq.enterprise.gui.common.paging.PagedListDataModel] Could not retrieve collection for PageControlView[BrowseGroupsUIBean] javax.ejb.EJBException: java.lang.NullPointerException Version-Release number of selected component (if applicable): JON build #94 - Revision: 10609 http://hudson-qe.rhq.rdu.redhat.com:8080/job/jon/94/ How reproducible: Always Actual results: Got exceptions like SQL Error: 933, SQLState: 42000','ORA-00933: SQL command not properly ended', 'Could not retrieve collection for PageControlView' Expected results: Additional info: Please refer attached log file.
Created attachment 407086 [details] log file
What are the reproductions steps to generate these errors, we need more granularity than just "automated tests" The XA errors also appear that Oracle is not setup correctly. Please take a look at the JON Oracle docs for the required setup steps.
Configured JON user requirements for XA, now there is no XA errors. Steps to generate errors: 1)Log in to JON Server with appropriate credentials 2)Click on 'Resources' -> 'All Resources' Monitored the following errors in server log. 2010-04-20 14:28:09,783 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 933, SQLState: 42000 2010-04-20 14:28:09,783 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00933: SQL command not properly ended 2010-04-20 14:28:09,801 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 933, SQLState: 42000 2010-04-20 14:28:09,802 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00933: SQL command not properly ended 2010-04-20 14:28:09,802 ERROR [org.rhq.enterprise.gui.common.paging.PagedListDataModel] Could not retrieve collection for PageControlView[BrowseResourcesUIBean] javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:63) .... Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query Caused by: org.hibernate.exception.SQLGrammarException: could not execute query Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended
Created attachment 407778 [details] screenshot 'Browse Resources' screen doesn't show any resources.
I haven't been able to reproduce this locally. Can you please verify that this is still an issue, and if so, provide me a link to a failing environment. Thanks, Jay
Verified on JON build #112 -Revision: 10615 Steps 1)Log in to JON Server with appropriate credentials 2)Click on 'Resources' -> 'All Resources' 3)Search on 'Browser Resources' screen 'Browse Resources' screen shows all resources without any exception/error (Tested on Oracle 10g and 11g).
Mass-closure of verified bugs against JON.