Support Article
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conv
SA-41263
Summary
There is a property which can contain more than 4000 characters of data. Report Definition on this table throwing error.
Error Messages
An error occurred on executing the query for the report definition - There was a problem getting a list: code: 22835 SQLState: 99999 Message: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 13146, maximum: 4000
Steps to Reproduce
1) Create a Report Definition
2) Refer property (column : CLOB)
3) Run the report
Root Cause
A defect or configuration issue in the operating environment. There is a database limitation of 4000 bytes in a varchar2 column. For > 4000 a CLOB column should be used but support for a CLOB was not available until Pega 7.2.2.
Resolution
Support for CLOB in Obj-Save and to retrieve the entire CLOB content in a report definition was backported to 7.1.9.
1. Apply HFix-33613 to be able to use Obj-Save for a text property that maps to a CLOB column
2. Apply HFix-35993 and create the following dynamic system setting to be able to retrieve a CLOB column greater than 4000 characters in length.
"reporting/retrieveFullClobContent" on "Pega-RULES" and set the value to "true"
Published August 26, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.