Bug 780464 (SOA-2891)
| Summary: | Hibernate exception when querying ModeShape repositories with Oracle DB backend | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise SOA Platform 5 | Reporter: | Jiri Locker <jlocker> | ||||||
| Component: | EDS | Assignee: | Van Halbert <vhalbert> | ||||||
| Status: | CLOSED WORKSFORME | QA Contact: | |||||||
| Severity: | high | Docs Contact: | |||||||
| Priority: | high | ||||||||
| Version: | 5.1.0.ER9 | CC: | jlocker | ||||||
| Target Milestone: | --- | ||||||||
| Target Release: | 5.2.0 GA | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| URL: | http://jira.jboss.org/jira/browse/SOA-2891 | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: |
Oracle10g and Oracle11gR2
|
|||||||
| Last Closed: | 2011-11-15 17:03:17 UTC | Type: | Bug | ||||||
| Regression: | --- | Mount Type: | --- | ||||||
| Documentation: | --- | CRM: | |||||||
| Verified Versions: | Category: | --- | |||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||
| Embargoed: | |||||||||
| Attachments: |
|
||||||||
Attachment: Added: testModeShapePresence_Error.png Attachment: Added: server_logs.zip Link: Added: This issue Cloned to SOA-2892 I suspect this issue might be related to poor performance of Oracle database instances in the QE lab. The modeshape jira was closed because the problem is not reproducible and that it possibly was fixed when another Oracle related jira was fixed. This needs to be re-verified. Release Notes Docs Status: Added: Not Required Writer: Added: dlesage |
project_key: SOA In admin console, Repositories folder under ModeShape node is missing. {noformat} WARN [org.rhq.core.pc.inventory.InventoryManager] Failure during discovery for [Repositories] Resources - failed after 27887 ms. java.lang.Exception: Discovery component invocation failed. ... Caused by: java.lang.reflect.UndeclaredThrowableException: Failed to invoke method 'getRepositoryVersion' on component 'ModeShapeEngine' with parameters [SimpleMetaType:java.lang.String:eds]. ... Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not load an entity: [org.modeshape.connector.store.jpa.util.StoreOptionEntity#org.modeshape.store.rootNodeUuid] ... Caused by: org.hibernate.exception.SQLGrammarException: could not load an entity: [org.modeshape.connector.store.jpa.util.StoreOptionEntity#org.modeshape.store.rootNodeUuid] ... Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist {noformat} Compare attached server_fail.log and server_success.log and lookup first occurrence of {{/* load org.modeshape.connector.store.jpa.util.StoreOptionEntity */}} to see the point where the problem arises. Also take into account that the database account is re-used and the clean up is automated.