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 APRIL 11, 2016

Applies to:

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

Symptoms

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

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
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)

 

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