Question

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***

Group Tags

Comments

Keep up to date on this post and subscribe to comments

August 20, 2019 - 11:38am

Hi Niti Solanki,

Can you provide me functionality of UDF you are using for extracting blob content from pzpvstream and where you are using the UDF?

Thanks

August 20, 2019 - 12:00pm

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.

August 21, 2019 - 2:19am
Response to LaurenceB_GCS

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.?

 

Mod
August 20, 2019 - 12:44pm

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,

Lochana | Community Moderator | Pegasystems Inc.

August 21, 2019 - 2:22am
Response to Lochan_DV

Hello @Lochan_DV

Thankyou for your reply.

We have raised SR-D38026 to Pega Support team.

Thanks,

Niti

Mod
August 21, 2019 - 2:59am
Response to NitiS22

Thank you!

Lochana | Community Moderator | Pegasystems Inc.

Pega
August 21, 2019 - 5:08am

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