laptop and a wrench

Bug

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

Zuletzt veröffentlicht: September 30, 2019 Portal for ArcGIS
Bug-ID-Nummer BUG-000125547
EingereichtSeptember 25, 2019
Zuletzt geändertDecember 4, 2025
Gilt fürPortal for ArcGIS
Gefunden in Version10.7.1
BetriebssystemN/A
BetriebssystemversionN/A
StatusWill Not Be Addressed

Zusätzliche Informationen

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.

Workaround

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.

 

Schritte zur Reproduzierung

Bug-ID: BUG-000125547

Software:

  • Portal for ArcGIS

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln