Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1129

Unable to execute SQL Queries through VDB's with more than one model in it from Designer/DTP

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.0
    • 7.0
    • None
    • None

    Description

      Created VDB in Designer with 1 Source model in it (Partssupplier) and was able to submit basic "Select * from PARTS" and return results in DTP through Teiid "as JDBC source".

      Then
      1) Undeployed VDB,
      2) Created second Source model (Products)
      3) Added Products source model to VDB
      4) Made sure JNDI data sources were on Teiid server for both models
      5) Deployed VDB containing both models
      6) Able to query PARTS again
      7) Unable to query "Select * from PRODUCTDATA" table.

      Error was:

      14:25:38,705 WARN [PROCESSOR] Processing exception 'Group does not exist: PRODUCTDATA' for request uOko4PiAWqhG.0. Exception type org.teiid.api.exception.query.QueryResolverException thrown from org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:853). Enable more detailed logging to see the entire stacktrace.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            blafond Barry LaFond
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: