My Oracle Support Banner

11g BIEE Out Of The Box OBIApps Reports In Manufacturing & Supply Chain Fail With Error: OPR4ONWY:U9IM8TAC:OI2DL65P ORA-29275: Partial Multibyte Character At OCI Call OCIStmtFetch (Doc ID 1564339.1)

Last updated on SEPTEMBER 13, 2017

Applies to:

Business Intelligence Applications Consumer - Version and later
Business Intelligence Server Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.


Some reports in Manufacturing and Supply chain are failing with the following error

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 29275, message: ORA-29275: partial multibyte character at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)

SQL Issued: SELECT 0 s_0, "Inventory - Aging"."Inventory Bucket"."Bucket Range Name" s_1, "Inventory - Aging"."Product"."Product Name" s_2, "Inventory - Aging"."Facts - Inventory Aging"."Available Amount" s_3 FROM "Inventory - Aging" WHERE (("Inventory Bucket"."Bucket Name" = 'ONHAND_AGING_TIME_BUCKET') AND ("Inventory Bucket"."Bucket Range Name" IN ('Aging 31 to 40 days', 'Aging > 40 days')) AND (TOPN("Facts - Inventory Aging"."Available Amount",20)



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

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