ARM Data Load Failing - Unable to perform data load. A service error has occurred Check the execution logs in the Oracle Data Integrator Studio Operator tab (Doc ID 2649527.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Symptoms

 ARM data loads are failing.  Logs show:

<?xml version = '1.0' encoding = 'UTF-8'?>
<Errors>
<Error>
<Row>N/A</Row>
<ColumnName>N/A</ColumnName>
<Message>Unable to perform data load. A service error has occurred. Check the execution logs in the Oracle Data Integrator Studio Operator tab.</Message>
</Error>
</Errors>

[2020-03-10T11:52:48.426-07:00] [FinancialClose0] [ERROR] [] [oracle.apps.epm.arm.model] [tid: 14] [userId: admin] [ecid: 0000N35mSjc7U81Lzuc9yW1UPxzZ00000G,0] [APP: ACCOUNTRECONCILIATION#11.1.2.0] [SRC_CLASS: oracle.apps.epm.arm.model.applicationModule.manager.dataload.DataloadPhase] [SRC_METHOD: _runDataload] ODI scenario failed with following error: Session Failed :4506011501 : ODI-1217: Session EXPORTTOARM (4506011501) fails with return code 7000.[[
ODI-1226: Step Export Not OK Error fails after 1 attempt(s).
ODI-1232: Procedure Export Not OK Error execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
SyntaxError: ("no viable alternative at input '='", ('<string>', 12, 6, 'result=sqlstring.executeUpdate(sqlstmt)\n'))

Cause

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