Hi All,

I have a procedure on SQL database

We have created a source model in teiid using that procedure

We have created a view model in teiid using that source model where source model is a procedure outcome and view model is a table

To create the view model, we are not using "transform from existing model", rather we are creating the view model (basically a table) on our own and adding a primary key for it to support odata

The translation query from source model to view model,

SELECT * FROM (EXEC sourcemodel.databasename.schemaname.sourceprocedurename(col1 => viewmodel.databasename.schemaname.viewtablename.col1, col2=> viewmodel.databasename.schemaname.viewtablename.col2)) AS x;

we get an error that "Symbol viewmodel.viewtablename.col1 is specified with an unknown group context"

Any help would be much appreciated.