If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

SOAP Error Drilling from Chart to List in Portlet

Started by bi4u2, 06 Jun 2012 11:42:27 AM

Previous topic - Next topic

bi4u2

I have a report which contains a bar chart and a list below the chart. I have set up a drill through definition
on both the chart and the list which pulls up a drill page located in the same report, but to a different query.

When I run this as a stand alone report from Cognos Connection everything functions properly.

When I run this report from a Cognos Viewer portlet, when I click on the chart to look at the drill down details,
I get SOAP errors while the drill through from the list functions properly.

This is Version 8.4.1

SOAPFaultException

com.cognos.portal.fragment.server.SOAPFaultException: RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.
   at com.cognos.portal.fragment.service.ServiceEnvironment.getBiBusTargetStream(ServiceEnvironment.java:451)
   at com.cognos.portal.fragment.service.ServiceEnvironment.getLocalTargetStream(ServiceEnvironment.java:271)
   at com.cognos.portal.fragment.Environment.getTargetStream(Environment.java:601)
   at com.cognos.portal.fragment.server.document.DocumentFactoryImpl.createDocument(DocumentFactoryImpl.java:127)
   at com.cognos.portal.fragment.wsrp.DocumentFactoryImpl.createDocument(DocumentFactoryImpl.java:35)
   at com.cognos.portal.fragment.server.DashboardProcessor.process(DashboardProcessor.java:234)
   at com.cognos.portal.fragment.wsrp.Fragment.executeAjaxRequest(Fragment.java:217)
   at com.cognos.portal.fragment.wsrp.FragmentWSRPBridge.getFragmentXML(FragmentWSRPBridge.java:578)
   at com.cognos.portal.fragment.service.WSRPService.handleHttpRequest(WSRPService.java:370)
   at com.cognos.portal.fragment.service.WSRPService.invokeImpl(WSRPService.java:338)
   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
   at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
   at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:673)
   at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:639)
   at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:388)
   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
   at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
   at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:126)
   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
   at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:79)
   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
   at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:149)
   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:263)
   at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:146)
   at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:264)
   at com.cognos.pogo.transport.PogoServlet.doPost(PogoServlet.java:595)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
   at com.cognos.pogo.isolation.ServletWrapper.service(ServletWrapper.java:324)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:153)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2398)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:146)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)