Bug
Decimal values set on the SQL Server REAL data type in ArcMap do not persist when published to Portal for ArcGIS.
| Bug ID Number | BUG-000125547 |
|---|---|
| Submitted | September 25, 2019 |
| Last Modified | December 4, 2025 |
| Applies to | Portal for ArcGIS |
| Version found | 10.7.1 |
| Operating System | N/A |
| Operating System Version | N/A |
| Status | Will Not Be Addressed |
Additional Information
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:
- Select Scada_Tag, DateTime, and CAST(Most_Recent AS FLOAT) AS Most_Recent from scadadata.dbo.Scada_Most_Recent_vw.
- 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).
- 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
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App