2 Replies Latest reply on Jan 25, 2018 11:20 AM by Shiloh Jordan

    Reason:TEIID60013 Duplicate Table check_constraints: org.teiid.metadata.DuplicateRecordException:

    Shiloh Jordan Novice

      Hi all,

      I am running through the quick start exercises here: Hello World Teiid Data Federation Example - Teiid Examples - Project Documentation Editor

       

      I have configured the connections to the data sources in standalone-teiid.xml, created the vdb.xml, started the wildfly server, but I am getting error when deploying the vdb.

       

      In the example, they are using a h2 database connection, however, in my case, I am using sql server. 

       

      I am getting following error: Reason:TEIID60013 Duplicate Table check_constraints: org.teiid.metadata.DuplicateRecordException:

      Here is my vdb.xm

       

      <vdb name="Portfolio" version="1">

       

          <description>The Portfolio VDB</description>

       

          <model name="marketdata" type="PHYSICAL">

              <source name="text-connector" translator-name="file" connection-jndi-name="java:/marketdata-file"/>

          </model>

       

          <model name="accounts" type="PHYSICAL">

              <property name="importer.useFullSchemaName" value="false"/>

          <property name="importer.tableTypes" value="TABLE,VIEW"/>

              <source name="sql-connector" translator-name="sqlserver" connection-jndi-name="java:/accounts-ds"/>

          </model>

       

          <model name="Portfolio" type="VIRTUAL">

              <metadata type="DDL"><![CDATA[

              CREATE VIEW StockPrice (

                  symbol string,

                  price bigdecimal

              ) AS 

                SELECT SP.symbol, SP.price

                  FROM (EXEC MarketData.getTextFiles('*.txt')) AS f,

                  TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) AS SP;

               

              CREATE VIEW AccountValues (

                  LastName string PRIMARY KEY,

                  FirstName string,

                  StockValue bigdecimal

              ) AS

                SELECT c.lastname as LastName, c.firstname as FirstName, sum((h.shares_count*sp.price)) as StockValue

              FROM Customer c JOIN Account a on c.SSN=a.SSN

              JOIN Holdings h on a.account_id = h.account_id

              JOIN product p on h.product_id=p.id

              JOIN StockPrice sp on sp.symbol = p.symbol

              WHERE a.type='Active'

              GROUP BY c.lastname, c.firstname;                

              ]]> </metadata>

          </model>

      </vdb>

       

      All help is appreciated

       

      Thanks,
      Shiloh