Enterprise SQL Geodatabase - Numeric (Double) Data Values

2939
1
10-07-2014 07:27 AM
Highlighted
New Contributor

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

Reply
0 Kudos
1 Reply
Highlighted
Regular Contributor III

Try Uninstalling and reinstalling the Sql Server native client 2008 R2, then rebooting the machine. Check if this helps.

Reply
0 Kudos