8 Replies Latest reply on May 17, 2017 1:40 PM by Steven Hawkins

    Teiid throw exception for column having dot in their name for sql server database.

    Kulbhushan Chaskar Expert

      Hi,

       

      I am trying to insert data in SQL Server through teiid but it throw exception for column having dot in their name as dot are allowed in column names of SQL Server.

       

      Exception is:

      org.teiid.jdbc.TeiidSQLException: TEIID30126 Remote org.teiid.api.exception.query.QueryResolverException: TEIID30126 Column variables do not reference columns on group "SqlConnection1.DQ_2012.dbo.cust1": [Unable to resolve 'SqlConnection1.DQ_2012.DBO.CUST1.id.id': TEIID31119 Symbol SqlConnection1.DQ_2012.DBO.CUST1.id.id is specified with an unknown group context]

       

      here, Connection name : SqlConnection1,

                Database name    : DQ_2012,

                Table name           :  DBO.CUST1,

                Column name       :  id.id

       

      Teiid version:9.13

      Teiid admin version:9.13