Question
PerseusX Incorporated
US
Last activity: 8 Mar 2018 13:09 EST
Few data elements are truncated when read data from BLOB
Hi,
When user read data from BLOB column, few characters are truncated in the middle or end of the data.
This issue is sporadic, what to know how to fix the issue, is it pega expected behavior on BLOB column?
I know we can fix this issue by exposing specific columns, looking some pega experts review here.
Pegasystems Inc.
US
Are you using the UDF functions to read the data from the blob column? Typically this is an symptom of something is wrong with the UDF installation and you should drop and reinstall them. We have seen this when UDFs are copied from one schema to another or restored from backup using a DB tool.
PerseusX Incorporated
US
sure, will check that. but it was working fine till last week, not sure how it fails now.
Pegasystems Inc.
AU
Corruption of the pr_read_from_stream, pr_read_decimal_from_stream, pr_read_int_from_stream User Defined Functions has been observed on occasion on Oracle when cloning databases.
Removing those UDF's and executing generateudf.bat or generateudf.sh should resolve this issue, should it be the same issue.
Posting an example of the truncation would be helpful in diagnosing.
PerseusX Incorporated
US
if you have any user guide for UDF installation, share it
Pegasystems Inc.
US
I suggest you to raise an SR for getting this information from customer support engineer depends on the Pega version you are using to get the desired instructions.
Pegasystems Inc.
US
What version of Pega are you on? In later versions in the scripts directory of the media there is a generateudf script that can be used to install the UDFs. You would just drop the existing ones and then use the script to reinstall them.
Accepted Solution
PerseusX Incorporated
US
UDF functions are reinstalled