ORA-24345: A Truncation or null fetch error occurred while fetching the report.
PEGA version 7.1.8 and ORACLE 11G
We have a report definition which contains the Text property Which is in BLOB and have more than 4000 characters data in it. While Running this report definition we are getting an Error "ORA-24345: A Truncation or null fetch error occurred".
UDF function is available in production & property is present in pyWorkpage which is unexposed (which is present in Blob). We have added the property in report definition and while running the report we are receiving an error . Same functionality is working for other Text property which has less than 4000 characters .We want to fetch the report with the property having more than 4000 characters . Please provide any resolution for this.
***Edited by Moderator: Lochan to tag SR***
Tekclan
IN
PEG
GB
You may want to raise a case with the support team for this one, and ask if this is the same problem as defined in HFix-35518 (for 7.1.7).
And if so request for the hotfix to be ported or advise on a higher version where the problem is resolved in a GA release.
Vodafone
US
Hello @LaurenceB_GCS
Thankyou for your reply.
We have raised this issue with support team and they have provided some hotfixes but that seems to be not working in this case. And those hotfixs are different from the above mentioned hotfix. We have pega 7.1.8 and Oracle 11g DB.
Is the same working at your end.?
Pegasystems Inc.
IN
Hi Niti,
Please let us know the SR# in case you create one. We will tag it to this post and continue tracking it.
Regards,
Vodafone
US
Hello @Lochan_DV
Thankyou for your reply.
We have raised SR-D38026 to Pega Support team.
Thanks,
Niti
Pegasystems Inc.
IN
Currently, it is a limitation in Pega.
Please refer following article https://community.pega.com/support/support-articles/error-while-running-report-definition-post-upgrade