Not able to use Business Intelligence object in ADF , Given oracle.jbo.JboException

User_GMBEC

Hi ,

I am looking for an approach to integrate the Business Intelligence objects like Reports in ADF application 12c, I was trying with below one but stuck at adding MDS libraries so I was not able to drag and drop the objects in my ADF page.

https://docs.oracle.com/middleware/12213/biee/BIEDV/embedding_adf.htm#BIEDV1211

My JDeveloper version is 12.2.1.0.42.170105 , Is the right version to work with Business Intelligence objects, If not so please suggest what is latest compatible version.

Then I moved to older version 11.1.1.1.7 since above document is about this version. Now I did the steps but end up with below exception.

Target URL -- http://127.0.0.1:7101/OBIEEObject-ViewController-context-root/faces/Report

<Oct 24, 2017 3:41:19 PM IST> <Error> <HTTP> <BEA-101020> <[ServletContext@1910711[app:OBIEEObject module:OBIEEObject-ViewController-context-root path:/OBIEEObject-ViewController-context-root spec-version:2.5]] Servlet failed with Exception

oracle.jbo.JboException: JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-34010. Error message parameters are {0=view/oracle/otm/DataBindings.cpx, 1=jar:file:C:/Users/srvysyar.ORADEV/AppData/Roaming/JDeveloper/system11.1.1.7.40.64.93/DefaultDomain/servers/DefaultServer/tmp/_WL_user/OBIEEObject/xr6o0h/war/WEB-INF/lib/adflibViewController.jar!/view/oracle/otm/DataBindings.cpx, 2=file:/C:/Users/srvysyar.ORADEV/AppData/Roaming/JDeveloper/system11.1.1.7.40.64.93/o.j2ee/drs/OBIEEObject/ViewControllerWebApp.war/WEB-INF/classes/view/oracle/otm/DataBindings.cpx}

at oracle.jbo.uicli.mom.CpxUtils$Visitor.visit(CpxUtils.java:227)

at oracle.adf.share.common.rc.util.impl.MetadataRegistryImpl.visitRegistryPaths(MetadataRegistryImpl.java:171)

at oracle.adf.share.common.rc.util.impl.MetadataRegistryImpl.visitRegistryPaths(MetadataRegistryImpl.java:118)

at oracle.jbo.uicli.mom.CpxUtils.getCpxListFromMetadata(CpxUtils.java:477)

at oracle.jbo.uicli.mom.JUMetaObjectManager.loadCpx(JUMetaObjectManager.java:719)

Truncated. see log file for complete stacktrace

>

<Oct 24, 2017 3:41:19 PM IST> <Notice> <Diagnostics> <BEA-320068> <Watch 'UncheckedException' with severity 'Notice' on server 'DefaultServer' has triggered at Oct 24, 2017 3:41:19 PM IST. Notification details:

WatchRuleType: Log

WatchRule: (SEVERITY = 'Error') AND ((MSGID = 'WL-101020') OR (MSGID = 'WL-101017') OR (MSGID = 'WL-000802') OR (MSGID = 'BEA-101020') OR (MSGID = 'BEA-101017') OR (MSGID = 'BEA-000802'))

WatchData: DATE = Oct 24, 2017 3:41:19 PM IST SERVER = DefaultServer MESSAGE = [ServletContext@1910711[app:OBIEEObject module:OBIEEObject-ViewController-context-root path:/OBIEEObject-ViewController-context-root spec-version:2.5]] Servlet failed with Exception

oracle.jbo.JboException: JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-34010. Error message parameters are {0=view/oracle/otm/DataBindings.cpx, 1=jar:file:C:/Users/srvysyar.ORADEV/AppData/Roaming/JDeveloper/system11.1.1.7.40.64.93/DefaultDomain/servers/DefaultServer/tmp/_WL_user/OBIEEObject/xr6o0h/war/WEB-INF/lib/adflibViewController.jar!/view/oracle/otm/DataBindings.cpx, 2=file:/C:/Users/srvysyar.ORADEV/AppData/Roaming/JDeveloper/system11.1.1.7.40.64.93/o.j2ee/drs/OBIEEObject/ViewControllerWebApp.war/WEB-INF/classes/view/oracle/otm/DataBindings.cpx}

at oracle.jbo.uicli.mom.CpxUtils$Visitor.visit(CpxUtils.java:227)

at oracle.adf.share.common.rc.util.impl.MetadataRegistryImpl.visitRegistryPaths(MetadataRegistryImpl.java:171)

at oracle.adf.share.common.rc.util.impl.MetadataRegistryImpl.visitRegistryPaths(MetadataRegistryImpl.java:118)

at oracle.jbo.uicli.mom.CpxUtils.getCpxListFromMetadata(CpxUtils.java:477)

at oracle.jbo.uicli.mom.JUMetaObjectManager.loadCpx(JUMetaObjectManager.java:719)

at oracle.adf.model.BindingContext.initialize(BindingContext.java:402)

at oracle.adf.model.BindingRequestHandler.beginRequest(BindingRequestHandler.java:238)

at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:203)

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.webcenter.content.integration.servlets.ContentServletFilter.doFilter(ContentServletFilter.java:168)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

at oracle.wcps.client.PersonalizationFilter.doFilter(PersonalizationFilter.java:74)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

at oracle.webcenter.lifecycle.filter.LifecycleLockFilter.doFilter(LifecycleLockFilter.java:151)

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:324)

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.ExecuteThread.execute(ExecuteThread.java:209)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

SUBSYSTEM = HTTP USERID = <WLS Kernel> SEVERITY = Error THREAD = [ACTIVE] ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)' MSGID = BEA-101020 MACHINE = SRVYSYAR-IN TXID =  CONTEXTID = 64f107c811070984:-6ee5ce48:15f4dbaefca:-8000-000000000000011d TIMESTAMP = 1508839879564

WatchAlarmType: AutomaticReset

WatchAlarmResetPeriod: 30000

Please suggest on how to proceed further to call BI Objects from ADF application.

Any help would be grateful.

Thank you,

Sriram.

User_GMBEC

Hi,

Here I want to summarize the problems I am facing currently.

I was able to fetch the BI Dashboard reports in JDeveloper 11.1.1.7 so I have no issues with 11, All I am looking for help is for 12c.

Today I installed 12.2.1.3 JDeveloper and followed below document but didn't find all the BI extensions there in the given document.

I see only below three are available in JDeveloper  Help -> Check for updates, I installed them.

Business Intelligence ADF View Regions

Business Intelligence Logical SQL View Objects

Business Intelligence Soap Connection

Then I tried to install the "Business Intelligence ADF Task Flow" by downloading it from 12c extensions link but after I selected .zip file in Install from local file option in Check for updates window,  my JDeveloper is getting stuck and not installing the extension. I continued without that extension but stuck at not able to drag and drop the BI Dashboard Reports in my jsf page.

I tried in 12.2.1.0 also, there I could install all the extensions but still not able to drag and drop the reports.

Thank you.