SAP MII OData Service isnt working

[former_member586816]

Hello everyone,

i followed the detailed documentation for consuming an sql fixed query via SAP MII OData on https://help.sap.com/saphelp_mii150sp04/helpdata/EN/88/b1ff517bd47b38e10000000a445394/frameset.htm

System version: SAP MII 15.1 SP5 Patch 5 (4.10.2017)

I am failing to receive any data. I have created the sql fixed query "Default/SB/sql_getNodesByCategory" and trying to receive its first item via: http://192.168.10.160:50000/XMII/IlluminatorOData/Rowset(QueryTemplate='Default/SB/sql_getNodesByCategory',RowsetId=1)/Row

This is the error:

<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xml:base="http://192.168.10.160:50000/XMII/IlluminatorOData/">
  <title type="text">Rowsets</title>
  <id>http://192.168.10.160:50000/XMII/IlluminatorOData/Rowset(QueryTemplate='Default/SB/sql_getNodesByCategory',RowsetId=1)/Row</id>
  <updated>2018-07-24T14:26:22Z</updated>
  <link rel="self" title="Rowsets" href="Rowsets"/>
  <entry>
    <id>http://192.168.10.160:50000/XMII/IlluminatorOData/Rowsets('Rowset')</id>
    <title type="text"/>
    <updated>2018-07-24T14:26:22Z</updated>
    <author>
      <name/>
    </author>
    <link rel="edit" title="Rowsets" href="Rowsets('Rowset')"/>
    <category term="QueryTemplate.Rowsets" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"/>
    <content type="application/xml">
      <m:properties>
        <d:FatalError>HTTP request type is not supported with the specified Query Mode; no modes are supported</d:FatalError>
        <d:DateCreated m:type="Edm.DateTime">2018-07-24T16:26:22.736</d:DateCreated>
        <d:EndDate m:type="Edm.DateTime">2018-07-24T16:26:22.736</d:EndDate>
        <d:StartDate m:type="Edm.DateTime">2018-07-24T16:26:22.736</d:StartDate>
        <d:Version>15.1 SP5 Patch 5 (04.10.2017)</d:Version>
      </m:properties>
    </content>
  </entry>
</feed>

The transaction is delivering two results.

24-07-2018-16-33-56.png

Also when i trying to receive the meta data for this transaction via http://192.168.10.160:50000/XMII/IlluminatorOData/$metadata?QueryTemplate=Default/SB/sql_getNodesByC... its only displaying the default values.

[UPDATE] I refreshed after several minutes again and the meta data are now displayed on: http://192.168.10.160:50000/XMII/IlluminatorOData/$metadata?QueryTemplate=Default/SB/sql_getNodesByC...

The NW log is displaying some error messages related to the meta data document:

building metadata document is incomplete
[EXCEPTION]
com.sap.xmii.Illuminator.logging.LHException: com.sap.xmii.Illuminator.logging.LHException: Execution mode GET is not supported with this server or content type
at com.sap.xmii.Illuminator.connectors.AbstractConnector.processRequest(AbstractConnector.java:142)
at com.sap.xmii.Illuminator.server.QueryEngine.run(QueryEngine.java:65)
at com.sap.xmii.Illuminator.server.QueryEngine.run(QueryEngine.java:46)
at com.sap.xmii.Illuminator.services.handlers.IlluminatorService.processRequest(IlluminatorService.java:160)
at com.sap.xmii.Illuminator.services.ServiceManager.run(ServiceManager.java:83)
at com.sap.xmii.servlet.IlluminatorOData.prepareMetadata(IlluminatorOData.java:864)
at com.sap.xmii.servlet.IlluminatorOData.getMetadata(IlluminatorOData.java:310)
at com.sap.xmii.servlet.MIIMetadataResource.getMetadata(MIIMetadataResource.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:165)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:89)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:57)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:93)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:240)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:239)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:213)
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:131)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:266)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:191)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:734)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:242)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.runServlet(FilterChainImpl.java:202)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:103)
at com.sap.xmii.system.ODataSecurityFilter.doFilter(ODataSecurityFilter.java:79)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at com.sap.xsrf.filter.XSRFProtectorFilter.doFilter(XSRFProtectorFilter.java:62)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:441)
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:210)
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:441)
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:430)
at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:81)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:278)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:81)
at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)
at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.SessionSizeFilter.process(SessionSizeFilter.java:26)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:57)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:43)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:468)
at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:262)
at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:56)
at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)
at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)
at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)
Caused by: com.sap.xmii.Illuminator.logging.LHException: Execution mode GET is not supported with this server or content type
at com.sap.xmii.Illuminator.connectors.IDBC.DataSource.doProcessRequest(DataSource.java:53)
at com.sap.xmii.Illuminator.connectors.AbstractConnector.processRequest(AbstractConnector.java:112)
... 70 more 

If i am querying http://192.168.10.160:50000/XMII/IlluminatorOData/Rowset(QueryTemplate='Default/SB/sql_getNodesByCategory')/Rowset

than ill get an server error exception:

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<code>ServerErrorException</code>
<message lang="en-US">Internal Server Error</message>
</error>

The nw log shows: