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

SQL generated from remote XML file template has wrong number of parameters

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Optional
    • Resolution: Out of Date
    • Affects Version/s: 10.0.1
    • Fix Version/s: None
    • Component/s: Dialogs
    • Labels:
      None
    • Steps to Reproduce:
      1. right-click View Model -> New Child -> Table -> SQL Transformation tab -> click Select SQL template button
      2. select XML File - URL Source and click OK, OK

      Description

      Creating table with XML File - URL Source template generates table with transformation SQL which contains error:
      ERROR: org.teiid.runtime.client.TeiidClientException: TEIID30140 Incorrect number of parameters specified on the stored procedure 3 - expected between 4 and 5 but got 3

      part of SQL which contains error: (EXEC SourceModel.invokeHttp('GET', null, 'http://www.w3schools.com/xml/plant_catalog.xml')) AS f

      Note: using Import Model Wizard, part of SQL is as follows: (EXEC SourceModel.invokeHttp('GET', null, 'http://www.w3schools.com/xml/plant_catalog.xml', 'TRUE')) AS f

      In my opinion, template is missing stream parameter from invokeHttp procedure,... or is there any reason why it is not there?

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                skaleta Stanislav Kaleta
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: