Error while creating BI Publisher Data Set with Oracle BI Analysis

Dclay · April 2018

Summary

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?

Dir_Pal · April 2018

did u Tried creating in a different browser

Venkat Thota - BIP · April 2018

https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/2370-bi-publisher-parameterized-report-using-oracle-bi-ee please post detail error. thanks

Venkat Thota - BIP · April 2018

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 · April 2018

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)