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

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Optional 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

      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?

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

                Created:
                Updated:
                Resolved: