My Oracle Support Banner

OBIA 11g: Recruitment Load Plan Failing At CLOUD_CONNECTOR_INVOKE_WEB_SERVICE (Doc ID 2683129.1)

Last updated on JUNE 22, 2020

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

The recruitment load plan for a TALEO 19B source fails at CLOUD_CONNECTOR_INVOKE_WEB_SERVICE with the following error but after restart, the Load Plan is working fine.

[2020-06-01T12:35:18.843+00:00] [odi_server1] [ERROR] [ODI-1134] [] [tid: 356] [userId: <anonymous>] [ecid: 0000N9jsEOH1nZp5SRp2ic1UpFKA00000G,0] [APP: oraclediagent] Agent OracleDIAgent encountered an error: ODI-1217: Session CLOUD_CONNECTOR_INVOKE_WEB_SERVICE (2247884600) fails with return code 7000. Caused by: ODI-1226: Step Cloud Connector Invoke Web Service fails after 1 attempt(s).[[
ODI-1217: Session CLOUD_CONNECTOR_INVOKE_WEB_SERVICE (2247884600) fails with return code 7000.
ODI-1226: Step Cloud Connector Invoke Web Service fails after 1 attempt(s).
ODI-1232: Procedure Cloud Connector Invoke Web Service execution fails.
Caused By: org.apache.bsf.BSFException: The application script threw an exception: TargetError : at Line: 246 : in file: inline evaluation of: ''import java.sql.Statement; import java.sql.PreparedStatement; import java.sql.Re . . . '' : throw vtmParseErr ;

Target exception: java.lang.Exception: Custom Exception -- Exception occurred while parsing xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Job><EndTime>2020-06-01T12:35:17Z</EndTime><JobId>11292</JobId><StartTime>2020-06-01T12:35:15Z</StartTime><Status>FAILED</Status><JobStatus><EndTime>2020-06-01T12:35:17Z</EndTime><ExtractorDuration>0</ExtractorDuration><LoaderDuration>0</LoaderDuration><Name>TLO_APPLICATION</Name><Errors><ErrorCode>CLOUD_REP-00005:Internal Error</ErrorCode></Errors><StartTime>2020-06-01T12:35:16Z</StartTime><Status>FAILED</Status></JobStatus></Job>
Error Message
Attempt to invoke method getTextContent on null value
BSF info: Replicate to SDS at line: 0 column: columnNo
at bsh.util.BeanShellBSFEngine.eval(Unknown Source)
at bsh.util.BeanShellBSFEngine.exec(Unknown Source)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)
at java.lang.Thread.run(Thread.java:745)

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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