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

Create Web Service On procedure generates invalid sql

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Minor
    • 8.1
    • 7.4.2
    • Web Services Support
    • None

    Description

      1. I select on a procedure, Rsw_CustomerUnitProc, whose result is Rsw_CustomerUnitResult.
      2. Choose Modeling > Create Web Service
      3. Enter in the appropriate info in the web service, including Rsw_CustomerUnit_Output for the Output Schema Model.

      The generated code for the output Model Transformation Editor is:

      SELECT
      		*
      	FROM
      		Procedures.Rsw_CustomerUnitProc.Rsw_CustomerUnitResult
      

      And there is an error:
      ERROR: Group does not exist: Procedures.Rsw_CustomerUnitProc.Rsw_CustomerUnitResult

      Removing the Result seems to fix the problem:

      SELECT
      		*
      	FROM
      		Procedures.Rsw_CustomerUnitProc
      

      Attachments

        Activity

          People

            blafond Barry LaFond
            michaeljconner Michael Conner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: