Arithmetic overflow error - by jhdafg

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 282884 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 6/14/2007 12:04:19 PM
Access Restriction Public


when running sp_helpdb on a VLDB (~30TB) we receiving the following message:
Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Sign in to post a comment.
Posted by Peter [MSFT] on 11/28/2007 at 12:55 PM
This should be fixed in the just released CTP of SQL Server 2008. Please let us know if that is not the case.
Posted by Peter [MSFT] on 6/22/2007 at 7:59 AM

This should be fixed for the release after next SQL 2008 CTP release - CTP 5.

Thank you for the report.
Posted by Peter [MSFT] on 6/19/2007 at 7:26 AM
Thank you for the data.

There is code in sp_helpfile that multiplies the size from sys.sysfiles by 8 to calculate the number of kilobytes. Unfortunately, this will overflow the INT value for these files.

37 10 320000000 320000000 10 1048578 0 link_7_1 R:\link_7_1.ndf
38 10 320000000 320000000 10 1048578 0 link_7_2 X:\link_7_2.ndf
39 10 320000000 320000000 10 1048578 0 link_7_3 Y:\link_7_3.ndf
40 10 320000000 320000000 10 1048578 0 link_7_4 M:\link_7_4.ndf
41 10 320000000 320000000 10 1048578 0 link_7_5 N:\link_7_5.ndf
42 10 320000000 320000000 10 1048578 0 link_7_6 O:\link_7_6.ndf
43 10 320000000 320000000 10 1048578 0 link_7_7 Q:\link_7_7.ndf

The workaround would be to reduce the size of these files to 2,097,151 MB or smaller. This should avoid the overflow.

We will fix this for the next release of SQL Server. If you need fix for SQL 2005 sooner then that, you should open a request with product support.

Thank you again.
Posted by jhdafg on 6/19/2007 at 6:24 AM
the other feedback item is posted here:

I suspect these are related.
Posted by jhdafg on 6/19/2007 at 6:14 AM
I've attached a file with the results of querying sys.database_files and sys.sysfiles. Also, sp_helpfile executes properly and returns results.

I think this error is connected to an identical error we're seeing when viewing database properties in the Management Studio (also posted here)...which is actually a much bigger problem but I haven't seen any comment or response on yet.

THANK YOU for the help.
Posted by Peter [MSFT] on 6/14/2007 at 2:52 PM
Thank you for the report.

Could you please send us the contents of your sysfiles and sys.database_files tables in the VLDB in question?


SELECT * FROM vldb.sys.database_files
SELECT * FROM vldb.sys.sysfiles

You might also see if running just sp_helpfile in the VLDB database gets a similar error.

Thank you.