Change Log Table: Incorrect Number Format

[lyrobnik]

Hello Team,

We have noticed an issue on the Change log table: sometimes numbers are rendered in an incorrect format.

Is this a known issue and could you please provide any help to fix this?

Thanks & Regards,
Lydia

[lyrobnik]

In this example the number 8,000 (old value) was changed to 500 (new value):

[jonasdutzisap]

Hi @nkaputnik,

could you please give an update?
Are you aware of the issue and maybe already working on it? :)

Best regards,
Jonas

[nkaputnik]

Hello @jonasdutzisap could you perhaps create a small reproducible example for us to debug it?

Best,
Nick

[lyrobnik]

Hi @nkaputnik, like discussed I provided you access to our system to reproduce the issue.

CC @jonasdutzisap

[Sv7enNowitzki]

Hi @lyrobnik ,

Providing this only for the online environment may not be ideal, as we might need to understand some of the related code on how this result is produced in order to reproduce and attempt to resolve it. Could you please provide some relevant examples for us?

In addition, please also grant me partial access.

Best Regards,
Wenjun

[Sv7enNowitzki]

Hello @lyrobnik ,

Based on my analysis, I found that this issue is caused by the use of the hdb driver. It appears that when using hdb or hana-client in the project, such problems occur with Decimal fields. Starting from CDS8, CAP strongly recommends replacing these two drivers with cap-js/hana. You can refer to the specifics here.

Similar issue has also been mentioned in the CAP issues:
https://github.tools.sap/cap/issues/issues/15074

If you use the new driver, your issue won't arise anymore. Therefore, for change tracking, no fixes are currently needed.

Therefore, I suggest testing this issue again when you upgrade to CDS 8 and set cap-js/hana as the new driver. If the issue still persists, please contact us again.

Best Regards,
Wenjun