4 Replies Latest reply: Feb 2, 2005 7:06 AM by 427444 RSS

    javax.servlet.jsp.JspException: java.lang.NullPointerException

    427444
      hi,
      I try to view my presentation in jsp page.I use oracle jdeveloper 9.2.0.4 and bibeans 9.2.0.4 and once 1 month ago I did this taks (I view a presentation from bibdemo in jsp file)
      now I try to view my own presentation in jsp but I recieve error message in my own schema and bibdemo schema!!
      when I use windows xp I recieve following error :

      500 Internal Server Error
      javax.servlet.jsp.JspException: BIB-10310 An unknown exception occurred.
      BIB-10101 Handler failed to handle UserObject.
      BIB-14067 Persistable object threw exception during lookup on method setXMLAsString; component class oracle.dss.dataSource.client.QueryClient; exception oracle.dss.util.persistence.BIPersistenceException.
      BIB-9509 Oracle OLAP did not create cursor.
      oracle.olapi.data.source.UnmatchedInputsException
      BIB-9509 Oracle OLAP did not create cursor.
      oracle.olapi.data.source.UnmatchedInputsException
      oracle.olapi.data.source.UnmatchedInputsException
           at oracle.dss.addins.jspTags.PresentationTag.doStartTag(PresentationTag.java:194)
           at test.jspService(test.jsp:6)
           [test.jsp]
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:349)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:778)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
           at java.lang.Thread.run(Thread.java:534)

      *****************************************************
      and when I use windows NT I recieve following error :

      500 Internal Server Error
      javax.servlet.jsp.JspException: java.lang.NullPointerException
           at oracle.dss.addins.jspTags.RenderTag.doEndTag(RenderTag.java:212)
           at kafa_report__7._jspService(kafa_report_7.jsp:18)
           [kafa_report_7.jsp]
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:349)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:778)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
           at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
           at java.lang.Thread.run(Thread.java:534)

      ...................!!!!!!!
      I
      what the problem is ????????
      thanks in advance,
        • 1. Re: javax.servlet.jsp.JspException: java.lang.NullPointerException
          423213
          hi,
          check BIBeans catalog with bi_checkconfig

          maddox
          • 2. Re: javax.servlet.jsp.JspException: java.lang.NullPointerException
            427444
            hi
            I did it before and the result is here :
            <?xml version="1.0" encoding="UTF-8" ?>
            - <BICheckConfig version="1.0.2.0">
            <Check key="JDEV_ORACLE_HOME" value="d:\jdev904" />
            <Check key="JAVA_HOME" value="C:\j2sdk1.4.2_01" />
            <Check key="JDeveloper version" value="9.0.4.0.1419" />
            <Check key="BI Beans release description" value="BI Beans 9.0.4 Production Release" />
            <Check key="BI Beans component number" value="9.0.4.23.0" />
            <Check key="BI Beans internal version" value="2.7.5.32" />
            <Check key="host" value="200.20.20.11" />
            <Check key="port" value="1521" />
            <Check key="sid" value="ora10g" />
            <Check key="user" value="dw_targetschema" />
            <Check key="Connecting to the database" value="Successful" />
            <Check key="JDBC driver version" value="9.2.0.4.0" />
            <Check key="JDBC JAR file location" value="D:\jdev904\jdev\lib\patches" />
            <Check key="Database version" value="10.1.0.2.0" />
            <Check key="OLAP Catalog version" value="10.1.0.2.0" />
            <Check key="OLAP AW Engine version" value="10.1.0.2.0" />
            <Check key="OLAP API Server version" value="10.1.0.2.0" />
            <Check key="BI Beans Catalog version" value="N/A; not installed in dw_targetschema" />
            <Check key="OLAP API JAR file version" value="9.2" />
            <Check key="OLAP API JAR file location" value="d:\jdev904\jdev\lib\ext" />
            <Check key="OLAP API Metadata Load" value="Successful" />
            <Check key="Number of metadata folders" value="2" />
            <Check key="Number of metadata measures" value="1" />
            <Check key="Number of metadata dimensions" value="3" />
            - <Check key="OLAP API Metadata">
            - <![CDATA[
            ==============================================================================
            Type Name (S=Schema, C=Cube, M=Measure, D=Dimension)
            ========= ====================================================================
            Folder... ROOT
            Folder... KAFA_COLLECTION
            Folder... KAFA_COLLECTION2
            Measure.. SALARY
            Dimension DEP_DIM
            Dimension EMP_DIM
            Dimension JOB_DIM


            ]]>
            </Check>
            </BICheckConfig>

            and the other thing that I mensioned I have the same problem with bibdemo (I didn't have this problem before).

            shima
            • 3. Re: javax.servlet.jsp.JspException: java.lang.NullPointerException
              423213
              Use parameter -q with bi_checkconfig

              maddox
              • 4. Re: javax.servlet.jsp.JspException: java.lang.NullPointerException
                427444
                hi,
                here the result :


                <?xml version="1.0" encoding="UTF-8" ?>
                - <BICheckConfig version="1.0.2.0">
                <Check key="JDEV_ORACLE_HOME" value="d:\jdev904" />
                <Check key="JAVA_HOME" value="C:\j2sdk1.4.2_01" />
                <Check key="JDeveloper version" value="9.0.4.0.1419" />
                <Check key="BI Beans release description" value="BI Beans 9.0.4 Production Release" />
                <Check key="BI Beans component number" value="9.0.4.23.0" />
                <Check key="BI Beans internal version" value="2.7.5.32" />
                <Check key="host" value="200.20.20.11" />
                <Check key="port" value="1521" />
                <Check key="sid" value="ora10g" />
                <Check key="user" value="dw_targetschema" />
                <Check key="Connecting to the database" value="Successful" />
                <Check key="JDBC driver version" value="9.2.0.4.0" />
                <Check key="JDBC JAR file location" value="D:\jdev904\jdev\lib\patches" />
                <Check key="Database version" value="10.1.0.2.0" />
                <Check key="OLAP Catalog version" value="10.1.0.2.0" />
                <Check key="OLAP AW Engine version" value="10.1.0.2.0" />
                <Check key="OLAP API Server version" value="10.1.0.2.0" />
                <Check key="BI Beans Catalog version" value="N/A; not installed in dw_targetschema" />
                <Check key="OLAP API JAR file version" value="9.2" />
                <Check key="OLAP API JAR file location" value="d:\jdev904\jdev\lib\ext" />
                <Check key="OLAP API Metadata Load" value="Successful" />
                <Check key="Number of metadata folders" value="2" />
                <Check key="Number of metadata measures" value="1" />
                <Check key="Number of metadata dimensions" value="3" />
                - <Check key="OLAP API Metadata">
                - <![CDATA[
                ==============================================================================
                Type      Name (S=Schema, C=Cube, M=Measure, D=Dimension)         Status   
                ========= ======================================================= ============
                Folder... ROOT
                Folder...   KAFA_COLLECTION
                Folder...   KAFA_COLLECTION2
                Measure..      SALARY                                             Unsuccessful
                               S=DW_TARGETSCHEMA, C=EMPLOYEMENT_CUBE, M=SALARY
                               Connection lost. Reconnect                         Successful
                Dimension      DEP_DIM                                            Successful
                               S=DW_TARGETSCHEMA, D=DEP_DIM
                Dimension      EMP_DIM                                            Successful
                               S=DW_TARGETSCHEMA, D=EMP_DIM
                Dimension      JOB_DIM                                            Successful
                               S=DW_TARGETSCHEMA, D=JOB_DIM


                  ]]>
                </Check>
                - <Check key="StackTrace">
                - <![CDATA[
                ============================================================================
                Queries on the following measures or dimensions failed
                (S=Schema, C=Cube, M=Measure, D=Dimension)

                "SALARY" measure query with S=DW_TARGETSCHEMA, C=EMPLOYEMENT_CUBE, M=SALARY
                ============================================================================

                Exception stacktrace for "SALARY" measure query with S=DW_TARGETSCHEMA, C=EMPLOYEMENT_CUBE, M=SALARY
                ============================================================================
                1) BIB-9009 Oracle OLAP could not create cursor.
                oracle.express.idl.util.OlapiException: No more data to read from socket
                2) BIB-9009 Oracle OLAP could not create cursor.
                oracle.express.idl.util.OlapiException: No more data to read from socket

                1) BIB-9009 Oracle OLAP could not create cursor.
                oracle.express.idl.util.OlapiException: No more data to read from socket
                ============================================================================
                oracle.dss.dataSource.common.QueryRuntimeException: BIB-9009 Oracle OLAP could not create cursor.
                oracle.express.idl.util.OlapiException: No more data to read from socket
                java.lang.CloneNotSupportedException: BIB-9009 Oracle OLAP could not create cursor.
                oracle.express.idl.util.OlapiException: No more data to read from socket
                     at oracle.dss.dataSource.common.Query.addQueryListener(Query.java:480)
                     at BICheckConfig.runDefaultMeasureQuery(BICheckConfig.java:480)
                     at BICheckConfig.printFolder(BICheckConfig.java:405)
                     at BICheckConfig.printFolder(BICheckConfig.java:464)
                     at BICheckConfig.checkConnection(BICheckConfig.java:350)
                     at BICheckConfig.main(BICheckConfig.java:1348)

                2) BIB-9009 Oracle OLAP could not create cursor.
                oracle.express.idl.util.OlapiException: No more data to read from socket
                ============================================================================
                java.lang.CloneNotSupportedException: BIB-9009 Oracle OLAP could not create cursor.
                oracle.express.idl.util.OlapiException: No more data to read from socket
                     at oracle.dss.dataSource.common.CubeCursor.clone(CubeCursor.java:387)
                     at oracle.dss.dataSource.common.Query.addNewCubeCursorCopy(Query.java:2366)
                     at oracle.dss.dataSource.common.Query.addQueryListener(Query.java:477)
                     at BICheckConfig.runDefaultMeasureQuery(BICheckConfig.java:480)
                     at BICheckConfig.printFolder(BICheckConfig.java:405)
                     at BICheckConfig.printFolder(BICheckConfig.java:464)
                     at BICheckConfig.checkConnection(BICheckConfig.java:350)
                     at BICheckConfig.main(BICheckConfig.java:1348)



                  ]]>
                </Check>
                </BICheckConfig>




                when I was transfering the collection from warehouse builder to database I recieve some error messages.
                but when I try to connect to database from bibeans every thing was ok so I thougth maybe it is because of that.
                and that about bibdemo why it doesn't work???
                it works before and I check it with bi_checkconfig
                thanks ,
                shima