Teiid failed to deploy due to DuplicateRecordExcept

[ichanjasper]

We have a customer try to create virtual data source that is made of three mySQL databases. On occasion, it works, but more often than not, it does NOT work.  The error says "Duplicate tables" but there do not seem to be any duplicate tables in their schemas.  We are not able to get their DDL's or anything, but customer confirmed there is only one action_history table on his side.  However, Teiid reported action_history is duplicated.   Do you guys have any clue about this issue?  What is the best way to debug this?   Unfortunately, according to customer security policies he cannot provide information about tables, etc on his DB.  What if we change the setting to import.userFullSchemaName to true, would it help?  Can it be column name get trimmed?

Teiid version:  9.1.1

Import properties:

import.userFullSchemaName, false

import.trimColumnNames, true

Exception:

Teiid:  failed to deploy VDB.

org.teiid.metadata.DuplicateRecordException: TEIID60013 Duplicate Table files

    at org.teiid.metadata.Schema.addTable(Schema.java:49)

    at org.teiid.metadata.MetadataFactory.addTable(MetadataFactory.java:231)

    at org.teiid.translator.jdbc.JDBCMetdataProcessor.addTable(JDBCMetdataProcessor.java:366)

    at org.teiid.translator.jdbc.JDBCMetdataProcessor.addTable(JDBCMetdataProcessor.java:349)

    at org.teiid.translator.jdbc.JDBCMetdataProcessor.getTables(JDBCMetdataProcessor.java:322)

    at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:173)

    at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:306)

    at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:69)

    at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96)

    at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)

    at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)

    at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:811)

    at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:210)

    at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:761)

    at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:673)

[shawkins]

> Do you guys have any clue about this issue?

The exception indicates a files table, is this also happening with an action_history table?

> What is the best way to debug this?

As you are indicating, look for all instance of table with the given name in the database and/or use a schema pattern to import from only a single schema.

> What if we change the setting to import.userFullSchemaName to true, would it help?

Yes, if the duplication is due to the same table being in multiple source schema this setting would schema qualify the Teiid name to ensure uniqueness.

> Can it be column name get trimmed?

Since the exception is on a table name, that should have no effect.

[ichanjasper]

Is there a way to ignore duplicate table?

[shawkins]

On newer versions there are import properties that rename duplicates, but that isn't available in 9.1.1.  The default assumption is that the user needs to be aware of the naming conflict up front.

[ichanjasper]

Which version of Teiid supports this rename duplicates feature?

[shawkins]

10.0 - [TEIID-5106] Tables names are case sensitive in Postgres/Oracle/MSSQL but not in Teiid. - JBoss Issue Tracker