BUG-000153336 for ArcGIS GIS Server

Número de ID do Erro	BUG-000153336
Enviado	October 28, 2022
Última Modificação	June 5, 2024
Aplica-se à	ArcGIS GIS Server
Versão encontrada	10.9.1
Sistema Operacional	Windows Server
Versão do Sistema Operacional	2019 64 Bit
Status	As Designed

Informações Adicionais

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).

Solução Provisória

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).