Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

8
Replies
346
Views
SarthakG Member since 2017 9 posts
UnitedHealthcare India PVT Ltd
Posted: Aug 25, 2018
Last activity: Aug 29, 2018
Closed
Solved

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.

To see attachments, please log in.
Data Integration

Posted: 6 years ago

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.

To see attachments, please log in.
Posted: 6 years ago

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.  

To see attachments, please log in.

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

Pega Collaboration Center 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