Support Article
Error ORA-22835 when executing a query for Report Definition
SA-45759
Summary
ORA-22835 error occurs when executing a query for a Report Definition.
Error Messages
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
- Create a Report Definition
- Refer a property (Column: CLOB).
- Run the report.
Root Cause
A defect or configuration issue in the operating environment.
A database is limited to 4000 bytes in a VARCHAR2 column. When the property value length is greater than 4000, a CLOB column must be used. However, support for a CLOB was not available until Pega 7.2.2.
Resolution
Perform the following local-change:
- Set the reporting/retrieveFullClobContent Dynamic System Setting (DSS) defined on Pega-RULES to True.
- Install HFix-37641.
- Restart the server.
ERROR - Not returning connection 8 for database "pegadata" to the pool as it previously encountered the following error
(rd.queryexec.SqlQueryExecutor) ERROR - An error occured on executing the query for the report definition - There was a problem getting a list: code: 932 SQLState: 42000 Message: ORA-00932: inconsistent datatypes: expected - got CLOB
Published March 8, 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.