This discussion is archived
5 Replies Latest reply: Nov 16, 2012 9:33 AM by Arik RSS

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

973530 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points