org.teiid.metadata.DuplicateRecordException: TEIID60013 Duplicate Table

[rakeshsagar]

Hi,

I am using Teiid 8.1 and I am dynamically adding the tables in getMetadata() of my translator.

But I keep getting this error

org.teiid.metadata.DuplicateRecordException: TEIID60013 Duplicate Table test.table1

There are no duplicate tables added to the teiid metadata.

I am using a dynamic VDB.

Please let me know how to fix this issue.

Thanks

Rakesh

[rareddy]

Rakesh,

You would have to post your code and VDB for us to suggest any solutions. I know hat Teiid does not allow same named tables or procedures in a given schema (model).

Ramesh..

[rakeshsagar]

Yes, there are no duplicate tables in my model.

We use a text file and read the contents of that text file and create tables and columns from that.

Our code is large and have lots of dependencies so I can't post the code.

[rareddy]

Rakesh,

Unfortunately there is not much help we can provide then. My suggestion is run though the debugger and trace it. If you do see an issue submit with a smaller testcase that we can test and provide a fix.

Thanks

Ramesh..

[shawkins]

Rakesh,

You can see the code performing that check is straight-forward - just an update of a case-insensitive map.  If there is an existing entry an exception is thrown.  If you can, debug by placing a breakpoint on that exception.  Alternatively perhaps your code is caching a Schema/MetadataFactory and not accounting for this later.

Steve

[rakeshsagar]

Thanks Steve and Ramesh.

I will debug and find the problem.

A quick question:

What is the equivalent of metadataFactory.getMetadataStore().getSchemas() in JBoss 8.1 ?

I tried using metadataFactory.asMetadataStore().getSchemas() and I think this is the cause of the exception I am getting.

Thanks,

Rakesh

[rakeshsagar]

Hi Steve/Ramesh,

I had debugged and found out that the error is due to duplicate columns in the table.

I think we need to update the message to display that there are duplicate columns instead of the table.

Thanks

Rakesh

[rareddy]

Can you log an enhancement request possibly with small test case?

Thanks

[shawkins]

Logged and worked as https://issues.jboss.org/browse/TEIID-2183