Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

An error occurred while executing batch. Error message is: Arithmetic Overflow. Expand / Collapse
Author
Message
Posted Wednesday, February 20, 2013 2:57 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:55 PM
Points: 13, Visits: 69
Greetings SQL Server Pros,

I ran into a problem that was a first for me today. I queried a table and received this error:


Query:
Select * from customers
"An error occurred while executing batch. Error message is: Arithmetic Overflow."

Now there are no calculated fields in this table - there is one clustered index on the table.

The table itself has 7,174,281 records in it and is about 2240 MB in size. It has plenty of room to grow as well. My first thought was there has to be some corrupted data in there. I have looked into the DBCC Checktable - But I wanted to see if anyone had any recommendations or thoughts on the matter? Has anyone encountered this problem when just selecting from a table without any calculations?

Thanks,

Scott
Not yet a pro but by no means a rookie....


Post #1422327
Posted Wednesday, February 20, 2013 3:51 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 546, Visits: 1,062
Was this by chance originally a SQL 2000 database?
Post #1422338
Posted Wednesday, February 20, 2013 3:58 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:55 PM
Points: 13, Visits: 69
Yes it was.
Post #1422344
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse