[
https://issues.jboss.org/browse/TEIID-2875?page=com.atlassian.jira.plugin...
]
Camilo Ortiz commented on TEIID-2875:
-------------------------------------
Hi,
I believe I'm having a similar problem. Deploying a VDB that has only one Oracle DB as
a datasource I obtain the following output after the VDB tries to load:
12:28:36,961 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB
testOracle.1 model "BKPTest" metadata failed to load. Reason:TEIID60011 No
column found with name NESTED_TABLE_ID: org.teiid.metadata.MetadataException: TEIID60011
No column found with name NESTED_TABLE_ID
at org.teiid.metadata.MetadataFactory.assignColumn(MetadataFactory.java:353)
[teiid-api-8.9.0.Final.jar:8.9.0.Final]
at org.teiid.metadata.MetadataFactory.assignColumns(MetadataFactory.java:461)
[teiid-api-8.9.0.Final.jar:8.9.0.Final]
at org.teiid.metadata.MetadataFactory.addPrimaryKey(MetadataFactory.java:261)
[teiid-api-8.9.0.Final.jar:8.9.0.Final]
at
org.teiid.translator.jdbc.JDBCMetdataProcessor.getPrimaryKeys(JDBCMetdataProcessor.java:463)
at
org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:147)
at
org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:309)
at
org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:57)
at
org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:83)
[teiid-engine-8.9.0.Final.jar:8.9.0.Final]
at
org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:60)
[teiid-engine-8.9.0.Final.jar:8.9.0.Final]
at
org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
[teiid-engine-8.9.0.Final.jar:8.9.0.Final]
at org.teiid.jboss.VDBService$6.run(VDBService.java:396)
[teiid-jboss-integration-8.9.0.Final.jar:8.9.0.Final]
at org.teiid.jboss.VDBService$7.run(VDBService.java:444)
[teiid-jboss-integration-8.9.0.Final.jar:8.9.0.Final]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
[rt.jar:1.7.0_10]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
[rt.jar:1.7.0_10]
at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_10]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
I obtain the same error even trying some suggestions obtained at irc #teiid by setting
several combinations of the following properties in the -vbd.xml file:
<property name="importer.tableTypes" value="TABLE"/>
<property name="importer.schemaPattern" value="my-schema"/>
<property name="importer.importApproximateIndexes"
value="false"/>
Moreover, setting
<property name="importer.tableNamePattern" value="my-table"/>
with a table that definitely has no hidden columns gives the same error as above. Do you
have any suggestions?
Thanks!
Metadata failed to load. No column found
----------------------------------------
Key: TEIID-2875
URL:
https://issues.jboss.org/browse/TEIID-2875
Project: Teiid
Issue Type: Bug
Affects Versions: 8.6
Environment: Windows server 2003, Windows 7.
Reporter: SHI HONG CHIN
Assignee: Steven Hawkins
Attachments: JakkerData-vdb.xml
Affected database: Oracle
The following error displayed when Teiid loading a dynamic VDB:
10:21:41,458 WARN [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50036 VDB
JakkerData.1 model "IWMS" metadata failed to load. Reason:TEIID60011 No column
found with name "RATE"."CHARGE_NAME"
10:23:29,994 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB
JakkerData.1 model "IWMS" metadata failed to load. Reason:TEIID60011 No column
found with name "RATE"."CHARGE_NAME"
I am not the one who design the database. But, I cannot find any table with above
mentioned column name in Oracle database. So, I am not sure whether the above mentioned
column name is a hidden column or not.
This bug does not exist in version 8.5.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)