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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • 7.7.1, 7.8
    • 7.7.1
    • Modeling
    • None

      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.

        1. ConsumerForTed_MPS.zip
          12 kB
        2. Designer.log
          55 kB

              rhn-engineering-tejones Edwin Jones
              pnittel_jira Paul Nittel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: