5 Replies Latest reply: Nov 16, 2012 11:33 AM by Arik RSS

    soa bpel runtime :  java.lang.NullPointerException error   ,   remoteFault

    973530
      I'm getting runtime errors after deployment on SOA EM console, When I do a "Test Web Service" from the EM console..
      got all the errors for the same SOA app , when I "Test Web Service" ...did different tests ,not at the same time...
      I've gone through the OTN forums for the similar solutions, but didn't quite get the right solution for my issue, any help is appreciated by looking at the stacktrace below...Thanks....
      I'm using JDev 11g (11.1.1.4.0)

      1st error
      ======
      Non Recoverable System Fault :
      <bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>Could not determine wsdl ports.</summary></part><part name="detail"><detail>Could not find schema from URL source, file source, classpath or application context at this lcoation: "oramds:/deployed-composites/main_flow_bpel1_rev1.0/ScoringEngineWSPort.wsdl"</detail></part><part name="code"><code>null</code></part></remoteFault></bpelFault>

      2nd error
      =====
      javax.xml.ws.soap.SOAPFaultException: Failed to invoke end component com.decc.esrd.ScoringEngineWSUser (POJO), operation=getpaymentstartdate -> Failed to invoke method -> java.sql.SQLException: ORA-06550: line 1, column 14: PLS-00201: identifier 'SCORINGENGINE.GETPAYMENTSTARTDATE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored


      3rd error
      ======
      Full StackTrace below:
      =============
      <messages><input>
      <InvokeNotificationFailure_PaymentDate_sendMECompletionNotification_InputVariable><part name="parameters" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><sendMECompletionNotification xmlns="http://cms.gov/esrd/service/v1">
      <runId xmlns="">656776</runId>
      <errorMsg xmlns="">Failed to get Payment Date</errorMsg>
      </sendMECompletionNotification></part></InvokeNotificationFailure_PaymentDate_sendMECompletionNotification_InputVariable></input><fault>
      <bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>EJB Exception: : java.lang.NullPointerException
           at gov.cms.esrd.qip.service.ScoringDAServiceSessionEJBBean.sendMECompletionNotification(ScoringDAServiceSessionEJBBean.java:1873)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
           at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
           at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
           at $Proxy202.sendMECompletionNotification(Unknown Source)
           at gov.cms.esrd.qip.service.ScoringDAServiceSessionEJB_fhsymo_WSOImpl.__WL_invoke(Unknown Source)
           at weblogic.ejb.container.internal.WSOMethodInvoker.invoke(WSOMethodInvoker.java:22)
           at gov.cms.esrd.qip.service.ScoringDAServiceSessionEJB_fhsymo_WSOImpl.__WL_sendMECompletionNotification_WS(Unknown Source)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at weblogic.wsee.server.ejb.WsEjb.invoke(WsEjb.java:54)
           at weblogic.wsee.jaxws.WLSEjbInstanceResolver$WLSEjbInvoker.invoke(WLSEjbInstanceResolver.java:192)
           at weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
           at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:151)
           at com.sun.xml.ws.server.sei.EndpointMethodHandlerImpl.invoke(EndpointMethodHandlerImpl.java:268)
           at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:100)
           at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:866)
           at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:815)
           at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:778)
           at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:680)
           at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:403)
           at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:532)
           at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:253)
           at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:140)
           at weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:171)
           at weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
           at weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
           at weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
           at weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
           at weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:98)
           at weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
           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.ServletStubImpl.execute(ServletStubImpl.java:183)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3717)
           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:207)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
      ; nested exception is: java.lang.NullPointerException</summary></part><part name="detail"><detail>javax.xml.ws.soap.SOAPFaultException: EJB Exception: : java.lang.NullPointerException
           at gov.cms.esrd.qip.service.ScoringDAServiceSessionEJBBean.sendMECompletionNotification(ScoringDAServiceSessionEJBBean.java:1873)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
           at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
           at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
           at $Proxy202.sendMECompletionNotification(Unknown Source)
           at gov.cms.esrd.qip.service.ScoringDAServiceSessionEJB_fhsymo_WSOImpl.__WL_invoke(Unknown Source)
           at weblogic.ejb.container.internal.WSOMethodInvoker.invoke(WSOMethodInvoker.java:22)
           at gov.cms.esrd.qip.service.ScoringDAServiceSessionEJB_fhsymo_WSOImpl.__WL_sendMECompletionNotification_WS(Unknown Source)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at weblogic.wsee.server.ejb.WsEjb.invoke(WsEjb.java:54)
           at weblogic.wsee.jaxws.WLSEjbInstanceResolver$WLSEjbInvoker.invoke(WLSEjbInstanceResolver.java:192)
           at weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
           at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:151)
           at com.sun.xml.ws.server.sei.EndpointMethodHandlerImpl.invoke(EndpointMethodHandlerImpl.java:268)
           at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:100)
           at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:866)
           at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:815)
           at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:778)
           at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:680)
           at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:403)
           at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:532)
           at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:253)
           at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:140)
           at weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:171)
           at weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
           at weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
           at weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
           at weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
           at weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:98)
           at weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
           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.ServletStubImpl.execute(ServletStubImpl.java:183)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3717)
           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:207)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
      ; nested exception is: java.lang.NullPointerException</detail></part><part name="code"><code>S:Server</code></part></remoteFault></bpelFault></fault><faultType>
      <message>0</message></faultType></messages>
        • 1. Re: soa bpel runtime :  java.lang.NullPointerException error   ,   remoteFault
          Arik
          Hi,

          Looks like a problem with the definition of your DB adapter and DB object itself.
          Verify few things:
          1. From the DB wizard that you do see the correct action required.
          2. The DB object was not changed after the deployment.
          3. If the DB object was changed, you will have to rest the datasource or update the JNDI connection pool from WL console.


          Arik
          • 2. Re: soa bpel runtime :  java.lang.NullPointerException error   ,   remoteFault
            973530
            Hi Arik,
            I'm not using Database Adapter in my SOA composite. Only External Web Service References. Any other suggestions anyone have ?
            Thanks.

            These are the errors I'm getting when I test web service
            on EM console

            1) Non Recoverable System Fault :
            <bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>Could not determine wsdl ports.</summary></part><part name="detail"><detail>Could not find schema from URL source, file source, classpath or application context at this lcoation: "oramds:/deployed-composites/main_flow_bpel1_rev1.1/ScoringDAService.wsdl"</detail></part><part name="code"><code>null</code></part></remoteFault></bpelFault>

            2) Non Recoverable System Fault :
            Could not determine wsdl ports.

            3) Non Recoverable System Fault :
            javax.xml.ws.soap.SOAPFaultException: Failed to invoke end component com.decc.esrd.ScoringEngineWSUser (POJO), operation=getpaymentstartdate -> Failed to invoke method -> java.sql.SQLException: ORA-06550: line 1, column 14: PLS-00201: identifier 'SCORINGENGINE.GETPAYMENTSTARTDATE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
            • 3. Re: soa bpel runtime :  java.lang.NullPointerException error   ,   remoteFault
              Arik
              PLS-00201: identifier 'SCORINGENGINE.GETPAYMENTSTARTDATE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
              Still...it is probably a DB problem ('SCORINGENGINE.GETPAYMENTSTARTDATE iis a function or procedure that does not exist in the DB and it is being call from another DB object).
              If you are calling a WS, then there might be a call to a DB object from there.
              Please check this possibility.

              Arik
              • 4. Re: soa bpel runtime :  java.lang.NullPointerException error   ,   remoteFault
                973530
                Yes, it is a call to the database object from webservice. Actually , database Package is published as a web service and that package has different functions and procedures inside.
                So this whole project is deployed to weblogic as a web application and I get the wsdl from there.

                This web project has web.xml where JNDI name (datasource) is defined under "References -> Resource References
                as a type "javax.sql.DataSource"
                I'm not sure if that's where the problem is ? Also defined the datasource on weblogic console with the same JNDI as the web.xml file.

                Database package is there in the database which has all these procedures/functions. It does exist but I'm not sure if web.xml is the right place to define jndi (datasource) , so maybe it's not hitting the database to connect to ?

                Failed to invoke method -> java.sql.SQLException: ORA-06550
                just strange..
                • 5. Re: soa bpel runtime :  java.lang.NullPointerException error   ,   remoteFault
                  Arik
                  This error doesn't point on a bad jndi name or problem with establishing a connection.
                  It says, that a certain function/procedure does not exist. The service can know this only because it established a connection, and couldn't fully execute the operation.
                  Check that you can run the main DB procedure/function (the one that is being called from your application) from the DB itself.
                  Also, maybe you are pointing to a wrong DB?

                  Arik