[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=13039591#comment-13039591 ] 

Camilo Ortiz commented on TEIID-2875:
-------------------------------------

Steven, thanks again for your accurate help. Fortunately, following the schemaName.tableName syntax, I was able to exclude the tables that were generating that error using the importer.excludeTables property. However, it seems that this legacy Oracle DB has another problem when loading the tables, showing warning messages as the following:

TEIID31152 More the one constraint with the name my-model.my-schema.MY-FOREIGN_KEY_CONSTRAINT_NAME

I was able to solve this by setting 

<property name="importer.importKeys" value="false"/>

Taking into account that this VDB is going to be used mostly for reading (select querying), how do you think the performance of the VDB is affected by setting the above property? Also, is there a way to exclude the individual constraints that are causing the error ?

Thank you.

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