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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2875:
---------------------------------------

Camilo you are seeing a related, but different issue.  The import logic does not take into account Oracle nested tables, which appear to have an incomplete metadata representation in the JDBC DatabaseMetaData.  

As for the import properties, where were they set in the vdb?  They should be children of the importing model.  If you are sufficiently limiting your import, it should be successful.  Also you more than likely want to leave importApproximateIndexes at the default of true.

> 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)