Related content:

Question

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

Question

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

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

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

Question

2
Replies
298
Views
Close popover
Madhusudan Sharma (MadhusudanS9253)
Ness Technologies

Ness Technologies
IN
View Profile
MadhusudanS9253 Member since 2015 32 posts
Ness Technologies
Posted: February 28, 2017
Last activity: June 29, 2017
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
Close popover
Moderation Team has archived post

Accepted Solution

Posted: 3 years ago
Close popover
Shanthini Charles (Shanthini_Charles)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
IN
View Profile

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
Share this page Share via LinkedIn Copying...
Copied!