2 Replies Latest reply: Feb 8, 2013 8:45 AM by mgaspereyra RSS

    Issue invoking Web Service.

    mgaspereyra
      Hi All,
      I'm facing a weird issue when I'm triying to invoke a web service in a package.
      If I'm invoking this webservice from a web browser o soapUI, it works fine.
      When I put the wsdl on the OdiInvokeWebService Tool It returns to me a NullPointer error (this web service is behind our firewall, so no proxy configuration is needed).
      How can I debug / troubleshoot this issue?
      Other invocations (like BAM services) works fine.

      I'm working with ODI 11.1.1.3

      Thanks in advance!
        • 1. Re: Issue invoking Web Service.
          Alex Kotopoulis
          Hi,

          could you post the stack trace for the NullPointerException? Does this happen when you supply the WSDL URL and press the Globe&Lightning icon on the right, or are you trying to execute the Web service after providing parameters?

          Cheers,
          Alex
          • 2. Re: Issue invoking Web Service.
            mgaspereyra
            This is the stack trace:
            om.sunopsis.wsinvocation.SnpsWSInvocationException: java.lang.NullPointerException
                 at com.sunopsis.wsinvocation.client.impl.axis.AxisParserImpl.createMessage(AxisParserImpl.java:344)
                 at com.sunopsis.wsinvocation.client.impl.AbstractJWSDLParserImpl.getWebServiceRequestByOperation(AbstractJWSDLParserImpl.java:189)
                 at com.sunopsis.wsinvocation.client.impl.AbstractJWSDLParserImpl.getWebServiceRequestByOperation(AbstractJWSDLParserImpl.java:203)
                 at com.sunopsis.dwg.tools.InvokeWebService.actionExecute(InvokeWebService.java:299)
                 at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:273)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3185)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:1417)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2785)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2515)
                 at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:534)
                 at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)
                 at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:322)
                 at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:246)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:237)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:794)
                 at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)
                 at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83)
                 at java.lang.Thread.run(Thread.java:662)
            Caused by: java.lang.NullPointerException
                 at com.sunopsis.wsinvocation.client.impl.AbstractJWSDLParserImpl.parseXmlSchema(AbstractJWSDLParserImpl.java:460)
                 at com.sunopsis.wsinvocation.client.impl.AbstractJWSDLParserImpl.parseXmlSchema(AbstractJWSDLParserImpl.java:541)
                 at com.sunopsis.wsinvocation.client.impl.AbstractJWSDLParserImpl.constructPartWithWsdlSchema(AbstractJWSDLParserImpl.java:396)
                 at com.sunopsis.wsinvocation.client.impl.axis.AxisParserImpl.createMessage(AxisParserImpl.java:320)
                 at com.sunopsis.wsinvocation.client.impl.AbstractJWSDLParserImpl.getWebServiceRequestByOperation(AbstractJWSDLParserImpl.java:189)
                 at com.sunopsis.wsinvocation.client.impl.AbstractJWSDLParserImpl.getWebServiceRequestByOperation(AbstractJWSDLParserImpl.java:203)
                 at com.sunopsis.dwg.tools.InvokeWebService.actionExecute(InvokeWebService.java:299)
                 at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:273)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3185)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:1414)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2785)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2515)
                 at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:534)
                 at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)
                 at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:322)
                 at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:246)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:237)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:794)
                 at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)
                 at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
                 ... 1 more

            And yes, it happens when I press the Globe&Lightning icon on the right.