Question

2
Replies
490
Views
 Madhusudan Sharma (MadhusudanS9253)
EPAM Systems

EPAM Systems
IN
MadhusudanS9253 Member since 2015 36 posts
EPAM Systems
Posted: February 28, 2017
Last activity: June 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***

User Experience
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.

Accepted Solution

Posted: 4 years ago
Posted: 28 Feb 2017 3:38 EST
Shanthini Charles (Shanthini_Charles)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
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

Related content:

Question

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

Question Solved

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

Question

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

Question Solved

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

Question

Tried RDB-Delete for Pega Internal Table -- There was a problem getting a list: code: 0 SQLState: 42601 Message: ERROR: syntax error at or near "*" Position: 8

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

Discussion

There was a problem getting a list: code: -206 SQLState: 42703 Message: PXCOVERINSKEY IS NOT VALID IN THE CONTEXT WHERE IT IS USE

Question Solved

There was a database problem when performing an RDBExecute: code: 0 SQLState: <none> Message: No value has been inserted

Question

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

Question

There was a problem getting a list: code: 6550 SQLState: 65000 Message: ORA-06550: line 1, column 7: PLS-00201: identifier 'TESTPROCEDURE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored