numeric out of range 1264 out of range value

Question

I have table X with 2 columns Address ( varchar ) , Date ( int ). I want to drop column address so that I run this command:

alter table x drop column address

I get the error message: numeric out of range: 1264 out of range value for column date at row 1.

• I check all values in Date column and they are still ok ( smaller than the maximum length of int type ).
• I try to change type from int to bigint and set all values in date column to null but I still get this error message.
• This issue happends on my UAT server, It works well at my local. Can anyone explain this?