Question
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.
sure, will check that. but it was working fine till last week, not sure how it fails now.
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.
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.
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.
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.