Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Corrupted values in report output that uses UDFs

SA-24898

Summary



Some values are corrupted when report definitions that retrieve content from the BLOB are run through the User Defined Functions (UDFs). Special characters or unreadable characters appear. This does not occur with all output records. The properties appear fine when the objects with corrupted data are viewed using Clipboard viewer. The issue appears only on the report definition output.

Error Messages



Not Applicable

Steps to Reproduce



Run a report definition that retrieves content from the BLOB.

Root Cause



A defect or configuration issue in the operating environment:
he Oracle UDFs were corrupt and did not work properly. This may occur if the UDFs are backed up and restored (and there are errors during restoration), or if the UDFs are replicated from one environment to another.

Resolution



Make the following change to the operating environment:
1. Drop completely and reload Pega UDFs in the environment.
2. Refer to the Support Article given below to drop and reload the UDFs.
    https://pdn.pega.com/support-articles/how-install-user-defined-functions-udfs
3. Utilize a database user with Deployment User privileges as defined in the installation manual.
Suggest Edit

Published June 30, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us