Bug 780464 (SOA-2891) - Hibernate exception when querying ModeShape repositories with Oracle DB backend
Summary: Hibernate exception when querying ModeShape repositories with Oracle DB backend
Keywords:
Status: CLOSED WORKSFORME
Alias: SOA-2891
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0.ER9
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.2.0 GA
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-02-10 16:26 UTC by Jiri Locker
Modified: 2014-01-07 17:45 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Oracle10g and Oracle11gR2
Last Closed: 2011-11-15 17:03:17 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)
testModeShapePresence_Error.png (55.22 KB, image/png)
2011-02-10 16:29 UTC, Jiri Locker
no flags Details
server_logs.zip (1.75 MB, application/zip)
2011-02-10 16:29 UTC, Jiri Locker
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker MODE-1094 0 None Closed Hibernate exception when querying ModeShape repositories with Oracle DB backend 2014-01-07 17:45:25 UTC
Red Hat Issue Tracker SOA-2891 0 None Closed Hibernate exception when querying ModeShape repositories with Oracle DB backend 2012-03-20 16:39:56 UTC

Internal Links: 795385

Description Jiri Locker 2011-02-10 16:26:35 UTC
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.

Comment 1 Jiri Locker 2011-02-10 16:29:13 UTC
Attachment: Added: testModeShapePresence_Error.png
Attachment: Added: server_logs.zip


Comment 2 Van Halbert 2011-02-10 16:55:02 UTC
Link: Added: This issue Cloned to SOA-2892


Comment 3 Jiri Locker 2011-02-23 10:09:33 UTC
I suspect this issue might be related to poor performance of Oracle database instances in the QE lab.

Comment 4 Van Halbert 2011-06-01 19:25:22 UTC
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.

Comment 5 David Le Sage 2011-09-02 05:21:32 UTC
Release Notes Docs Status: Added: Not Required
Writer: Added: dlesage


Comment 6 JBoss JIRA Server 2014-01-07 17:45:26 UTC
Randall Hauch <rhauch> updated the status of jira MODE-1094 to Closed


Note You need to log in before you can comment on or make changes to this bug.