Webservice on ICS is Not Getting Invoked by ODI 12c Due to Special Characters in Request (Doc ID 2498503.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

The following error is received by Oracle Data Integrator (ODI) 12c when invoking a Webservice hosted on Integration Cloud Service (ICS), using the OdiInvokeWebService command:

ODI-1226: Step <INVOKE_WEBSERVICE_STEPNAME> fails after 1 attempt(s).
ODI-1232: Procedure <INVOKE_WEBSERVICE_PROCEDURENAME> execution fails.
Caused By: com.sunopsis.wsinvocation.SnpsWSInvocationException: ODI-30000: Error while parsing request file.
  at com.sunopsis.dwg.tools.InvokeWebService.actionExecute(InvokeWebService.java:410)
  at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:235)
  at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:902)
  at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:583)
  at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
  at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:18)
  at oracle.odi.runtime.agent.execution.Executor.performAction(Executor.java:449)
  at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:334)
  at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:51)
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
  at ...
Caused by: oracle.xml.parser.v2.XMLParseException; lineNumber: 12; columnNumber: 49; Expected name instead of .
  at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:326)
  at oracle.xml.parser.v2.XMLReader.scanNameChars(XMLReader.java:1313)
  at oracle.xml.parser.v2.XMLReader.scanQName(XMLReader.java:2211)
  at oracle.xml.parser.v2.XMLReader.getEntity(XMLReader.java:2668)
  at oracle.xml.parser.v2.NonValidatingParser.parseContentEntityRef(NonValidatingParser.java:2060)
  at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1688)
  at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:471)
  at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:417)
  at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:251)
  at oracle.xml.jaxp.JXDocumentBuilder.parse(JXDocumentBuilder.java:175)
  at oracle.xml.jaxp.JXDocumentBuilder.parse(JXDocumentBuilder.java:131)
  at com.sunopsis.dwg.tools.InvokeWebService.actionExecute(InvokeWebService.java:405)
  ... 22 more

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.