nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcSDE 10.2 Underlying DBMS error. Numeric value out of range.

deleted-user-p0IjIb5QrUbx

We have been getting an ???Underlying DBMS error. 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.
I have figured out that it is the numeric fields with the default precision and scale (38 precision, 8 scale.)
If I delete those fields, everything works fine. If I make a new field with a lower precision/scale it works.
If I create a new field with the default precision/ scale it errors as soon as I calculate the values.

Any ideas?

Thanks

Rob

Encuentra más publicaciones etiquetadas con

Accepted answers

deleted-user-p0IjIb5QrUbx

It turned out that I did not have the latest greatest version of the 64 bit sql server client.
Downloaded one from the sql server site and everything seems to be working fine now.

All comments

deleted-user-p0IjIb5QrUbx

It turned out that I did not have the latest greatest version of the 64 bit sql server client.
Downloaded one from the sql server site and everything seems to be working fine now.

JeremyWilliams

Same here, feature pack for sql server 2008 service pack 3 specifically. 32 or 64bit.

ChristopherWhatley

Thanks, guys. A fresh download of the client worked for me as well.

MikeWelch

This worked for me too - thanks!

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:

Selecting features by attributes or manually
Trying to create a layer package
Trying to open a layers attribute table
Identifying - did not error, but did not select any features

Thinhdaihiep

Hi, I have same your issue, the no problem when connect from arcgis 10.7.1

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.