Getting error while running maintenance plan

Question

Microsoft SQL-DMO (ODBC SQLState: 22003)] Error 220: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 65535.                                                                                          
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 65535.                                                                                                                                                
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.                                                                                                                                                                              
NULL

Answer 1

Hi,

What's your maintenance plan doing?  Please provide details.

You're getting the arithemetic overflow message because something in the plan is trying to insert the value 65535 into a field that accepts values between -2^15 (-32,768) to 2^15-1 (32,767) (http://msdn.microsoft.com/en-us/library/ms187745.aspx)

---

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Answer 2

for what, you are using maintenance plan  please share more details

---

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Answer 3

it is just index rebuild maintenace plan.

Answer 4

are you using the native SQL Server task?

I recommend using this popular index maintenance utility fromL: http://ola.hallengren.com/

Please post your SQL Server version and OS

---

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Answer 5

have you created the maintenance plan with the same SQL Server Management Studio version as the SQL Server executing the maintenance plan?

SSMS 2012 may generate incompatible packages on older version of SQL Server.

Answer 6

Hi RovalM,

An arithmetic overflow is caused by a calculated column value that exceeds the column's specified size. When this error occurs, the calculation stops and the remainder of the results pane is not filled.

For more information, please refer to http://msdn.microsoft.com/en-us/library/ms163363(v=sql.105).aspx.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.