Bug 583006
| Summary: | Database: Exceptions got on JON with Oracle 10g/11g | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | [Other] RHQ Project | Reporter: | Rajan Timaniya <rtimaniy> | ||||||||
| Component: | Database | Assignee: | Jay Shaughnessy <jshaughn> | ||||||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Corey Welton <cwelton> | ||||||||
| Severity: | medium | Docs Contact: | |||||||||
| Priority: | low | ||||||||||
| Version: | 3.0.0 | ||||||||||
| Target Milestone: | --- | ||||||||||
| Target Release: | --- | ||||||||||
| Hardware: | All | ||||||||||
| OS: | Linux | ||||||||||
| Whiteboard: | |||||||||||
| Fixed In Version: | 2.4 | Doc Type: | Bug Fix | ||||||||
| Doc Text: | Story Points: | --- | |||||||||
| Clone Of: | Environment: | ||||||||||
| Last Closed: | 2010-08-12 16:58:34 UTC | Type: | --- | ||||||||
| Regression: | --- | Mount Type: | --- | ||||||||
| Documentation: | --- | CRM: | |||||||||
| Verified Versions: | Category: | --- | |||||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||||
| Embargoed: | |||||||||||
| Bug Depends On: | |||||||||||
| Bug Blocks: | 577907 | ||||||||||
| Attachments: |
|
||||||||||
|
Description
Rajan Timaniya
2010-04-16 12:19:03 UTC
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. |