Getting unexpected characters when fetching data from blob
Hi Everybody,
When I'm fetch data from blob using DB tool using pr_read_from_stream(), I'm getting some unexpected characters (DB output:- "MAITREJ䩅AN").
When I fetch the data using report definition and check the results in tracer, I get the same value.
But when I open object using obj-open and then check the data in tracer, I don't get these unexpected characters (Output using obj-open:- "MAITREJEAN").
I have also noticed that this is happening mostly when the length of value is greater than or equal to 10. Can anyone please help me with this.
Accepted Solution
Coforge DPA
GB
Hi
Have a look at below link :
https://collaborate.pega.com/question/few-data-elements-are-truncated-when-read-data-blob
It mentions the sporadic issue with Oracle database with UDF functions.
Regards
Bhavya
UnitedHealthcare India PVT Ltd
IN
I tried inserting some larger values in blob
1. Value inserted:- "ABCDEFGHIJKLM"
Value returned by DB tool and Report definition:- "ABCDEFGHIJ䩋LM"
Value returned by obj-open:- "ABCDEFGHIJKLM"
2. Value inserted:- "ABCDEFGHIJKLMNOPQR"
Value returned by DB tool and Report definition:- "ABCDEFGHIJKLMNO佐QR"
So apparently, the third last character is getting changed to some random character.
UnitedHealthcare India PVT Ltd
IN
On further probing I found out that this is not happening in other environments. So most probably, there is something wrong with the way Database server was configured for this specific environment.
Accepted Solution
Coforge DPA
GB
Hi
Have a look at below link :
https://collaborate.pega.com/question/few-data-elements-are-truncated-when-read-data-blob
It mentions the sporadic issue with Oracle database with UDF functions.
Regards
Bhavya