5 Replies Latest reply on Aug 2, 2018 1:56 PM by Steven Hawkins

    Teiid failed to deploy due to DuplicateRecordExcept

    Ivan Chan Apprentice

      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)