<p>I am running a report using iportal and ihub3 that is failing with the stacktrace below. The report has parameters. Certain parameter values will cause the report to fail. However, running the SQL manually outside the report no issue is found and the query returns results.</p>
<p> </p>
<p>The SQL is logged in the jsrvrihub.exe log file.</p>
<p>Is there anywhere else that might give me more clues as to what is causing the problem?</p>
<p> </p>
<p> </p>
<p> </p>
<div>07-Oct-2014 12:30:34 com.actuate.schemas.ActuateSoapBindingImpl getIVUpdatedObjects</div>
<div>SEVERE: Render report failed.</div>
<div>Render report failed.</div>
<div>at com.actuate.activeportal.idapiadapter.AcGetIVUpdatedObjectAdapter.executeGetIVUpdatedObject(AcGetIVUpdatedObjectAdapter.java:277)</div>
<div>at com.actuate.iv.service.actionhandler.AbstractViewingActionHandler.doRemoteExecute(AbstractViewingActionHandler.java:289)</div>
<div>at com.actuate.iv.service.actionhandler.AbstractViewingActionHandler.remoteExecute(AbstractViewingActionHandler.java:559)</div>
<div>at com.actuate.iv.soapengine.processor.IVComponentProcessor.executeAction(IVComponentProcessor.java:62)</div>
<div>at com.actuate.iv.soapengine.processor.IVDocumentProcessor.handleStartUp(IVDocumentProcessor.java:739)</div>
<div>at sun.reflect.GeneratedMethodAccessor1640.invoke(Unknown Source)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div>
<div>at java.lang.reflect.Method.invoke(Method.java:597)</div>
<div>at com.actuate.iv.soapengine.processor.IVComponentProcessor.process(IVComponentProcessor.java:138)</div>
<div>at com.actuate.schemas.ActuateSoapBindingImpl.getIVUpdatedObjects(ActuateSoapBindingImpl.java:840)</div>
<div>at sun.reflect.GeneratedMethodAccessor1405.invoke(Unknown Source)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div>
<div>at java.lang.reflect.Method.invoke(Method.java:597)</div>
<div>at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:388)</div>
<div>at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:283)</div>
<div>at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</div>
<div>at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</div>
<div>at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</div>
<div>at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</div>
<div>at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)</div>
<div>at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</div>
<div>at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</div>
<div>at com.actuate.iv.servlet.IVHttpDispatcher.handleRequest(IVHttpDispatcher.java:94)</div>
<div>at com.actuate.iv.servlet.IVServlet.doPost(IVServlet.java:278)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)</div>
<div>at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</div>
<div>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)</div>
<div>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</div>
<div>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)</div>
<div>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</div>
<div>at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)</div>
<div>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)</div>
<div>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</div>
<div>at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)</div>
<div>at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)</div>
<div>at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)</div>
<div>at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)</div>
<div>at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)</div>
<div>at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)</div>
<div>at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)</div>
<div>at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</div>
<div>at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)</div>
<div>at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)</div>
<div>at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)</div>
<div>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)</div>
<div>at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:436)</div>
<div>at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:384)</div>
<div>at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)</div>
<div>at java.lang.Thread.run(Thread.java:662)</div>
