Mapping Execution Scheduled with ODI Colocated Agent in BICS Fails with "ODI-30164: Rest invocation failed with error"

(Doc ID 2363935.1)

Last updated on FEBRUARY 26, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 and later
Oracle Business Intelligence Cloud Service - Version 17.4.5 and later
Information in this document applies to any platform.

Symptoms

Execution of an Oracle Data Integrator 12c (ODI) mapping using a colocated standalone agent to load data into Oracle Business Intelligence Cloud Service (BICS) fails with the following error:

ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Groovy: oracle.odi.runtime.rest.SnpsRSInvocationException: ODI-30164: Rest invocation failed with error. URL : https://hostname.domain/dataload/v1/tables/DIVISION/data
  at org.codehaus.groovy.bsf.GroovyEngine.exec(GroovyEngine.java:114)
  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:396)
  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:247)
  at oracle.odi.runtime.agent.execution.interpreter.SessionTaskScriptingInterpretor.scripting(SessionTaskScriptingInterpretor.java:190)
  at oracle.odi.runtime.agent.execution.SessionTask.scripting(SessionTask.java:105)
  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:49)
  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:21)
  at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
  at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
  at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
  at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
  at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:917)
  at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
  at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)
Caused by: oracle.odi.runtime.rest.SnpsRSInvocationException:ODI-30164: Rest invocation failed with error. URL : https://hostname.domain/dataload/v1/tables/DIVISION/data
  at com.sunopsis.dwg.tools.InvokeRESTfulService.throwAndLogInvocationException(InvokeRESTfulService.java:1894)
  at com.sunopsis.dwg.tools.InvokeRESTfulService.actionExecute(InvokeRESTfulService.java:537)
  at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:235)
  at com.sunopsis.dwg.function.SnpsFunction$execute$0.call(Unknown Source)
  at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall

The same mapping can be executed successfully if run with the "Local (No Agent)"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms