cancel
Showing results for 
Search instead for 
Did you mean: 

unable to create xsl transformation

Former Member
0 Kudos

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



Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

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

abhinaste
Explorer
0 Kudos

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

Former Member
0 Kudos

Hi Abhijeet,

Thanks for your pointers, however we've already tried this, but the problem still persists.

Regards

Siddharth

swaroop_anasane
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Some screenshots for further information.

swaroop_anasane
Active Contributor
0 Kudos

Hi Siddhanrth,

Is this after applying the transformation, or by running the query template with just the query?

Regards,

Swaroop

Former Member
0 Kudos

Hi Siddharth,

Please post the entire stack trace of the exception. Are you using a proxy server also?

Regards,

Anushree

Former Member
0 Kudos

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

Former Member
0 Kudos

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