Issue

• There is a view in Microsoft SQL Server database. It can query directly from the database with no problem. Querying thru DV gives below:

org.teiid.translator.jdbc.JDBCExecutionException: 208 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT TOP 100 COUNT(*) AS c_0 FROM "db"."dbo"."viewname" g_0]
    at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
    at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:330) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
    at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
    at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
    at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_72]
    at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
    ... 6 more
Caused by: java.sql.SQLException: Invalid object name 'db.dbo.viewname'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)
    at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
    at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
    ... 12 more