BIP Report Error : The Report Cannot Be Rendered Because Of An Error, Please Contact The Administrator.

(Doc ID 2354353.1)

Last updated on JANUARY 29, 2018

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Analytics

Customer is running BI Publisher report , but cannot be rendered because of an error

ERROR
-----------------------
Error
The report cannot be rendered because of an error, please contact the administrator.

Error Detail

oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 6694, maximum: 4000)

 

Report Datamodel SQL
=========
select cast(b.OPTY_ID as INT) "OPTY_ID", b.NAME,b.OPTY_NUMBER, b.STATUS_CATEGORY,b.SALES_METHOD_ID,OWNER_RESOURCE_ID, n.NOTE_ID, n.NOTE_NUMBER, n.CORP_CURRENCY_CODE, n.CURCY_CONV_RATE_TYPE, n.CURRENCY_CODE, n.NOTE_TYPE_CODE,CAST(n.NOTE_TXT as VARCHAR(1500)) AS "note_text", n.SOURCE_OBJECT_CODE, n.SOURCE_OBJECT_UID, n.VISIBILITY_CODE, n.CONFLICT_ID, n.CREATOR_PARTY_ID,n.CONTACT_RELATIONSHIP_ID from ZMM_NOTES n,MOO_OPTY b where b.OPTY_ID = n.SOURCE_OBJECT_UID

=======
Version: Oracle BI Publisher 11.1.1.9.0 (build:20171011.0105)
=======

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run BIP report

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run BIP report

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