Arithmetic Overflow error when querying SDE_spatial_references table

358
2
04-11-2014 10:19 AM
MeleKoneya
Occasional Contributor III
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
0 Kudos
2 Replies
VinceAngelo
Esri Esteemed Contributor
If DBCC is returning errors, you probably want to be talking with Tech Support.

- V
0 Kudos
MeleKoneya
Occasional Contributor III
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.
0 Kudos