on 10-31-2014 1:08 PM
Dear experts,
I'm trying to run a select query and display the output in browser.
However when I do so, I do not get the result in tabular format, rather I get xml output of the query with the message : "Unable To Create Stylesheet Transformation".
While viewing logs I got following error messages :
I'm working on SAP MII 14.0 SP5 Patch 7
Please help me to solve this issue.
Regards
Siddharth Patel
This issue has been resolved.
We added fully qualified name of the server to the host file, which resolved the issue.
My best wishes to all the contributors for providing inputs.
Regards
Siddharth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Siddharth,
Try doing below steps:
1. Go to System Management --> System Properties --> Proxy configuration
2. Blank out the parameters - Bypass List and Host.
3. Put port as 8080 which is default port
after saving the parameters with above settings, check if the issue persists.
Thanks,
Abhijeet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Siddharth,
From the screenshots it is evident that the query is generating output, but the xsl being used to portray a td,tr structure, MII is not able to connect to that xsl.
Try restarting the server from SAP Managaement console.
If you are able to open the xsl from browser by following the path XMII/Stylesheets/IllumRowsetHTML.xsl , the xsl is present. Check if there's some change at the netweaver stack and why MII is not able to find the host. Basis might help you on this!!
Thanks,
Swaroop
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Siddhanrth,
Is this after applying the transformation, or by running the query template with just the query?
Regards,
Swaroop
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Siddharth,
Please post the entire stack trace of the exception. Are you using a proxy server also?
Regards,
Anushree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anushree,
1. Regarding Proxy server: We have installed Netweaver and MII on Corporate internal server that is on Corporate domain and
runs on proxy settings to connect internet.
2. Regarding Stack trace: Below is the Error log from SAP Netweaver Log Viewer:
Error messages :
1)
Unable to read XSL document [http://xxx:yyy/XMII/Stylesheets/IllumRowsetHTML.xsl]
[EXCEPTION]
java.lang.Exception: Status (504): Unknown Host
at com.sap.lhcommon.xml.XMLHandler.getDocument(XMLHandler.java:255)
at com.sap.lhcommon.xml.XMLHandler.getDocument(XMLHandler.java:212)
at com.sap.lhcommon.xml.XMLHandler.getDocument(XMLHandler.java:207)
at com.sap.xmii.Illuminator.tools.builder.XSLTransformer.<init>(XSLTransformer.java:74)
at com.sap.xmii.Illuminator.tools.builder.XMLBuilder.setFinalTransform(XMLBuilder.java:642)
at com.sap.xmii.Illuminator.tools.builder.XMLBuilder.configureTransformers(XMLBuilder.java:517)
at com.sap.xmii.Illuminator.tools.builder.XMLBuilder.<init>(XMLBuilder.java:111)
at sun.reflect.GeneratedConstructorAccessor597.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createObject(BuilderFactory.java:160)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createBuilder(BuilderFactory.java:138)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createBuilder(BuilderFactory.java:114)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createBuilder(BuilderFactory.java:100)
at com.sap.xmii.Illuminator.system.QueryData.createBuilder(QueryData.java:118)
at com.sap.xmii.Illuminator.system.QueryData.setOutputStream(QueryData.java:90)
at com.sap.xmii.Illuminator.system.QueryData.<init>(QueryData.java:72)
at com.sap.xmii.Illuminator.services.ServiceManager.createData(ServiceManager.java:133)
at com.sap.xmii.servlet.Illuminator.service(Illuminator.java:64)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
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.SecurityFilter.doFilter(SecurityFilter.java:117)
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:475)
at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:269)
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)
2)
java.lang.Exception: Status (504): Unknown Host
[EXCEPTION]
javax.xml.transform.TransformerConfigurationException: java.lang.Exception: Status (504): Unknown Host
at com.sap.xmii.Illuminator.tools.builder.XSLTransformer.<init>(XSLTransformer.java:80)
at com.sap.xmii.Illuminator.tools.builder.XMLBuilder.setFinalTransform(XMLBuilder.java:642)
at com.sap.xmii.Illuminator.tools.builder.XMLBuilder.configureTransformers(XMLBuilder.java:517)
at com.sap.xmii.Illuminator.tools.builder.XMLBuilder.<init>(XMLBuilder.java:111)
at sun.reflect.GeneratedConstructorAccessor597.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createObject(BuilderFactory.java:160)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createBuilder(BuilderFactory.java:138)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createBuilder(BuilderFactory.java:114)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createBuilder(BuilderFactory.java:100)
at com.sap.xmii.Illuminator.system.QueryData.createBuilder(QueryData.java:118)
at com.sap.xmii.Illuminator.system.QueryData.setOutputStream(QueryData.java:90)
at com.sap.xmii.Illuminator.system.QueryData.<init>(QueryData.java:72)
at com.sap.xmii.Illuminator.services.ServiceManager.createData(ServiceManager.java:133)
at com.sap.xmii.servlet.Illuminator.service(Illuminator.java:64)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
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.SecurityFilter.doFilter(SecurityFilter.java:117)
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:475)
at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:269)
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: java.lang.Exception: Status (504): Unknown Host
at com.sap.lhcommon.xml.XMLHandler.getDocument(XMLHandler.java:255)
at com.sap.lhcommon.xml.XMLHandler.getDocument(XMLHandler.java:212)
at com.sap.lhcommon.xml.XMLHandler.getDocument(XMLHandler.java:207)
at com.sap.xmii.Illuminator.tools.builder.XSLTransformer.<init>(XSLTransformer.java:74)
... 59 more
---------
java.lang.Exception: Status (504): Unknown Host
at com.sap.lhcommon.xml.XMLHandler.getDocument(XMLHandler.java:255)
at com.sap.lhcommon.xml.XMLHandler.getDocument(XMLHandler.java:212)
at com.sap.lhcommon.xml.XMLHandler.getDocument(XMLHandler.java:207)
at com.sap.xmii.Illuminator.tools.builder.XSLTransformer.<init>(XSLTransformer.java:74)
at com.sap.xmii.Illuminator.tools.builder.XMLBuilder.setFinalTransform(XMLBuilder.java:642)
at com.sap.xmii.Illuminator.tools.builder.XMLBuilder.configureTransformers(XMLBuilder.java:517)
at com.sap.xmii.Illuminator.tools.builder.XMLBuilder.<init>(XMLBuilder.java:111)
at sun.reflect.GeneratedConstructorAccessor597.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createObject(BuilderFactory.java:160)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createBuilder(BuilderFactory.java:138)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createBuilder(BuilderFactory.java:114)
at com.sap.xmii.Illuminator.tools.builder.BuilderFactory.createBuilder(BuilderFactory.java:100)
at com.sap.xmii.Illuminator.system.QueryData.createBuilder(QueryData.java:118)
at com.sap.xmii.Illuminator.system.QueryData.setOutputStream(QueryData.java:90)
at com.sap.xmii.Illuminator.system.QueryData.<init>(QueryData.java:72)
at com.sap.xmii.Illuminator.services.ServiceManager.createData(ServiceManager.java:133)
at com.sap.xmii.servlet.Illuminator.service(Illuminator.java:64)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
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.SecurityFilter.doFilter(SecurityFilter.java:117)
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:475)
at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:269)
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)
Regards
Siddharth
Hi Siddharth,
Try opening the XSL directly using:
http://xxx:yyy/XMII/Stylesheets/IllumRowsetHTML.xsl
in the browser.
A 504 error means that the server did not receive a response in a timely manner. Here are a few things you could try:
1) Maintain a proxy by pass list in System Management - > System Properties
2) Try a server re-start.
This is clearly a network issue so you should ideally run a network trace to check what is going on with the request.
Regards,
Anushree
User | Count |
---|---|
10 | |
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.