[
https://issues.jboss.org/browse/TEIID-2875?page=com.atlassian.jira.plugin...
]
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)