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.

 

Published September 14, 2015 - Updated October 8, 2020


100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.