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

[Camilo Ortiz (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13038150#comment-13038150 ] 

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)