Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Error while creating Data Set with Oracle BI Analysis

Received Response
31
Views
4
Comments
AbinashBehera
AbinashBehera Rank 5 - Community Champion
edited Aug 13, 2024 6:07PM in Oracle Analytics Forum

Hi All,

I have created the data set with Oracle BI analysis. But while viewing data its throwing me the error shown below.

pastedImage_0.png

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Have you clicked the "Error Detail" hyperlink already?

    Is the java.lang.NullPointerException all you get?

    Have you checked the log files?

  • AbinashBehera
    AbinashBehera Rank 5 - Community Champion

    Hi Christian,

    I always expect your reply first.

    Though Log files I have not checked yet. But I am getting this error while adding a Prompt to the analysis. As in oracle docs it is mentioned that all analysis prompts will be inherited to run time. but its not working. Without prompts and any Hierarchical columns it works fine.

    Thanks,

    Abinash

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ok but that still means you have to have a more detailed error somewhere.

  • AbinashBehera
    AbinashBehera Rank 5 - Community Champion

    Hi Christian,

    This is the only error log i am getting from bipublisher.log file

    --------------------------------------------------------------------------

    [2017-02-03T17:21:48.658+05:30] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 17] [userId: <anonymous>] [ecid: b989a9f9cd351546:-2698651e:159fdd5efda:-8000-0000000000014607,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:364)

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

      at oracle.xdo.servlet.ui.datamodel.ValidationServlet.getDataModelParametersUI(ValidationServlet.java:516)

      at oracle.xdo.servlet.ui.datamodel.ValidationServlet.doGet(ValidationServlet.java:413)

      at oracle.xdo.servlet.ui.datamodel.ValidationServlet.doPost(ValidationServlet.java:484)

      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)

    Caused by: oracle.xdo.XDOException: oracle.xdo.XDOException: java.lang.NullPointerException

      at oracle.xdo.dataengine.datasource.plugin.saw.SawParameter.getParameterObjects(SawParameter.java:242)

      at oracle.xdo.dataengine.ParameterImpl.createParameterObjects(ParameterImpl.java:166)

      at oracle.xdo.servlet.dataengine.saw.SAWParameter.createParameters(SAWParameter.java:112)

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

      ... 55 more

    Caused by: oracle.xdo.XDOException: java.lang.NullPointerException

      at oracle.xdo.dataengine.datasource.plugin.saw.SawParameterParser.getSAWReportParameters(SawParameterParser.java:341)

      at oracle.xdo.dataengine.datasource.plugin.saw.SawDataSet.getSAWParameters(SawDataSet.java:361)

      at oracle.xdo.dataengine.datasource.plugin.saw.SawParameter.getParameterObjects(SawParameter.java:239)

      ... 58 more

    Caused by: java.lang.NullPointerException

      at oracle.xdo.dataengine.datasource.plugin.saw.SawParameterParser.getSAWReportParameters(SawParameterParser.java:165)

      ... 60 more

    ]]

    [2017-02-03T17:21:48.659+05:30] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 17] [userId: <anonymous>] [ecid: b989a9f9cd351546:-2698651e:159fdd5efda:-8000-0000000000014607,0] [APP: bipublisher#11.1.1] UIUTils.renderError: strict servlet API: cannot call getWriter() after getOutputStream()

    ------------------------------------------

    Thanks,

    Abinash