Support Article
Error while running the report definition post upgrade
SA-14027
Summary
Getting a error on running a Report definition which has unexposed column, and this unexposed column values are exceeding the limit checked by pr_read_from_stream UDF.The error occured post upgrade from PRPC 6.3 to Pega 7.1.8.
Error Messages
"** An error occured on executing the query for the report definition - There was a problem getting a list: code: 24345 SQLState: 99999 Message: ORA-24345: A Truncation or null fetch error occurred"
Steps to Reproduce
Run the report definition(RD) from the the developer portal. And the RD has unexposed columns, with some of the column values exceeding limit imposed by pr_read_from_stream.
Root Cause
Its a pegasystems current behavior, being considered for enhancement, FDBK-10934 and FDBK-10933.
Resolution
Expose the property and running the column population tool to fix the issue.
Tags:
Published September 14, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.