Error while running the report definition post upgrade
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.
"** 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.
Its a pegasystems current behavior, being considered for enhancement, FDBK-10934 and FDBK-10933.
Expose the property and running the column population tool to fix the issue.
100% found this useful