Arithmetic Overflow error when querying SDE_spatial_references table

184
2
04-11-2014 10:19 AM
Highlighted
Regular Contributor
When querying our SDE_spatial_references table with SQL Server Management Studio,    I get the following error:

"An error occurred while executing batch. Error message is: Arithmetic Overflow."  

We also run a DBCC CHECKDB weekly on our databases and it produces this error:

"Column 'munits' value is out of range for data type "float".  Update column to a legal value."

It looks like the problem is with the munits field in one of our rows and I was able to identify which row this occurs in.     I also took a look at our SDE_Layers table and don't see the SRID that is causing the problem listed.  

Has anyone seen this type of error and found a way to resolve it?

Thanks,

Mele
Reply
0 Kudos
2 Replies
Highlighted
Esri Esteemed Contributor
If DBCC is returning errors, you probably want to be talking with Tech Support.

- V
Reply
0 Kudos
Highlighted
Regular Contributor
If DBCC is returning errors, you probably want to be talking with Tech Support.

- V


Thanks Vince,   I will open a tech support incident regarding this issue.
Reply
0 Kudos