Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Madhusudan Sharma (MadhusudanS9253) Coforge DPA private limited Technical Architect
Coforge DPA private limited
AU
MadhusudanS9253 Member since 2015 38 posts
Coforge DPA private limited
Posted: Feb 28, 2017
Last activity: Jun 29, 2017
Posted: 28 Feb 2017 3:08 EST
Last activity: 29 Jun 2017 11:16 EDT
Closed
Solved

getting here was a problem getting a list: code: 22835 SQLState: 99999 while running Report definition

Hi,

I am getting "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: 6240, maximum: 4000) " error while running the RD. although when I run the same query with the RDB-open it works fine. Can anyone please help me.

Thanks,

Madhu

***Moderator Edit: Vidyaranjan | Updated Categories***

To see attachments, please log in.
User Experience

Accepted Solution

Posted: 7 years ago
Posted: 28 Feb 2017 3:38 EST
Shanthini Charles (ShanthiniC) Techmahindra
Techmahindra
IN

Hi Madhu,

The error is because your trying to display some property whose size is more than 4000 bytes to char which is not possible.

On that property use some function to truncate some amount of data and display.

For example you can use substring to get the first 4000 characters.

Regards,

Shanthini Charles

To see attachments, please log in.

Related content:

Question

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState:

Question Solved

Pega 8.7.1 - There was a problem getting a list: code: 0 SQLState: HY008

Discussion

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState: 0A0

Question

SQL Error code: 29540 SQLState: 99999 while running the Report definition with unexposed column

Question

SQL error in ListView: There was a problem getting a list: code: 0 SQLState: 42601 message

Question Solved

There was a problem getting a list: code: 6576 SQLState: 65000 Message: ORA-06576: not a valid function or procedure name

Question

Problem writing an instance to the database: code: -302 SQLState: 22001

Question

Pega 73 Upgrade Error - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PXSAVEDATETIME": invalid identifier

Question

There was a problem getting a list: code: 1461 SQLState: 72000 Message: ORA-01461: can bind a LONG value only for insert into a LONG column

Question Solved

Error while getting the list of checkedout rules: code: -1 SQLState: -1 Message: Database-TableWithNoColumns

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice