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

    • Bug
    • Resolution: Obsolete
    • Optional
    • None
    • 10.0.1
    • Dialogs
    • None
      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?

      Attachments

        Activity

          People

            blafond Barry LaFond
            skaleta@redhat.com Stanislav Kaleta (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: