Load Plan Failed With Error TargetError : At Line: 248 (Doc ID 2136316.1)

Last updated on JUNE 06, 2017

Applies to:

Oracle Transactional Business Intelligence Enterprise for Human Capital Management Cloud Service - Version 11.1.9.2.0 to 11.12.1.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

Problem Description
---------------------------------------------------

Executed a load plan to load incremental data into PeopleSoft. The load plan fails with the error:
Session CLOUD_CONNECTOR_INVOKE_WEB_SERVICE (5355503) fails with return code 7000.
TargetError : at Line: 248 : in file: inline evaluation of: ``import java.sql.Statement///

Please find the load plan details below. Please work with Cloud Ops to get the Cloud Connector logs and the session logs from ODI for Session ID: 5355503. Load Plan details below:

Instance ID 22503
Load Plan Execution Name PeopleSoft Load_25_20160415_111014
Run # 1
Load Plan Name PeopleSoft Load_25_20160415_111014
Started By CIGNA-TEST_ANALYTICS_BIAPPS_APPID
Physical Agent OracleDIAgent
Context Global
Start Saturday, May 7, 2016 1:06:41 AM GMT+00:00
End Saturday, May 7, 2016 1:11:20 AM GMT+00:00

Detailed Error

==============

 

<Field name="ErrorMessage" type="java.lang.String"><![CDATA[ODI-1217: Session CLOUD_CONNECTOR_INVOKE_WEB_SERVICE (5355503) 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: 248 : 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><JobId>281</JobId><StartTime>2016-05-07T01:11:05Z</StartTime><Status>STARTED</Status><JobStatus><EndTime>2016-05-07T01:11:09Z</EndTime><ExtractorDuration>0</ExtractorDuration><LoaderDuration>0</LoaderDuration><Name>PS_GP_COUNTRY</Name><Errors><ErrorCode>CLOUD_REP-00016:Loader Error</ErrorCode><Message>java.lang.Exception :  ReplicateType: DATA - Error Loading PS_GP_COUNTRYERROR: Loading Table C$_1318884828_281 from buffer .Error while preparing SQL statement..CSVParseError colTokenCount mismatch, expected=1, parsed=0 for row:
.
Error Message
An invalid XML character (Unicode: 0x10) was found in the element content of the document.
BSF info: Replicate to SDS at line: 0 column: columnNo
.
BIAPPS.DATASOURCE_NUM_ID=1002
BIAPPS.INITIAL_EXTRACT_DATE=1970-01-01 00:00:00
BIAPPS.PRODUCT_LINE_VERSION_CODE=PSFT_9_2

><ExtractorDuration>0</ExtractorDuration><LoaderDuration>0</LoaderDuration><Name>PS_GP_COUNTRY</Name><Errors><ErrorCode>CLOUD_REP-00016:Loader Error</ErrorCode><Message>java.lang.Exception :  ReplicateType: DATA - Error Loading PS_GP_COUNTRYERROR: Loading Table C$_1318884828_281


==Target exception: java.lang.Exception: Custom Exception -- Exception occurred while parsing xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Job><JobId>281</JobId><StartTime>2016-05-07T01:11:05Z</StartTime><Status>STARTED</Status><JobStatus><EndTime>2016-05-07T01:11:09Z</EndTime><ExtractorDuration>0</ExtractorDuration><LoaderDuration>0</LoaderDuration><Name>PS_GP_COUNTRY</Name><Errors><ErrorCode>CLOUD_REP-00016:Loader Error</ErrorCode><Message>java.lang.Exception :  ReplicateType: DATA - Error Loading PS_GP_COUNTRYERROR: Loading Table C$_1318884828_281 from buffer .Error while preparing SQL statement..CSVParseError colTokenCount mismatch, expected=1, parsed=0 for row:
.
.
Error Message
An invalid XML character (Unicode: 0x10) was found in the element content of the document.

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