Question
W&W
DE
Last activity: 7 Jun 2019 9:55 EDT
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:
- We received a numerical value (e.g. ‘123.56’) in a string from a service
- 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’).
- 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.
Hi community,
while fixing an issue in one of our Pega applications we made the following observation:
- We received a numerical value (e.g. ‘123.56’) in a string from a service
- 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’).
- 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.
- We fixed this behavior following the solution described in this community thread https://collaborate.pega.com/question/one-decimal-column-pega-table-defined-wrongly (we altered the column to Decimal(20,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****
Accepted Solution
W&W
DE
Hi coher,
thanks for your quick reply.
Originally the column was set to Decimal(18,0). To solve the problem we altered it to Decimal(20,2).
When I started to write this comment I wanted to recreate the 'problem' step by step to give you a detailed description. After creating a small data transform for test purposes I realized that there was a total misunderstanding on my side about the handling of the source string when it was passed into the target double. I thought the decimal places should have been lost in the double property. Shame on me - the decimal places were passed to the property and saved in the DB's BLOB. So, there was no miracle behind this behavior. Because of the false column settings it's totally clear that the saved value was shown there without the decimal places.
I'm really sorry for wasting everybody's time.
Regards
Olaf
PEG
US
Hi Olaf,
Probably different conversion code was used for each, with different results. You don't say how the column is/was defined, nor do you say how the property in the blob was stored. Once you clearly identified the value as a decimal (or double), both knew exactly what to do.
Accepted Solution
W&W
DE
Hi coher,
thanks for your quick reply.
Originally the column was set to Decimal(18,0). To solve the problem we altered it to Decimal(20,2).
When I started to write this comment I wanted to recreate the 'problem' step by step to give you a detailed description. After creating a small data transform for test purposes I realized that there was a total misunderstanding on my side about the handling of the source string when it was passed into the target double. I thought the decimal places should have been lost in the double property. Shame on me - the decimal places were passed to the property and saved in the DB's BLOB. So, there was no miracle behind this behavior. Because of the false column settings it's totally clear that the saved value was shown there without the decimal places.
I'm really sorry for wasting everybody's time.
Regards
Olaf
Updated: 7 Jun 2019 9:54 EDT
PEG
US
Olaf,
It was far from a waste of time. Sometimes we just need a nudge to think about something in the right way. I'd like to think I was actually of some help!