3 Replies Latest reply on May 22, 2013 6:55 AM by Steven Hawkins

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

    Neeta L Newbie

      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