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

Dynamic VDB Generation - Problem with DDL generated for procedure

    Details

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

      Description

      I have a VDB that was created for consumption of REST Web Service.
      There is a procedure named getProgrammes(). DDL generated for dynamic VDB is:

      CREATE VIRTUAL PROCEDURE getProgrammes ()
      AS
      CREATE VIRTUAL PROCEDURE
      BEGIN
      DECLARE STRING VARIABLES.qp = '';
      SELECT
      A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title
      FROM
      (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A;
      END;

      Obviously, there is one extra "CREATE VIRTUAL PROCEDURE".
      Even after fixing this issue there is another error:

      VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel

      "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  blafond Barry LaFond
                  Reporter:
                  mmakovy Matus Makovy
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: