SQLSTATE 22003 Error 220. The Step Failed

  • Hi DBA's

    Could someone help with my problem.

    Im running my JOBS when error appeared:

    Executed as user: [domain\username]. Arithmetic overflow for data type smallint, value = 48490. [SQLSTATE 22003] [Error 220]. The step failed.

    How can i fix this? what cause of this error?

    Im just a newbie... hope you could help me with this.

    Waiting for response..... Thanks!

  • Executed as user: [domain\username]. Arithmetic overflow for data type smallint, value = 48490. [SQLSTATE 22003] [Error 220]. The step failed.

    Your job is trying to store the value 48490 in a smallint datatype. The maximum you can store in a smallint is 32767 (or -32768).

  • 😀 yah. Thanks

    I already chnged smallint to int.

    Its solved my problem. 😀

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply