laptop and a wrench

Bug

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

Last Published: September 30, 2019 Portal for ArcGIS
Bug ID Number BUG-000125547
SubmittedSeptember 25, 2019
Last ModifiedJuly 28, 2020
Applies toPortal for ArcGIS
Version found10.7.1
StatusIn Review

Workaround

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

For example: 

  1. Select Scada_Tag, DateTime, CAST (Most_Recent as float) as Most_Recent from scadadata.dbo.Scada_Most_Recent_vw
  2. Then in ArcMap > Scada_Most_Recent_vw set the decimal values on the Most_Recent (Right-click the field > Properties > Numeric > (Number of decimals places: 2).
  3. Publish the map service to Portal for ArcGIS.

 

Steps to Reproduce

Bug ID: BUG-000125547

Software:

  • Portal for ArcGIS

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options