ODI-1217: Session CLOUD_CONNECTOR_INVOKE_WEB_SERVICE (5500) Fails With Return Code 7000 and CLOUD_REP-00016:Loader Error (Doc ID 2044257.1)

Last updated on AUGUST 02, 2023

Applies to:

Symptoms

Running Domain Load Plan for a new 11.1.1.10 OTBI-E install results in errors :

Error Message Details Include:

---Error Start---

Execution

Start Wednesday, August 12, 2015 12:52:45 PM GMT-06:00
End Wednesday, August 12, 2015 12:52:57 PM GMT-06:00
Duration 00:12
Status Error
Session ID 5500
No. of Rows 0
No. of Inserts 0
No. of Updates 0
No. of Deletes 0
No. of Errors 0
Return Code 7000
Error Message ODI-1217: Session CLOUD_CONNECTOR_INVOKE_WEB_SERVICE (5500) 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 12015-08-12T06:52:50-06:00STARTED00TLO_DIV_QUESTION_TYPE2015-08-12T06:52:52-06:00STARTED00TLO_JOB_LEVELCLOUD_REP-00016:Loader Errorjava.lang.Exception : ReplicateType: DATA - Error creating Error Summary Table REPL$_ERR_SUMMARY Error Message XML document structures must start and end within the same entity. BSF info: Replicate to SDS at line: 0 column: columnNo
--- Error End---

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.