Oracle Analytics Cloud and Server

Products Banner

Error while creating BI Publisher Data Set with Oracle BI Analysis

Received Response
102
Views
6
Comments

Summary

Error while creating BI Publisher Data Set with Oracle BI Analysis

Content

When I try to create a BI Publisher Data Set that uses an Oracle BI Analysis with prompts I receive the error: oracle.xdo.XDOException: java.lang.NullPointerException when I try to View Data so I can create Sample Data to create a report.  When I remove the prompts from the Oracle BI Analysis it works. How do I create a BI Publisher report that uses an Oracle BI Analysis with prompts?

Tagged:

Answers

  • Dir_Pal
    Dir_Pal ✭✭✭✭✭

    did u Tried creating  in a different browser

  • Venkat Thota - BIP
    Venkat Thota - BIP ✭✭✭✭✭

    To answer the original question: the manual is referring to BIEE objects, not BIP.  You do not build the parameter in the BIP Data Model.You use the Analysis as a data source, then add the report to a dashboard, and test there the Presentation Variable should be present there.

  • Dclay
    Dclay ✭✭✭

    We are using OBIEE 11.1.1.7.  I have tried this in Google Chrome and IE 11 without success. I do not see an nqquery.log file but I have included the last 100 lines from our bipublisher.log file below.

    [2018-04-23T10:30:10.333-05:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 56] [userId: <anonymous>] [ecid: 4cb6ee6dac367fa9:5a69d9c1:162cbb41e81:-8000-00000000000870fc,0] [APP: bipublisher#11.1.1] UIUTils.renderError: strict servlet API: cannot call getWriter() after getOutputStream()

    [2018-04-23T10:30:24.262-05:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 56] [userId: <anonymous>] [ecid: 4cb6ee6dac367fa9:5a69d9c1:162cbb41e81:-8000-0000000000087128,0] [APP: bipublisher#11.1.1] oracle.xdo.XDOException: oracle.xdo.XDOException: java.lang.NullPointerException[[

            at oracle.xdo.servlet.definition.v2.DataModelParser.createReportParameters(DataModelParser.java:280)

            at oracle.xdo.servlet.definition.v2.DataModelParser.endElement(DataModelParser.java:217)

            at oracle.xdo.servlet.definition.ReportRootHandler.endElement(ReportRootHandler.java:54)

            at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1282)

            at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:338)

            at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)

            at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:199)

            at oracle.xdo.servlet.ReportHelper.config(ReportHelper.java:53)

            at oracle.xdo.servlet.ReportHelper.configureReport(ReportHelper.java:39)

            at oracle.xdo.servlet.ReportRepository.getReportModel(ReportRepository.java:348)

            at oracle.xdo.servlet.ReportRepository.getReportModel(ReportRepository.java:326)

            at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:448)

            at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:280)

            at oracle.xdo.servlet.XDOServlet.doPost(XDOServlet.java:313)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

            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.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)

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

            at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:127)

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

            at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)

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

  • YGUTTIKONDA
    YGUTTIKONDA ✭✭✭✭✭

    can you trying having default values to prompts ?

  • Venkat Thota - BIP
    Venkat Thota - BIP ✭✭✭✭✭

    please upload bi publisher.log and nqquery.log to find exact issue. obiee version ?