topic Arithmetic Overflow error when querying SDE_spatial_references table in Data Management Questions

Arithmetic Overflow error when querying SDE_spatial_references table

MeleKoneya — Fri, 11 Apr 2014 17:19:17 GMT

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

Re: Arithmetic Overflow error when querying SDE_spatial_references table

VinceAngelo — Mon, 14 Apr 2014 13:15:48 GMT

If DBCC is returning errors, you probably want to be talking with Tech Support.

- V

Re: Arithmetic Overflow error when querying SDE_spatial_references table

MeleKoneya — Mon, 14 Apr 2014 15:57:26 GMT

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.