topic Re: ArcSDE 10.2 Underlying DBMS error. Numeric value out of range. in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360533#M13997 <HTML><HEAD></HEAD><BODY><SPAN>Thanks, guys.&nbsp; A fresh download of the client worked for me as well.</SPAN></BODY></HTML> Tue, 04 Mar 2014 15:02:28 GMT ChristopherWhatley 2014-03-04T15:02:28Z ArcSDE 10.2 Underlying DBMS error.  Numeric value out of range. https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360530#M13994 <HTML><HEAD></HEAD><BODY><SPAN>We have been getting an ???Underlying DBMS error.&nbsp; Numeric value out of range.??? Error when we try to select features from data in ArcSDE 10.2 (SQL Server 2008 R2) after upgrading to ArcGIS 10.2.</SPAN><BR /><SPAN>I have figured out that it is the numeric fields with the default precision and scale (38 precision, 8 scale.)</SPAN><BR /><SPAN>If I delete those fields, everything works fine.&nbsp; If I make a new field with a lower precision/scale it works.</SPAN><BR /><SPAN>If I create a new field with the default precision/ scale it errors as soon as I calculate the values.</SPAN><BR /><BR /><SPAN>Any ideas?</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><BR /><SPAN>Rob</SPAN></BODY></HTML> Mon, 12 Aug 2013 17:22:17 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360530#M13994 deleted-user-p0IjIb5QrUbx 2013-08-12T17:22:17Z Re: ArcSDE 10.2 Underlying DBMS error. Numeric value out of range. https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360531#M13995 <HTML><HEAD></HEAD><BODY><SPAN>It turned out that I did not have the latest greatest version of the 64 bit sql server client.</SPAN><BR /><SPAN>Downloaded one from the sql server site and everything seems to be working fine now.</SPAN></BODY></HTML> Tue, 13 Aug 2013 18:13:40 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360531#M13995 deleted-user-p0IjIb5QrUbx 2013-08-13T18:13:40Z Re: ArcSDE 10.2 Underlying DBMS error. Numeric value out of range. https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360532#M13996 <HTML><HEAD></HEAD><BODY><SPAN>Same here, feature pack for sql server 2008 service pack 3 specifically.&nbsp; 32 or 64bit.</SPAN></BODY></HTML> Fri, 13 Sep 2013 14:48:07 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360532#M13996 JeremyWilliams 2013-09-13T14:48:07Z Re: ArcSDE 10.2 Underlying DBMS error. Numeric value out of range. https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360533#M13997 <HTML><HEAD></HEAD><BODY><SPAN>Thanks, guys.&nbsp; A fresh download of the client worked for me as well.</SPAN></BODY></HTML> Tue, 04 Mar 2014 15:02:28 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360533#M13997 ChristopherWhatley 2014-03-04T15:02:28Z Re: ArcSDE 10.2 Underlying DBMS error. Numeric value out of range. https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360534#M13998 <HTML><HEAD></HEAD><BODY><SPAN>This worked for me too - thanks!</SPAN><BR /><BR /><SPAN>I also wanted to add the the following options also yielded the same "numeric value out of range" error in case others have similar problems:</SPAN><BR /><BR /><UL><BR /><LI>Selecting features by attributes or manually</LI><BR /><LI>Trying to create a layer package</LI><BR /><LI>Trying to open a layers attribute table</LI><BR /><LI>Identifying - did not error, but did not select any features</LI><BR /></UL></BODY></HTML> Tue, 22 Apr 2014 18:56:10 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/360534#M13998 MikeWelch 2014-04-22T18:56:10Z Re: ArcSDE 10.2 Underlying DBMS error.  Numeric value out of range. https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/1327137#M37094 <P>Hi, I have same your issue, the no problem when connect from arcgis 10.7.1</P> Mon, 11 Sep 2023 03:44:45 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcsde-10-2-underlying-dbms-error-nbsp-numeric/m-p/1327137#M37094 Thinhdaihiep 2023-09-11T03:44:45Z