laptop and a wrench

Bogue

Decimal values set on the SQL Server REAL data type in ArcMap do not persist when published to Portal for ArcGIS.

Dernière publication: September 30, 2019 Portal for ArcGIS
Numéro d’ID de bogue BUG-000125547
EnvoiSeptember 25, 2019
Dernière modificationDecember 4, 2025
S’applique àPortal for ArcGIS
Version trouvée10.7.1
Système d’exploitationN/A
Version du système d’exploitationN/A
StatutWill Not Be Addressed

Informations supplémentaires

The team apologizes for being unable to address this issue within the current product support cycle. If the issue continues to affect any work with map services published from ArcGIS Pro to a supported release of ArcGIS Enterprise, please contact Esri Support Services.

Solution de contournement

Use the CAST function in the Query Layer SQL statement and change the REAL data type field to the Float data type.

For example: 

  1. Select Scada_Tag, DateTime, and CAST(Most_Recent AS FLOAT) AS Most_Recent from scadadata.dbo.Scada_Most_Recent_vw.
  2. In ArcMap > Scada_Most_Recent_vw, set the decimal values on the Most_Recent field (right-click the field > Properties > Numeric > Number of decimal places: 2).
  3. Publish the map service to Portal for ArcGIS.

 

Étapes pour reproduire

ID de bogue: BUG-000125547

Logiciel:

  • Portal for ArcGIS

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement