IBM Support

DataStage Web Services stage fails with Service invocation exception and NullPointerException

Troubleshooting


Problem

DataStage Web Services stage fails with Service invocation exception and NullPointerException similar to this: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1602) at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1544) at com.ascentialsoftware.wspack.Transformer.process(Transformer.java:105) at com.ascentialsoftware.jds.StageFactory.runStage(StageFactory.java:544) at com.ascentialsoftware.jds.StageFactory.runSource(StageFactory.java:335) Caused by: java.lang.NullPointerException at com.ascentialsoftware.wsclient.xml.DerivationParser.match(DerivationParser.java:622) at com.ascentialsoftware.wsclient.xml.DerivationParser.element(DerivationParser.java:367) at com.ascentialsoftware.wsclient.xml.DerivationParser.segment(DerivationParser.java:271) at com.ascentialsoftware.wsclient.xml.DerivationParser.segment(DerivationParser.java:293) at com.ascentialsoftware.wsclient.xml.DerivationParser.segment(DerivationParser.java:208) at com.ascentialsoftware.wsclient.xml.DerivationParser.expr(DerivationParser.java:171) at com.ascentialsoftware.wsclient.xml.DerivationParser.parse(DerivationParser.java:138) at com.ascentialsoftware.wsclient.xml.TreeBuilder.compileRules(TreeBuilder.java:84) at com.ascentialsoftware.wsclient.MappingHandler.fromArray(MappingHandler.java:304) at com.ascentialsoftware.wsclient.InputRequest.buildRequestBodyDocument(InputRequest.java:908) at com.ascentialsoftware.wsclient.WebService.callServiceInternal(WebService.java:1625) at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1591) ... 4 more

Cause

This has been identified as a product defect under APAR JR45664, where the table definitions created by importing the WSDL for the service results in incomplete column definitions.

Resolving The Problem

Obtain and install the client-side patch for JR45664, and recreate the table definitions used by the stage be re-importing the WSDL for the web service.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF027","label":"Solaris"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"8.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21647640