Dynamic VDB deployment fails when using importer.importIndexes in the case of a index containing a hidden column

[yjma2001]

HI community:

We are trying to use dynamic VDB. For better performance, we use <property name="importer.importIndexes" value="true"/> to input the index for an oracle datasource.

But vdb deployment failed with following error:

     [TEIID60011 No column found with name SYS_NC00032$]

Debugging through teiid code, it looks like that if the index contains the hidden column (like SYS_NC00032), then index loading failed, teiid was trying to call getColumnByName() for those hidden column which does not exist in the column map.

Is this a bug at teiid? Teiid verison we are using is 8.2 Final.

Thanks

Jack

[shawkins]

> Is this a bug at teiid?

Probably.  Is the index function based and/or what is the purpose of the hidden column?  We should more than likely just not import indexes like this and log why.

Steve

[yjma2001]

Hi Steve:

Thanks for your quick response. We are not falimar with that database design. We just try to consume that database and to import the indexes for Cardinality information to improve the vdb performance. I agreed with you that teiid should not input those indexes to the hidden columns and log the resaon. I will open a teiid issue.

Thanks

Jack

[yjma2001]

https://issues.jboss.org/browse/TEIID-2368 opened and linked to this thread.