mkoneya

Arithmetic Overflow error when querying SDE_spatial_references table

Discussion created by mkoneya on Apr 11, 2014
Latest reply on Apr 14, 2014 by mkoneya
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

Outcomes