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

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

      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.

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

                Created:
                Updated:
                Resolved: