0 Replies Latest reply: Jan 9, 2013 12:18 PM by user739752 RSS

    BISoapException when trying to embed BI report in a simple jspx page

    user739752
      I'm trying to embed BI report in a simple jspx page in a simple application (without security). When I tried to run the page, I'm getting BISoapException: The connection retrieval failed. But when I test the BI Presentation Services connection in JDEV, it connects successfully. The connection.xml and jspx content are shown at the bottom. Any pointers will be greatly appreciated.

      <ReferenceStoreHelper> <createReference> No credential could be loaded for Reference = Reference Class Name: oracle.bi.presentation.soap.connection.BISoapConnection
      , SecureRefAddr = un. Setting default value of "".
      <ReferenceStoreHelper> <createReference> No credential could be loaded for Reference = Reference Class Name: oracle.bi.presentation.soap.connection.BISoapConnection
      Type: un
      Content:
      , SecureRefAddr = pw. Setting default value of "".
      <ReferenceStoreHelper> <getReferencesMapEx> Incomplete connection reference object for connection:bips
      <BISoapConnectionFactory> <_getConnectionFallback> Cannot lookup the connection,bips using fallbacks
      oracle.bi.presentation.soap.connection.BISoapException: The connection retrieval failed. Please see the log file fore more details.
           at oracle.bi.presentation.soap.connection.impl.BaseBISoapConnection.initSawSession(BaseBISoapConnection.java:774)
           at oracle.bi.presentation.soap.connection.impl.RTBISoapConnection.<init>(RTBISoapConnection.java:62)
           at oracle.bi.presentation.soap.connection.BISoapConnectionFactory.getObjectInstance(BISoapConnectionFactory.java:715)
           at oracle.adf.share.jndi.ReferenceStoreHelper.getObjectForReference(ReferenceStoreHelper.java:296)
           at oracle.adf.share.jndi.ContextImpl.findObject(ContextImpl.java:651)
           at oracle.adf.share.jndi.ContextImpl.lookup(ContextImpl.java:150)
           at oracle.adf.share.jndi.ContextImpl.lookup(ContextImpl.java:155)
           at javax.naming.InitialContext.lookup(InitialContext.java:392)
           at oracle.bi.presentation.soap.connection.BISoapConnectionFactory._getConnectionFallback(BISoapConnectionFactory.java:522)
           at oracle.bi.presentation.soap.connection.BISoapConnectionFactory._getConnectionImpl(BISoapConnectionFactory.java:296)
           at oracle.bi.presentation.soap.connection.BISoapConnectionFactory._getConnectionAndAddIfNecessary(BISoapConnectionFactory.java:580)
           at oracle.bi.presentation.soap.connection.BISoapConnectionFactory.getConnection(BISoapConnectionFactory.java:163)
           at oracle.bi.presentation.runtime.binding.BIRegionBinding.getHtmlContent(BIRegionBinding.java:320)
           at oracle.bi.presentation.view.faces.renderkit.ReportBaseRenderer.encodeAll(ReportBaseRenderer.java:100)
           at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1432)
           at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:858)
           at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
           at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
           at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:422)
           at org.apache.myfaces.trinidad.render.CoreRenderer.encodeAllChildren(CoreRenderer.java:438)
           at org.apache.myfaces.trinidadinternal.renderkit.core.xhtml.PanelPartialRootRenderer.renderContent(PanelPartialRootRenderer.java:69)
           at org.apache.myfaces.trinidadinternal.renderkit.core.xhtml.BodyRenderer.renderContent(BodyRenderer.java:148)
           at org.apache.myfaces.trinidadinternal.renderkit.core.xhtml.PanelPartialRootRenderer.encodeAll(PanelPartialRootRenderer.java:151)
           at org.apache.myfaces.trinidadinternal.renderkit.core.xhtml.BodyRenderer.encodeAll(BodyRenderer.java:80)
           at org.apache.myfaces.trinidad.render.CoreRenderer.delegateRenderer(CoreRenderer.java:452)
           at org.apache.myfaces.trinidadinternal.renderkit.core.xhtml.DocumentRenderer.encodeAll(DocumentRenderer.java:106)
           at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:858)
           at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
           at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
           at com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:266)
           at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)
           at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:189)
           at org.apache.myfaces.trinidadinternal.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:193)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._renderResponse(LifecycleImpl.java:979)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:408)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:237)
           at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
           at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:208)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:128)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
           at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)
           at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:180)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
           at java.security.AccessController.doPrivileged(Native Method)
           at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
           at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
           at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
           at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
           at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
           at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
      <BIRegionBinding> <getHtmlContent>
      oracle.bi.presentation.soap.connection.BISoapException: Please check the log file for more details.
           at oracle.bi.presentation.runtime.binding.BIRegionBinding.getHtmlContent(BIRegionBinding.java:325)
           at oracle.bi.presentation.view.faces.renderkit.ReportBaseRenderer.encodeAll(ReportBaseRenderer.java:100)
           at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1432)
           at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:858)
           at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
           at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
           at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:422)
           at org.apache.myfaces.trinidad.render.CoreRenderer.encodeAllChildren(CoreRenderer.java:438)
           at org.apache.myfaces.trinidadinternal.renderkit.core.xhtml.PanelPartialRootRenderer.renderContent(PanelPartialRootRenderer.java:69)
           at org.apache.myfaces.trinidadinternal.renderkit.core.xhtml.BodyRenderer.renderContent(BodyRenderer.java:148)
           at org.apache.myfaces.trinidadinternal.renderkit.core.xhtml.PanelPartialRootRenderer.encodeAll(PanelPartialRootRenderer.java:151)
           at org.apache.myfaces.trinidadinternal.renderkit.core.xhtml.BodyRenderer.encodeAll(BodyRenderer.java:80)
           at org.apache.myfaces.trinidad.render.CoreRenderer.delegateRenderer(CoreRenderer.java:452)
           at org.apache.myfaces.trinidadinternal.renderkit.core.xhtml.DocumentRenderer.encodeAll(DocumentRenderer.java:106)
           at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
           at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:858)
           at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
           at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
           at com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:266)
           at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)
           at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:189)
           at org.apache.myfaces.trinidadinternal.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:193)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._renderResponse(LifecycleImpl.java:979)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:408)
           at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:237)
           at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
           at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:208)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:128)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
           at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271)
           at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)
           at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:180)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
           at java.security.AccessController.doPrivileged(Native Method)
           at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
           at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
           at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
           at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
           at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
           at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

      =================================
      Here is the connections.xml for the simple app.

      <?xml version = '1.0' encoding = 'UTF-8'?>
      <References xmlns="http://xmlns.oracle.com/adf/jndi">
      <Reference name="bips" className="oracle.bi.presentation.soap.connection.BISoapConnection" credentialStoreKey="bips" xmlns="">
      <Factory className="oracle.bi.presentation.soap.connection.BISoapConnectionFactory"/>
      <RefAddresses>
      <SecureRefAddr addrType="un"/>
      <SecureRefAddr addrType="pw"/>
      <StringRefAddr addrType="pc">
      <Contents>http</Contents>
      </StringRefAddr>
      <StringRefAddr addrType="hst">
      <Contents>slcag180.us.oracle.com</Contents>
      </StringRefAddr>
      <StringRefAddr addrType="pt">
      <Contents>30621</Contents>
      </StringRefAddr>
      <StringRefAddr addrType="ctx">
      <Contents>analytics</Contents>
      </StringRefAddr>
      <StringRefAddr addrType="uctx">
      <Contents>analytics-ws</Contents>
      </StringRefAddr>
      <StringRefAddr addrType="res">
      <Contents>http://slcag180.us.oracle.com:30621/analytics</Contents>
      </StringRefAddr>
      <StringRefAddr addrType="imp">
      <Contents>true</Contents>
      </StringRefAddr>
      <StringRefAddr addrType="res_auto">
      <Contents>true</Contents>
      </StringRefAddr>
      <StringRefAddr addrType="adf_cookies_to_skip">
      <Contents/>
      </StringRefAddr>
      <StringRefAddr addrType="bi_cookies_to_maintain">
      <Contents/>
      </StringRefAddr>
      <StringRefAddr addrType="bi_cookies_to_skip">
      <Contents/>
      </StringRefAddr>
      </RefAddresses>
      </Reference>
      </References>

      ==========================
      Here is the jspx page.

      <?xml version='1.0' encoding='UTF-8'?>
      <jsp:root xmlns:jsp="http://java.sun.com/JSP/Page" version="2.1"
      xmlns:f="http://java.sun.com/jsf/core"
      xmlns:af="http://xmlns.oracle.com/adf/faces/rich"
      xmlns:adfbi="http://xmlns.oracle.com/adf/bi/report"
      xmlns:tr="http://myfaces.apache.org/trinidad">
      <jsp:directive.page contentType="text/html;charset=UTF-8"/>
      <f:view locale="en">
      <tr:document id="d1">
      <tr:form id="f1">
      <adfbi:content id="content1" width="1024px" height="768px"
      value="#{bindings.biExecBinding1}"/>
      </tr:form>
      </tr:document>
      </f:view>
      </jsp:root>