Question

4
Replies
435
Views
 Reco D (RecoD)
Turkiye Finans

Turkiye Finans
TR
RecoD Member since 2016 17 posts
Turkiye Finans
Posted: June 12, 2019
Last activity: June 13, 2019
Posted: 12 Jun 2019 7:19 EDT
Last activity: 13 Jun 2019 1:04 EDT
Closed

ORA-24345: A Truncation or null fetch error occurred in report definition

Hi All,

I have a text value property. It is greater than 4000 characters. I want to show this text value on the report definition but I get this error message "An error occured on executing the query for the report definition - There was a database problem when performing an RDBExecute: code: 24345 SQLState: 99999 Message: ORA-24345: A Truncation or null fetch error occurred ".

Could you help me? please.

Low-Code App Development Reporting
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.
Posted: 2 years ago
Posted: 12 Jun 2019 9:24 EDT
Laurence Brannigan (LaurenceB_GCS)
PEGA
Senior Software Solutions Engineer
PEG
GB

I assume it's a non exposed column and it's probably using the PR_READ_FROM_STREAM to try to retrieve the value from the blob.


But the PR_READ_FROM_STREAM is only designed to return a varchar2. And the upper limit of varchar2 is 4000 which probably explain why you're getting the ORA error.