Error while running the report definition post upgrade
SummaryGetting 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.
"** 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 ReproduceRun 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 CauseIts a pegasystems current behavior, being considered for enhancement,
FDBK-10934 and FDBK-10933.
ResolutionExpose the property and running the column population tool to fix the issue.
Published September 14, 2015 - Updated October 8, 2020