AnsweredAssumed Answered

Enterprise SQL Geodatabase - Numeric (Double) Data Values

Question asked by emerson917 on Oct 7, 2014
Latest reply on Mar 6, 2015 by asengupta-esristaff

Hello,

I've began using the Create and Enable Enterprise Geodatabase tools to manage my GIS data in SQL Server as opposed to directly installing SDE. I've been successful in creating and importing new datasets, unless I include an attribute field of type "double". When I do this and try to calculate a value in ArcMap the feature disappears and the attribute table will no longer display, giving me the following error instead:

 

Could not load data from data source.......Underlying DBMS error [[Microsoft][SQL Server Native Client 10.0]Numeric value out of range]

 

The layer pretty much become unusable in ArcMap or ArcCatalog at this point.

 

The precision is 38 and the scale is 8 by default. Even adjusting these values in Management Studio doesn't seem to fix anything. I'm running ArcGIS Desktop 10.2.2 and SQL Server 2008R2.

 

Does anybody have any ideas or suggestions as to why this is happening and how to correct it?

 

Thanks in advance,
Rich

Outcomes