[teiid-issues] [JBoss JIRA] (TEIID-2875) Metadata failed to load. No column found

[ 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! -- This message was sent by Atlassian JIRA (v6.3.11#6341)