Question

3
Replies
106
Views
Olaf_Jaeger Member since 2015 1 post
W&W
Posted: June 5, 2019
Last activity: June 7, 2019
Closed
Solved

Different data in column and BLOB (missing decimal places)

Hi community,

while fixing an issue in one of our Pega applications we made the following observation:

  1. We received a numerical value (e.g. ‘123.56’) in a string from a service
  2. In a data transform this value was passed directly (no casting) into a double property (this is already fixed and now we do a proper casting with ‘@pyStringToDouble’).
  3. After saving the quote object on our DB table DATA.SFAI_WORK_QUOTE we realized that the values that were stored in the exposed column (ANNUALPREMIUM) and the BLOB were different:

As you can see, the decimal places were not stored in the exposed column but in the BLOB.

  1. We fixed this behavior following the solution described in this community thread https://community1.pega.com/community/product-support/question/one-decimal-column-pega-table-defined-wrongly (we altered the column to Decimal(20,2) )
  2. Everything works fine now and the same values are saved in column and BLOB.

The problem does not occur anymore and everybody is happy. ;-)

BUT ... there is still an open question. Can anyone explain why the data was stored differently in the column and the BLOB before the fix? Ok, we handled the data the wrong way and the column was not properly set up, but usually I expect that the values in column and BLOB should be the same. So why were the decimal places saved in the BLOB?

Regards

Olaf

***Edited by Moderator Marissa to update platform capability tags****

Data Integration
Moderation Team has archived post
Share this page LinkedIn