No errors or results are displayed when running a MetaMatrix Query against a WebService

Solution Verified - Updated -

Issue

  • I'm running the below query and I get an empty result set.  I have the "Log XML Request/Response Documents" enabled and still I do not see the XML Request in the logs.
  • Actually few of the parameters are optional when I checked in SOAP UI  but I was getting error in Designer when I didn't have them in where  clause, that's why I had it as empty. Having empty parameter values in  the query is same as not having them in the query.

    select c.ResponseIn,b.mmid,c.mmid from "MCMMX"."MCServiceModel.metacenterservice.GetMetadata.GetMetadataInput" a,"MCMMX"."MCServiceModel.metacenterservice.GetMetadata.GetMetadataOutput" b,"MCMMX"."MCServiceModel.metacenterservice.GetMetadata.obj" c where a.username='administrator' and a.password='metacenter' and a.metacenterInstanceId="1" and a.objectSelectorType="objects" and a.isLoadAttributes="true" and a.isLoadRelObjMetadata="false" and a.isLoadRels="false" and a.isLoadSqlAttributeResult="false" and  a.objCriteria_objIdChoice_physicalObjId="10000005" and a.responseOut=b.responseIn and a.responseOut=c.ResponseIn OPTION DEBUG
    

Environment

  • MetaMatrix Enterprise Server 5.5.x
  • MetaMatrix Enterprise Designer 5.5.x
  • MetaMatrix XML Relational SOAP Connector

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content