Oracle Analytics Cloud and Server

Error while creating BI Publisher Data Set with Oracle BI Analysis
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?
Answers
-
did u Tried creating in a different browser
-
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.
-
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)
-
can you trying having default values to prompts ?
-
please upload bi publisher.log and nqquery.log to find exact issue. obiee version ?