Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-952

View model transformation with procedure as only source fails validation with The sql transformation does not have a valid source

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.4
    • Fix Version/s: 7.4
    • Component/s: Modeling
    • Labels:
      None
    • Environment:

      Fedora 14, OpenJDK Runtime Environment (IcedTea6 1.9.7) (fedora-52.1.9.7.fc14-x86_64)

      Description

      I was following the Recursive Text E2E test. This calls for creating a relational source model with a procedure (getTextFiles) for use in a view model's transformation. With all this modeled, the transformation fails with the error: The sql transformation does not have a valid source.

      The actual transformation SQL text is:
      SELECT * FROM (EXEC text.getTextFiles('EmpData.txt')) AS f, TEXTTABLE(f.file COLUMNS lastName string, firstName string, middleName string, empId biginteger, department string, annualSalary double, title string, homePhone string, mgrId biginteger, street string, city string, state string, ZipCode string HEADER 3) AS emp

      In previous versions this passed validation. Model project set is attached.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  blafond Barry LaFond
                  Reporter:
                  pnittel Paul Nittel
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: