BUG-000153336 for ArcGIS GIS Server

Bug ID Number	BUG-000153336
Submitted	October 28, 2022
Last Modified	June 5, 2024
Applies to	ArcGIS GIS Server
Version found	10.9.1
Operating System	Windows Server
Operating System Version	2019 64 Bit
Status	As Designed

Additional Information

The geometry coordinates have a scale of 10: X: 2683453.1229999997 ----> "1229999997" Y: 1247958.1229999997 -----> "1229999997" Double fields X and Y, that is numeric field in the relational data store with precision and scale (38,8). When trying to enter a value of a greater scale (10 in this case) to a field of a smaller scale (8), the database rounds it to nearest complete number. Hence resulting in the values: X: 2683453.123 Y: 1247958.123 It is not a loss of precision but the default behavior. In order to preserve the scale, use the smaller scale (Less then equal to 8 in this case).

Workaround

The geometry coordinates have a scale of 10:

X: 2683453.1229999997 ----> "1229999997"

Y: 1247958.1229999997 -----> "1229999997"

Double fields X and Y, that is numeric field in the relational data store with precision and scale (38,8). When trying to enter a value of a greater scale (10 in this case) to a field of a smaller scale (8), the database rounds it to nearest complete number. Hence resulting in the values:

X: 2683453.123

Y: 1247958.123

It is not a loss of precision but the default behavior. In order to preserve the scale, use the smaller scale (Less then equal to 8 in this case).