When query a virtual table, it gives an error "Group does not exist"

[neetacomp]

I have done the following steps

1) Created a souce model by importing data from the SQL Server

2) Created a VDB

3) Deployed VDB

4) Created a new view model

5) Create a virtual table on top of this view model (which joins data from 2 tables)

Now when I preview data on this virtual table, it gives the correct results.

But when I Execute VDB and query from 'SQL Scrapbook' or use JavaClient, it gives following message

"TEIID30020 Processing exception 'Group does not exist: SQlServerViewModel2.SampleTable2' for request uwVlHsnt3e+U.0.  Exception type org.teiid.api.exception.query.QueryResolverException"

I tried to query in different way like

SELECT * FROM "<ViewModel>"."<Virtual Table name>"

or

SELECT * FROM "<Virtual Table Name>"

It would be great if someone can help to resolve this issue.

Thanks in advance,

Neeta

[shawkins]

Do you see your view in the metadata tree?  And do you see your view if you do a "SELECT * FROM SYS.TABLES"?

If it's not present the vdb may not have been constructed the way you want.

[neetacomp]

Thanks Steve for the response.

I was able to see my view model and virtual table in Model Explorer tree ( I guess it is same as metadata tree)

I did not try "SELECT * FROM SYS.TABLES"

Now I dont see this problem any more.(I am not sure how it got resolved)

But in future if I see this problem and incase my VDB has not been constructed the way I want, then what is the solution for it?

Thanks,

Neeta

[shawkins]

> But in future if I see this problem and incase my VDB has not been constructed the way I want, then what is the solution for it?

I couldn't begin to guess really.  But if you have a situation where the vdb doesn't seem to match what is in your workspace, then use the Teiid Designer forum or create a Teiid Designer issue.  If possible you would post with your vdb or a zip export of the entire project.