BICC Extraction Error ORA-29275: partial multibyte character (Doc ID 2746094.1)

Last updated on NOVEMBER 27, 2023

Applies to:

Symptoms

 On : 11.13.20.07.0 version, Analytics

Customer is getting error when running BICC extract, BICC didn't download all transactions of payment batch created by the users.

ERROR
-----------------------

{"statuses":[{"name":"FscmTopModelAM.TransactionDFFBIAM.FLEX_BI_TransactionDFF_VI","code":"FscmTopModelAM.TransactionDFFBIAM.FLEX_BI_TransactionDFF_VI","status":"FAILURE","errorMessage":"or
acle.obiacm.dataExtract.DataExtractException: FscmTopModelAM.TransactionDFFBIAM.FLEX_BI_TransactionDFF_VI - Error read results - Error while fetching rows from server: java.io.IOException:
fetch failed[nQSError: 43113] Message returned from OBIS.\n[nQSError: 43119] Query Failed: \n[nQSError: 17001] Oracle Error code: 29275, message: ORA-29275: partial multibyte character\n at
OCI call OCIStmtFetch.\n[nQSError: 17012] Bulk fetch failed.\n\tat oracle.obiacm.utils.WriterUtils.readResults(WriterUtils.java:316)\n\tat oracle.obiacm.utils.WriterUtils.extractConcurrent
(WriterUtils.java:215)\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.extractConcurrent(BIVOExtractTask.java:725)\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.extractData(BIVOExtractTas
k.java:639)\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:299)\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:25
3)\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:135)\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.doRun(BIVOExtractTask.java:104)\n\tat oracle.obiac
m.dataExtract.AbstractCancellableTask.run(AbstractCancellableTask.java:37)\n\tat weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)\n\tat weblogic.work.Execut
eThread.execute(ExecuteThread.java:378)\n\tat weblogic.work.ExecuteThread.run(ExecuteThread.java:307)\nCaused by: java.sql.SQLException: Error while fetching rows from server: java.io.IOExc

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Run BICC extract, partial manifest file is created

2. After relaunching the job, this partial manifest file was worked upon

3. json log shows above error "partial multibyte error"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Customer cannot provide data for invoicing partner.

Changes

Cause

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