Support Article
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW
SA-64844
Summary
In Pega 7.3.1, ORA-22835 error occurs during offline application packaging.
For more information, refer to the SA: https://community.pega.com/support/support-articles/ora-22835-buffer-too-small-clob
Error Messages
Error: ** An error occured 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: 16666, maximum: 4000) DatabaseException caused by prior exception: java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 16666, maximum: 4000) | SQL Code: 22835 | SQL State: 99999
Steps to Reproduce
Perform offline application packaging.
Root Cause
A defect or configuration issue in the operating environment.
Resolution
Perform the following local-change:
- Create the below Dynamic System Settings (DSS) on Pega-RULES.
reporting/retrieveFullClobContent
- Set the value to true
Published October 28, 2018 - 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.