My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2021

Applies to:

Oracle Fusion CX Sales Cloud Service - Version 11.13.20.07.0 and later
Information in this document applies to any platform.

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

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
Changes
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.