My Oracle Support Banner

"SQL*Loader-266: Unable to locate character set handle for xxxxx" Error Loading SAP Data with ODI (Doc ID 1384769.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms

Loading data from SAP using LKM SAP ERP to Oracle, the Interface fails at ' Load Data to Staging' step with the error below:

org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 13, in <module>
Load Error: See D:\SAPSHARED\\ZODI_xxxx_xxxx_DEV.log for details

at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:346)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)


ZODI_xxxx_xxxx_DEV.log file contains following error:

SQL*Loader: Release 10.2.0.1.0 - Production on Tue Nov 29 14:09:59 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL*Loader-266: Unable to locate character set handle for ISO8859_1.

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


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