E1: ESU: When Running UN2, Install Fails for all Environments with Error "NoSuchMethodError: oracle.i18n.text.converter.CharacterConverter.toOracleStringWithReplacement([CI[BI[I)[B"

(Doc ID 2406219.1)

Last updated on JUNE 07, 2018

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On :  9.2 version, Install/Change Mgmt - Software Updates & Package Mgmt

TR: 9.2.2.4
Oracle Database: 12.2.x

Environment: DV920

When attempting to apply the UN2 while running one of the reports R98403XB, the following error occurs.

ERROR
-----------------------
0512/6912 WRK:Starting jdeCallObject         Tue May 15 22:13:38.956002 jdb_exet.c10746
JDB9900428 - A java exception occured during copying xml to table.

10512/6912 WRK:Starting jdeCallObject         Tue May 15 22:13:38.956003 B98403X.c595
JDB_CopyXMLToTable failed - GT92002

10512/6912 WRK:Starting jdeCallObject         Tue May 15 22:13:42.612000 JdeJvmWrapper.cpp374
JdeJvm::CheckForExceptions() - Java Exception encountered : java.lang.Exception: JDBException occured.

10512/6912 WRK:Starting jdeCallObject         Tue May 15 22:13:42.612001 JdeJvmWrapper.cpp374
JdeJvm::CheckForExceptions() - Stack Trace for Exception : java.lang.Exception: JDBException occured.

at oracle.e1.database.copytablexml.BaseCopyTableXML.singleDBInsert(Unknown Source)

at oracle.e1.database.copytablexml.BaseCopyTableXML.extractXMLToTable(Unknown Source)

Caused by: com.jdedwards.database.base.JDBException: [RETRYABLE_OPERATION_FAILED] Retryable operation failed.

at com.jdedwards.database.impl.retry.JDBRetryAccess.select(Unknown Source)

at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)

at com.jdedwards.database.impl.standalone.JDBStandaloneTransformAccess.select(Unknown Source)

at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)

at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)

at com.jdedwards.database.impl.usage.JDBUsageTrackingAccess.select(Unknown Source)

at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)

... 2 more

Caused by: com.jdedwards.base.util.RetryException: oracle.i18n.text.converter.CharacterConverter.toOracleStringWithReplacement([CI[BI[I)[B

at com.jdedwards.base.util.Retryer.retry(Unknown Source)

... 9 more

Caused by: java.lang.NoSuchMethodError: oracle.i18n.text.converter.CharacterConverter.toOracleStringWithReplacement([CI[BI[I)[B

at oracle.sql.converter.I18CharacterConvertersWrapper.toOracleStringWithReplacement(I18CharacterConvertersWrapper.java:107)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. apply the UN2 on DV920
2. report R98403XB fails with "Copy failed" error.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply UN2.

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