Error in JWP-IDX log: DB-Error: '99999', 'ORA-29275: partial multibyte character
Article ID: 423825
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
During the update of the Lucene index an error comparable to the below, appears in the JWP IDX log every 10 seconds:
20251210/155621.225 - 34 U00003590 UCUDB - DB-Fehler: '99999', 'ORA-29275: partial multibyte character
20251210/155621.225 - 34 ', '29275', 'java.sql.SQLException'
20251210/155621.225 - 34 SQL Statement which caused this DB error:
20251210/155621.225 - 34 U02012075 Setze Bindparameter '1' vom Typ 'Integer' auf den Wert '5'.
<...>
20251210/155621.237 - 34 U02012075 Setze Bindparameter '831' vom Typ 'Integer' auf den Wert '9208394'.
20251210/155621.237 - 34 SELECT OVD_OH_Idnr, OVD_Type, OVW_VValue, OVW_Value1, OVW_Value2, OVW_Value3, OVW_Value4, OVW_Value5 FROM OVD LEFT JOIN OVW ON OVW.OVW_OH_Idnr = OVD.OVD_OH_Idnr WHERE OVD_OH_Idnr IN (?,?,?
<...>
,?,?,?)
20251210/155621.238 - 34 Last lucene commits were rolled back!
Cause
This occurs due to a mismatch in character set encoding after the DB migration to UTF-8 and update to v24.
Resolution
Workaround:
Run a db=4 trace to find the object that blocks the update and analyze it:
The query that reads the information used to update the Lucene index, starts with a select on table OVD followed by a number of READ blocks as can be seen below.
The OVD_OH_IDNR in the last read block before the ORA-29275 error, refers to the corrupt object.
Find the object with that OH_Idnr and delete or correct it.
20251219/155844.514 - 32 SELECT OVD_OH_Idnr, OVD_Type, OVW_VValue, OVW_Value1, OVW_Value2, OVW_Value3, OVW_Value4, OVW_Value5 FROM OVD LEFT JOIN OVW ON OVW.OVW_OH_Idnr = OVD.OVD_OH_Idnr WHERE OVD_OH_Idnr IN (?,?,?,
<...>
,?,?,?)
20251219/155844.523 - 32 UCUDB32 SLCT RET 0000 HSTMT: 0000000000000158 VALUE: 0000000000000000 ALL: 0.00900 DB: 0.00000 ODBC: 0.00000 UDB: 0.00000
20251219/155844.523 - 32 UCUDB32 READ RET 0000 HSTMT: 0000000000000158 VALUE: 0000000000000001 ALL: 0.00000 DB: 0.00000 ODBC: 0.00000 UDB: 0.00000
<...>
20251219/155844.523 - 32 UCUDB32 READ RET 0000 HSTMT: 0000000000000158 VALUE: 0000000000000001 ALL: 0.00000 DB: 0.00000 ODBC: 0.00000 UDB: 0.00000
<...>
<...>
20251219/155844.676 - 32 UCUDB32 READ RET 0000 HSTMT: 0000000000000158 VALUE: 0000000000000001 ALL: 0.00000 DB: 0.00000 ODBC: 0.00000 UDB: 0.00000
20251219/155844.676 - 32 U00009909 TRACE:(DB-DATEN: OVD_OH_IDNR) size 000007
20251219/155844.676 - 32 00000000 33383730 303033 >3870003<
20251219/155844.676 - 32 U00009909 TRACE:(DB-DATEN: OVD_TYPE) size 000001
20251219/155844.676 - 32 00000000 43 >C<
20251219/155844.676 - 32 U00009909 TRACE:(DB-DATEN: OVW_VVALUE) size 000003
20251219/155844.676 - 32 00000000 EFBFBD >...<
20251219/155844.676 - 32 U00009909 TRACE:(DB-DATEN: OVW_VALUE1) size 000024
20251219/155844.676 - 32 00000000 6F726163 6C652E73 716C2E43 4C4F4240 >oracle.sql.CLOB@<
20251219/155844.676 - 32 00000010 35353865 63376564 >558ec7ed<
20251219/155844.676 - 32 U00009909 TRACE:(DB-DATEN: OVW_VALUE2) size 000024
20251219/155844.676 - 32 00000000 6F726163 6C652E73 716C2E43 4C4F4240 >oracle.sql.CLOB@<
20251219/155844.676 - 32 00000010 33636335 65663530 >3cc5ef50<
20251219/155844.676 - 32 U00009909 TRACE:(DB-DATEN: OVW_VALUE3) size 000000
20251219/155844.676 - 32
20251219/155844.676 - 32 >(null)<
20251219/155844.676 - 32 U00009909 TRACE:(DB-DATEN: OVW_VALUE4) size 000000
20251219/155844.676 - 32
20251219/155844.676 - 32 >(null)<
20251219/155844.676 - 32 U00009909 TRACE:(DB-DATEN: OVW_VALUE5) size 000000
20251219/155844.676 - 32
20251219/155844.676 - 32 >(null)<
20251219/155844.678 - 32 UCUDB32 CLST RET 0000 HSTMT: 0000000000000158 VALUE: 0000000000000000
20251219/155844.678 - 32 U00003590 UCUDB - DB-Fehler: '99999', 'ORA-29275: partial multibyte character
20251219/155844.678 - 32 ', '29275', 'java.sql.SQLException'
20251219/155844.678 - 32 SQL Statement which caused this DB error:
Feedback
Yes
No
Powered by
