No errors or results are displayed when running a MetaMatrix Query against a WebService
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.