Bug 781065 (SOA-3551)
Summary: | Cannot load metadata for dynamic VDB on oracle10g | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product: | [JBoss] JBoss Enterprise SOA Platform 5 | Reporter: | Filip Nguyen <fnguyen> | ||||||||
Component: | EDS | Assignee: | Van Halbert <vhalbert> | ||||||||
Status: | CLOSED NOTABUG | QA Contact: | |||||||||
Severity: | high | Docs Contact: | |||||||||
Priority: | high | ||||||||||
Version: | 5.2.0.ER6 | CC: | fnguyen | ||||||||
Target Milestone: | --- | ||||||||||
Target Release: | --- | ||||||||||
Hardware: | Unspecified | ||||||||||
OS: | Unspecified | ||||||||||
URL: | http://jira.jboss.org/jira/browse/SOA-3551 | ||||||||||
Whiteboard: | |||||||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||||||
Doc Text: | Story Points: | --- | |||||||||
Clone Of: | Environment: | ||||||||||
Last Closed: | 2011-11-15 17:48:34 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: |
|
Description
Filip Nguyen
2011-11-03 10:55:43 UTC
Attachment: Added: server.log Attachment: Added: mytext-ds.xml Attachment: Added: myvdb-vdb.xml After attaching debugger there seems to be some duplicate table in database that the Teiid is trying to insert into metadata (don't know what this means yet). {code:title=DEBUG server console | borderStyle=solid} org.teiid.metadata.DuplicateRecordException: Duplicate table SOAESB1.BIN$mbjj432fhyLgQCIK4iBmlQ==$0 12:44:31,528 ERROR [STDERR] at org.teiid.metadata.Schema.addTable(Schema.java:46) 12:44:31,528 ERROR [STDERR] at org.teiid.metadata.MetadataFactory.addTable(MetadataFactory.java:83) 12:44:31,528 ERROR [STDERR] at org.teiid.translator.jdbc.JDBCMetdataProcessor.getTables(JDBCMetdataProcessor.java:212) 12:44:31,528 ERROR [STDERR] at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:114) 12:44:31,528 ERROR [STDERR] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:277) 12:44:31,528 ERROR [STDERR] at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:82) 12:44:31,528 ERROR [STDERR] at org.teiid.dqp.internal.datamgr.ConnectorManager.getMetadata(ConnectorManager.java:128) 12:44:31,528 ERROR [STDERR] at org.teiid.deployers.VDBDeployer.loadMetadata(VDBDeployer.java:344) 12:44:31,528 ERROR [STDERR] at org.teiid.deployers.VDBDeployer.access$000(VDBDeployer.java:60) 12:44:31,528 ERROR [STDERR] at org.teiid.deployers.VDBDeployer$1.run(VDBDeployer.java:310) 12:44:31,528 ERROR [STDERR] at org.jboss.util.threadpool.RunnableTaskWrapper.run(RunnableTaskWrapper.java:147) 12:44:31,528 ERROR [STDERR] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) 12:44:31,528 ERROR [STDERR] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) 12:44:31,529 ERROR [STDERR] at java.lang.Thread.run(Thread.java:662) {code} Link: Added: This issue Cloned to SOA-3552 Its loading the metadata for a recycle bin table: SOAESB1.BIN$mbjj432fhyLgQCIK4iBmlQ==$0. This table must be reported twice in the metadata, which is odd, but not entirely out of the realm of possibility since you are not limiting what metadata the importer should fetch. See reference (http://docs.jboss.org/teiid/7.5.0.Final/reference/en-US/html_single/#d0e9188) that states how you can set schema/table name patterns, etc. to appropriately limit the metadata. |