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

Relational results returned from deployed Web service contain no data - Missing namespace

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: 7.7.1
    • Fix Version/s: 7.7.1, 7.8
    • Component/s: Modeling
    • Labels:
      None

      Description

      I've got a deployed WAR which queries just fine through soapUI.
      I've modeled it in Designer and am trying to preview the data. All I get
      is column headings. After deploying the VDB, I get the same results from SQuirreL when I query:

      SELECT * FROM (EXEC getSuppInfo(SUPPLIER_ID='S105', PART_ID='P305')) c

      The soapUI request and response are below.

      This request:

       
      <soapenv:Envelope
      xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
      xmlns:sup="http://www.metamatrix.com/SuppInfo_Input">
         <soapenv:Header/>
         <soapenv:Body>
            <sup:SuppInfo_Input>
               <!--Optional:-->
               <SUPPLIER_ID>S104</SUPPLIER_ID>
               <!--Optional:-->
               <PART_ID>P305</PART_ID>
            </sup:SuppInfo_Input>
         </soapenv:Body>
      </soapenv:Envelope>
      
      Should respond with:
      <soap:Envelope
      xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
         <soap:Body>
            <SuppInfo_Output:SuppInfo_Output
            xmlns:Q1="http://www.metamatrix.com/metamodels/SimpleDatatypes-instance"
            xmlnss="http://www.w3.org/2001/XMLSchema"
            xmlnssi="http://www.w3.org/2001/XMLSchema-instance"
            xmlns:SuppInfo_Output="http://www.metamatrix.com/SuppInfo_Output">
               <SuppInfo_Output_Instance>
                  <SUPPLIER_ID>S104</SUPPLIER_ID>
                  <SUPPLIER_NAME>Adams</SUPPLIER_NAME>
                  <SUPPLIER_STATUS>10</SUPPLIER_STATUS>
                  <SUPPLIER_CITY>Atlanta</SUPPLIER_CITY>
                  <SUPPLIER_STATE>GA</SUPPLIER_STATE>
                  <PART_ID>P305</PART_ID>
                  <QUANTITY>100</QUANTITY>
                  <SHIPPER_ID>20</SHIPPER_ID>
               </SuppInfo_Output_Instance>
            </SuppInfo_Output:SuppInfo_Output>
         </soap:Body>
      </soap:Envelope>
      

      Ted Jones sees a problem with namespace declarations.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  tejones Ted Jones
                  Reporter:
                  pnittel Paul Nittel
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: